And yes Somehow This works the table thing but not an efficient way but
its better than nothing
. Thanks for your help steve. still curious
about that msg which is displayed once you click on the link.
chris1980 wrote:
> hey. i tried to make a field by the name of attachment in the table and
> then created a text box in the form so then the hyperlink i have in my
> table will automatically appear in the form but when i click on the
> hyperlink in the form it says that (hyperlinks can be harmful only use
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12832-adding-an-attachment-view-file-form.html
> trusted sources, etc) if you click yes the document opens if no then it
> does not open the document. can i get rid of that message?
> chris1980 wrote:
> > i have already tried that api code. i created a module and copied the
> > code in a standard module but it gives me an error on StrFilter for
> > some reason i am still trying to debug that problem. and i was reading
> > these forums MSaccess i have seen a guy posting that he already have
> > created a button to attach a file in a form but his question was how to
> > submit that form through email or something like that. the second
> > process you told me i believe that all the users who are entering the
> > data in the form need to enter a valid path of the file in the table
> > and then add that Onclick procedure you just give me to view it. IS
> > this the only efficient way to do it? Anyways thanks for your help and
> > i will try to do this thing rite now i have been wrokin on it 2 weeks
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> > nights and days searching cause i think everything is possible .
> > Appreciate that i will keep you updated.
> > Thanks
> > Steve Schapel wrote:
> > > Chris,
> > >
> > > Ok, just to clarify, you can't literally attach a file to the record.
> > > What you are doing is entering the path/name of the file into a field in
> > > the table.
> > >
> > > So, there are two separate processes.
> > >
> > > One is the process of entering the file's path/name into the database.
> > > The simplest method, of course, is to just type it in (assuming you know
> > > it!) If you want the user to have access to a file explorer/selection
> > > dialog, you will need to use some API code. There is some good
> > > information on this at http://www.mvps.org/access/api/api0001.htm
> > >
> > > The other is, once the file's path/name is entered into the database, to
> > > open that file for the current record. If the file's path/name is
> > > entered into a field with a hyperlink data type, you can just click on
> > > the textbox on the form, and the file should open. An alternative
> > > approach, if you want to use a command button to open the file, is to
> > > use code like this...
> > > Application.FollowHyperlink Me.NameOfFieldWithFileName
> > >
> > > --
> > > Steve Schapel, Microsoft Access MVP
> > >
> > >
> > > chris1980 wrote:
> > > > Thanks for replying Steve. when a user clicks on AddaFile button it
> > > > will let the user choose a file from his Computer hard drive like the
> > > > file name is ISSUE2. when he clicks on that addafile button i want him
> > > > to add an attachment file to that record so that for our superiors when
> > > > they access the database they can see the file directly in the record
> > > > related to that that Issue rather than emailing them personally. there
> > > > is always a different issue file for each record. and for viewing i
> > > > think once i am able to attach a file for that specific record the user
> > > > will be automatically able to view that file whatever format the file
> > > > is. i am still on computer so i will be answering your questions.