If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Startup code calling for a Form I can't find
How do I locate the code that is referencing on StartUp a form that is not
showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#2
|
|||
|
|||
Is it the Tools/Startup form that is being referenced?
-- Rick B "MIMF" wrote in message ... How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#3
|
|||
|
|||
You probably calling that from the startup box
right click on the top of the MDB box, select StartUp, in there you have a text box "Display form", check if the form name written there -- In God We Trust - Everything Else We Test "MIMF" wrote: How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#4
|
|||
|
|||
It could also be called from a Macro named Autoexec
"MIMF" wrote: How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#5
|
|||
|
|||
I tried each of the suggestions but still no luck.
"Rick B" wrote: Is it the Tools/Startup form that is being referenced? -- Rick B "MIMF" wrote in message ... How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#6
|
|||
|
|||
Here is a technique that should help you find the problem.
Determine what code executes for startup. It will either be a function identified in a macro called Autoexec or in a form called by startup. You can check Tools-Startup from the menu, and see what is in Display Form/Page: Once you have that determined, open the code module for the form, or the module the function from Autoexec is in and set a breakpoint on the first line of executable code. Then open the startup form or call the function from the immediate window. Then when it tries to open the mysterious form, you will see what the name of it is and where it is called. If you know the name of the form, then you can go into Tools-Options and check Show hidden objects on the view tab. It may be that the form is hidden. "MIMF" wrote: I tried each of the suggestions but still no luck. "Rick B" wrote: Is it the Tools/Startup form that is being referenced? -- Rick B "MIMF" wrote in message ... How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#7
|
|||
|
|||
Still struggling with these two forms that bring up error messages on startup.
The only place I can find them mentioned anywhere in the database is in the Project Manager page in Visual Basic. When I right click on the form (any of the forms actually) the 'Remove the form' command is grayed out so I can't select it. Any ideas on why this would be so? I am the one with all the read/delete rights for the database so I can change any setting that might be messing with my mind here. Thanks. "Klatuu" wrote: It could also be called from a Macro named Autoexec "MIMF" wrote: How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#8
|
|||
|
|||
It is possible you are suffering a weird corruption problem. I did have a
problem once where some tables were doing almost the same thing. I checked show system objects, and they showed up as being system tables owned by "system". I had to do the old start with a new mdb and import everything from the old one routine. "MIMF" wrote: Still struggling with these two forms that bring up error messages on startup. The only place I can find them mentioned anywhere in the database is in the Project Manager page in Visual Basic. When I right click on the form (any of the forms actually) the 'Remove the form' command is grayed out so I can't select it. Any ideas on why this would be so? I am the one with all the read/delete rights for the database so I can change any setting that might be messing with my mind here. Thanks. "Klatuu" wrote: It could also be called from a Macro named Autoexec "MIMF" wrote: How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#9
|
|||
|
|||
Klatuu
You are my new best friend! It worked. The new database did not import the two forms because (of course) they were not really there!! Thanks so much. "Klatuu" wrote: It is possible you are suffering a weird corruption problem. I did have a problem once where some tables were doing almost the same thing. I checked show system objects, and they showed up as being system tables owned by "system". I had to do the old start with a new mdb and import everything from the old one routine. "MIMF" wrote: Still struggling with these two forms that bring up error messages on startup. The only place I can find them mentioned anywhere in the database is in the Project Manager page in Visual Basic. When I right click on the form (any of the forms actually) the 'Remove the form' command is grayed out so I can't select it. Any ideas on why this would be so? I am the one with all the read/delete rights for the database so I can change any setting that might be messing with my mind here. Thanks. "Klatuu" wrote: It could also be called from a Macro named Autoexec "MIMF" wrote: How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
#10
|
|||
|
|||
Great! Glad you got passed it.
When Access goes Schitzoid, it can make you crazy. "MIMF" wrote: Klatuu You are my new best friend! It worked. The new database did not import the two forms because (of course) they were not really there!! Thanks so much. "Klatuu" wrote: It is possible you are suffering a weird corruption problem. I did have a problem once where some tables were doing almost the same thing. I checked show system objects, and they showed up as being system tables owned by "system". I had to do the old start with a new mdb and import everything from the old one routine. "MIMF" wrote: Still struggling with these two forms that bring up error messages on startup. The only place I can find them mentioned anywhere in the database is in the Project Manager page in Visual Basic. When I right click on the form (any of the forms actually) the 'Remove the form' command is grayed out so I can't select it. Any ideas on why this would be so? I am the one with all the read/delete rights for the database so I can change any setting that might be messing with my mind here. Thanks. "Klatuu" wrote: It could also be called from a Macro named Autoexec "MIMF" wrote: How do I locate the code that is referencing on StartUp a form that is not showing up anywhere? I have searched all the macros manually and can't find it anywhere. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Intermitant failure to send e-mail in Outlook 2002 | Bob J | General Discussion | 6 | June 29th, 2005 04:47 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Excellent Navigation Method! | Bill Mitchell | Using Forms | 3 | December 16th, 2004 01:49 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |