access 2000 VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need code example of how to save an open table to new .mdb with VBA?

I want to create a command button in a form that will save data just entered
in that form to a new .mdb at a specified path/folder. I got the command
button part need the code.

Thanks!
 
Look at the VBA help under TransferDatabase. It describes how to transfer
data from the current database to a new database.

DoCmd.TransferDatabase transfertype:=acExport, <etc.>
 
This worked when added to another code example from a later question. See
"saving data from form to new table/new mdb 7/22/2005" to bring it all
together.
Thanks!
 
Back
Top