adding an attachment and view a file in a form

#10 (**permalink**) 28-Jul-2006, 08:33 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12832-adding-an-attachment-view-file-form.html
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
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
> nights and days searching cause i think everything is possible

.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> 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.

#11 (**permalink**) 28-Jul-2006, 08:33 AM

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
> 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
> > nights and days searching cause i think everything is possible

.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> > Appreciate that i will keep you updated.
> > Thanks
> > Steve Schapel wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> > > 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.

#12 (**permalink**) 28-Jul-2006, 08:35 AM

Sorry, Chris, I have not encountered this. What type of files are they?

--
Steve Schapel, Microsoft Access MVP

chris1980 wrote:
> hey. i tried to make a field by the name of attachment in the table and
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> then created a text box in the form so then the hyperlink i have in my
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> 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
> 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?

#13 (**permalink**) 28-Jul-2006, 08:35 AM

Chris,

Just to summarise/clarify...

The path/file name ultimately needs to be entered into the table in any
case. No matter what method you use to access the file, its path and
name need to be recorded in the table. Normally this will be done via
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
the form interface. So in this regard, really the choices are either to
enter the path/file name by typing it into a textbox, or to enter the
path/file name by selecting it from the Windows File common dialog,
which is what the API code is all about. But the end result is still
the same - the path and name of the file is recorded in a field in a table.

And then, there is the question of accessing the file from within the
database application. Again, two choices. Either the field you use to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
store the path/file name is a hyperlink data type, and you open the file
by clicking directly on the form control. Or you use some other event,
such as clicking a command button, in which case you need to use code.
The FollowHyperlink method I mentioned is one approach - there are others.

So (apart form the "unsafe hyperlink" warning message you are getting),
is there any problem with any of this? I am not sure I understand what
you mean about efficiency.

--
Steve Schapel, Microsoft Access MVP

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
> nights and days searching cause i think everything is possible

.
> Appreciate that i will keep you updated.

#14 (**permalink**) 28-Jul-2006, 08:35 AM

I got it steve thanks for all your help and replies i really appreciate
that. Followhyperlink works fine came to know i need to have a # sign
in the beginning and at the end. Thanks alot steve. i am still a newbie
and i am in love now working with access. i try to take the hardest
projetcs which no one can do in my company and do alot of research
learn more so then one day i can be an MVP also

. take care
Thanks
Steve Schapel wrote:
> Chris,
>
> Just to summarise/clarify...
>
> The path/file name ultimately needs to be entered into the table in any
> case. No matter what method you use to access the file, its path and
> name need to be recorded in the table. Normally this will be done via
> the form interface. So in this regard, really the choices are either to
> enter the path/file name by typing it into a textbox, or to enter the
> path/file name by selecting it from the Windows File common dialog,
> which is what the API code is all about. But the end result is still
> the same - the path and name of the file is recorded in a field in a table.
>
> And then, there is the question of accessing the file from within the
> database application. Again, two choices. Either the field you use to
> store the path/file name is a hyperlink data type, and you open the file
> by clicking directly on the form control. Or you use some other event,
> such as clicking a command button, in which case you need to use code.
> The FollowHyperlink method I mentioned is one approach - there are others.
>
> So (apart form the "unsafe hyperlink" warning message you are getting),
> is there any problem with any of this? I am not sure I understand what
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> you mean about efficiency.
>
> --
> Steve Schapel, Microsoft Access MVP
>
>
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
> > 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
> > nights and days searching cause i think everything is possible

.
> > Appreciate that i will keep you updated.

#15 (**permalink**) 28-Jul-2006, 08:35 AM

That's brilliant, Chris. Best wishes.

--
Steve Schapel, Microsoft Access MVP
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12832

chris1980 wrote:
> I got it steve thanks for all your help and replies i really appreciate
> that. Followhyperlink works fine came to know i need to have a # sign
> in the beginning and at the end. Thanks alot steve. i am still a newbie
> and i am in love now working with access. i try to take the hardest
> projetcs which no one can do in my company and do alot of research
> learn more so then one day i can be an MVP also

. take care