what is FileDialog equivalent in Access 97?

  • Thread starter Thread starter Janie
  • Start date Start date
J

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?
 
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.
 
thanks one and all (and an extra big thanks to Doug for his notes). I like
this. Especially since FileDialog has ruin-time issues.
 
Janie said:
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>
 
Back
Top