Transfer Text - Showing a Common File Dialog in a Macro

[Q Johnson]

I know I have done this in the past but can't find the database in which I
did it or a clue in the Help systems of either A2K3, A2000, or A97.

I just want to know what it is I can type on the File Name line for the
transfer text macro that will cause the user to get a Common File dialog
(Open or Save depending on whether the operation is Import or Export) to use
for opening or naming and saving the input or output file.

It was something really simple like: =GetFileName()
or some such.

Thanks in advance.

Q Johnson

 

[Douglas J Steele]

Look at http://www.mvps.org/access/api/api0001.htm at "The Access Web"

 

[Q Johnson]

Thanks for the link, but I don't want to write code for this.

I wrote my own substitute for the common dialog sometime ago and can use it
when I need it.

But in this particular case, I'm almost certain that I didn't need to do
that. There was some native Access function that I was able to call that
accomplished this. I'm trying to get the answer for someone who really
isn't up to VBA solutions. I'm a VB.NET developer and can find solutions
that work for me without TOO much trouble.

But I'm looking for one for this other user. Am I just mistaken about the
existence of this feature?

Q

 

[Douglas J Steele]

Yes, I think you're mistaken.

There is no file dialog function built into Access. It is possible to use
the Common File Dialog object that's in the Office object library, but that
still requires that some code be written (plus it's not very reliable)

Copying that code into a module is pretty painless, though, and then it's
available.

 

[Q Johnson]

OK. Thanks, Doug.

I'll throw something together for my client then.