How do I prompt the user to specify a directory when entering data into
forms? I know how the FileDialog works....but I only want to create a
variable storing the directory the user chooses. The file name itself is a
built string from other data the user enters, and the path is not dynamic.
Any suggestions? i.e. the field with the filepath is accessing existing files
in a folder, however if the user moves the files to a different location,
they'd have to go into the code to change the directory all of the files are
stored in.

Thanks

See:
Call Windows Browse for Folder Dialog box
at:
http://www.mvps.org/access/api/api0002.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"hmmmm?" <(E-Mail Removed)> wrote in message
news:925AC842-CD9E-4EAF-85F7-(E-Mail Removed)...
> How do I prompt the user to specify a directory when entering data into
> forms? I know how the FileDialog works....but I only want to create a
> variable storing the directory the user chooses. The file name itself is a
> built string from other data the user enters, and the path is not dynamic.
> Any suggestions? i.e. the field with the filepath is accessing existing
> files
> in a folder, however if the user moves the files to a different location,
> they'd have to go into the code to change the directory all of the files
> are
> stored in.
>
> Thanks

Nevermind.....I found some code by Terry Kreft which works fabulously!

http://www.mvps.org/access/api/api0002.htm

cheers

"hmmmm?" wrote:

> How do I prompt the user to specify a directory when entering data into
> forms? I know how the FileDialog works....but I only want to create a
> variable storing the directory the user chooses. The file name itself is a
> built string from other data the user enters, and the path is not dynamic.
> Any suggestions? i.e. the field with the filepath is accessing existing files
> in a folder, however if the user moves the files to a different location,
> they'd have to go into the code to change the directory all of the files are
> stored in.
>
> Thanks

Thanks Allen....I managed to find that code myself......

"Allen Browne" wrote:

> See:
> Call Windows Browse for Folder Dialog box
> at:
> http://www.mvps.org/access/api/api0002.htm
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "hmmmm?" <(E-Mail Removed)> wrote in message
> news:925AC842-CD9E-4EAF-85F7-(E-Mail Removed)...
> > How do I prompt the user to specify a directory when entering data into
> > forms? I know how the FileDialog works....but I only want to create a
> > variable storing the directory the user chooses. The file name itself is a
> > built string from other data the user enters, and the path is not dynamic.
> > Any suggestions? i.e. the field with the filepath is accessing existing
> > files
> > in a folder, however if the user moves the files to a different location,
> > they'd have to go into the code to change the directory all of the files
> > are
> > stored in.
> >
> > Thanks
>
>
>