Macro

[Buffy]

Is there a way that I can create a macro that will bring up the Save As box? ..So that the user does not have to choose File -Save As?

Cheers,

 

[Tanis]

Don't know which version of Access you are using, but you can use the SendKeys method.

SendKeys "%FA"

will achieve the result you want, in Access 97 anyhow.

 

[Buffy]

I am using Access 2000 and I have a user form which I want to put a macro on, so that when the user clicks on it, the save as box will open

 

[Tanis]

Either put the code behind a command button

Private Sub Command1_Click()
On Error Resume Next
SendKeys "%FA"
End Sub

or create a macro with SendKeys as the Action and %FA as the Keystrokes.