Archiving tables with date stamp

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

Guest

rI need to achive several tables and keep mulitiple versions, each time
stamped. I tried using simple macros and assigning the name based on a value
in a text box on a form, but there was no way to use a variable in the name.
I figure I need to use VB, specifically DoCmd.CopyObject. Will this allow me
concantonate a table name based on text plus a value in a text box on a form?

I always have trouble with VB syntax, so any help is much appreciated.
 
Never mind - I found out I could do it within the macro. I was fooled
because you can't invoke the builder from the "New Name" parameter of the
CopyObject macro, but alas, you can put the text box reference in and it
works.
 
Back
Top