Save Backup As

[Anthony George]

Hi Everyone

I want to open the 'Save Backup As' Dialogue Box from the file menu, using a Command Button on a Form in Access 2003.

I know you can do this manually but I would love to do it programically.

Iv'e looked everywhere fo this but it still eludes me.

Any Ideas Please?

Many Thank's for any help given.

Tony

 

[boblarson]

DoCmd.RunCommand acCmdBackup

 

[Anthony George]

Hi Bob

Thank's for your speedy reply.
Iv'e tried this command in both a subroutine and I also tried calling it as a function in a module but I get the following error.

Runtime Error 2046

The Command or action isn't available now.

Any Ideas?
Thank's

Tony

 

[boblarson]

I've found that to be true. So, see if this helps:
http://www.helenfeddema.com/CodeSamples.htm
Look at #20 in the list and see how she is doing it in her sample. I have not looked at it.

 

[Anthony George]

Hi Bob
Thank's for that link.
It enables you do download a zip file which contains an addin which can be unzipped into the addin manager on the tools menu.
This then gives you a lot of extra commands which look very usefull.
Many Thanks Again
Regards
Tony