Save As... Dialog Box

[Zaph]

nice simple one - using Access 2000, would like to bring up Save As... dialog box thhorugh VBA coding. Is this poss and if so what is the code? Many Thanks in advance.

 

[oharab]

Look at:

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

ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[Tomadams]

Use the activex tool dropdown to select the microsoft common dialog control and paste this onto the appropriate form. Using a command button use the following code to open and get the filename desred
With comdlg1
.Filter = "All Files (*.*)|*.*"
.ShowOpen
End With
FileName = comdlg1.FileName

 

[Tomadams]

sorry - that code should read
With comdlg1
.Filter = "All Files (*.*)|*.*"
.ShowSave
End With
FileName = comdlg1.FileName