Save As Dialog Box

[Guest]

I need to know how to invoke the File SaveAs dialog box when generating a
file in VBA in an Access 2000 database. I'm sure it is something simple but
I need to save a file that I am creating in the program to the user's desired
location.

 

[RoyVidar]

I need to know how to invoke the File SaveAs dialog box when
generating a file in VBA in an Access 2000 database. I'm sure it is
something simple but I need to save a file that I am creating in the
program to the user's desired location.

Check out this http://www.mvps.org/access/api/api0001.htm

 

[Douglas J. Steele]

Check out this http://www.mvps.org/access/api/api0001.htm

Just to tag onto Roy's answer.

If I recall correctly, you have to use the API approach, because the File
SaveAs dialog associated with the control that's part of Office doesn't work
properly.