About 5 years back I replaced a macro with code. So in my Switchboard I created a Command from the Macro to Run Code called mcr_ImportDaily. Now I can not find that code in VB. Can anyone tell me how to find that code?
Competent Performer
Windows 7 
Access 2007
About 5 years back I replaced a macro with code. So in my Switchboard I created a Command from the Macro to Run Code called mcr_ImportDaily. Now I can not find that code in VB. Can anyone tell me how to find that code?
VIP
Windows XP Access 2003
There are a couple of places you can check:
1. Look in your MODULES in your navigation pane in the left hand margin. If you arrange that window by object type it'll be the last category
2. On the form where this function exists, hit alt-F11, that should bring up your code window, then you can scroll through it to look for your function or just hit ctrl-F to open your find window.
3. The least likely thing to do is to look in all modules of your database, if you've declared this as a public function it could quite literally be anywhere in your database attached to any form etc.
So Lost!!
Posting Permissions
Reply With Quote