sammers101
Registered User.
- Local time
- Today, 01:50
- Joined
- May 11, 2012
- Messages
- 89
Basically what I'd like to do is delete my "old" table, copy my "new" table and rename it "old", then copy "blank new" and rename it to "new". Basically a big switcheroo, so I can enter new data into the blank table and compare with the most recent data.
So from what I've read I need to create a macro to call my VB code using run code
so if my visual basic code is VBcode
I just go into macro actions, run code and enter VBcode? Also, I'm pretty sure a few minutes ago I was able to name my VB code, and now they are all just Module1, Module2, Class1 etc.
Maybe that's not the problem at all, when I try to run the code from VB (using the green play button, a macro window pops up (with no macros listed)
My code I am using is so far is:
Thanks for always being so helpful!
So from what I've read I need to create a macro to call my VB code using run code
so if my visual basic code is VBcode
I just go into macro actions, run code and enter VBcode? Also, I'm pretty sure a few minutes ago I was able to name my VB code, and now they are all just Module1, Module2, Class1 etc.
Maybe that's not the problem at all, when I try to run the code from VB (using the green play button, a macro window pops up (with no macros listed)
My code I am using is so far is:
Code:
Option Compare Database
Public Function RenameTables()
DoCmd.DeleteObject acTable, "Old"
End Function