what is FileDialog equivalent in Access 97?

[Janie]

needing to pass file path and name to a text box. Reading other answers
along same lines, FileDialog sounds perfect -- however I am working in Access
97. What is an equivalent tool?

 

[Alex Dybenko]

Hi,
you can try this one:
http://www.mvps.org/access/api/api0001.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[RoyVidar]

needing to pass file path and name to a text box. Reading other
answers along same lines, FileDialog sounds perfect -- however I am
working in Access 97. What is an equivalent tool?

I use something like this

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

in all versions.

 

[Douglas J. Steele]

In my opinion, FileDialog isn't perfect in any version of Access.

You're far better off using the all-API approach illustrated in
http://www.mvps.org/access/api/api0001.htm at "The Access Web". It has the
advantage that it's version-independent.

And yes, I'll acknowledge that it looks like a lot of code, but then you
have no idea how much code is hidden in the FileDialog control. All you need
do is copy everything that's in the shaded area between Code Start and Code
End and paste it into a new module (not a class module nor a module
associated with a form or report). You then need to write code like the four
line sample at the top of the page.

 

[Janie]

thanks one and all (and an extra big thanks to Doug for his notes). I like
this. Especially since FileDialog has ruin-time issues.

 

[Douglas J. Steele]

thanks one and all (and an extra big thanks to Doug for his notes). I
like
this. Especially since FileDialog has ruin-time issues.

Freudian slip? <g>