Hi,
I am trying to do the same thing as saving the Database using the Save As pull down with VBA code.
I have looked for examples on the web but nothing comes close.
Here's what I want to do:
- Transfer all the tables (structure and data), form, reports, vba code everything to another accdr not accdb file on a local pc machine.
- I want the user to pick the location on their local machine to save the file(I know how to do this).
Is this doable? Is so may I see example code using
DoCmd.TransferDatabase
Thanks
AccessLes