VBA equivalent for Save As action in Quick Access Menu

[HH]

I'm still searching for a VBA equivalent for the Save As action, which
is available in the Quick Access Menu. This function is very helpful,
because it allows me to make a clean copy of the entire project which
is currently in use.

 

[Arvin Meyer [MVP]]

I'm still searching for a VBA equivalent for the Save As action, which
is available in the Quick Access Menu. This function is very helpful,
because it allows me to make a clean copy of the entire project which
is currently in use.

SaveAs does not save the entire database. It does save the current object,
which must be selected in code before saving, the last argument (True or
False) lets Access know whether or not the object is open (False is Open,
True means that it is in the database window. The default is False):

DoCmd.SelectObject acForm, "frmAnyForm", True
DoCmd.RunCommand acCmdSaveAs