Save As Dialog

[eidaa]

Hello,

So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. What would the code look like for it? I tried using the Access Help but that didn't do much good. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.

I am using Access 2010.

Thank you.

 

[pr2-eugin]

I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. What would the code look like for it?

This is quiet possible, with a little bit of coding, but what is the use of copying the whole database to a specific location?

Research on FileDialog that will give you the Save As, then using the FileCopy you can copy.

 

[eidaa]

I'm trying to create a "Backup Database" style button but the user should be able to choose where the backup goes.

For the code, should I use the FileDialogFolderPicker to get the destination string and then use it in the FileCopy as the destination parameter or should I use the SaveAs dialog and then the Execute method?

Sorry if the questions sound basic, I'm pretty new to VBA.