Restoring default data

[Guest]

Hi, I'm running a database to track donations for an annual event that we
hold, and am looking for a way to automatically restore text and numeric
values to a number of fields in my table. Is there a way to do this using
macros or VBA? I'm not really getting my head around this, even striking out
in my Dummies book!

I am just starting to learn macros, and hope to work up to VBA next, but any
help you can give me would be appreciated!

 

[Guest]

Hi Dudley,

Yes, there is a way of automatically restoring data. One of the easiest
methods is to have a hidden table that includes the data that you want to
restore. Then, in VBA code, you can first clear your table of existing
records and then run an append query (again in code) to append records from
your hidden table to the target table.

If you send me a private e-mail message with a valid reply-to address, I'd
be happy to send you a sample. My e-mail address is available at the bottom
of the contributor's page indicated in my signature. Whatever you choose,
please do not post your e-mail address (or mine) to a newsgroup reply. Doing
so will only attract the unwanted attention of spammers.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________