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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export with date/time stamp 5
Creating custom stamps in .pdf Adobe documents 1
archiving a table with a date 1
VB Code to copy linked table to local 4
Showing Date Stamp on Form 6
Determine shift from date/time stamp? 8
vb problem 1
Insert Into Question 4

Back
Top