A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Startup code calling for a Form I can't find



 
 
Thread Tools Display Modes
  #1  
Old August 17th, 2005, 04:38 PM
MIMF
external usenet poster
 
Posts: n/a
Default 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  
Old August 17th, 2005, 04:41 PM
Rick B
external usenet poster
 
Posts: n/a
Default

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  
Old August 17th, 2005, 04:47 PM
Ofer
external usenet poster
 
Posts: n/a
Default

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  
Old August 17th, 2005, 05:22 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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  
Old August 17th, 2005, 06:25 PM
MIMF
external usenet poster
 
Posts: n/a
Default

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  
Old August 17th, 2005, 06:47 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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  
Old August 18th, 2005, 03:21 PM
MIMF
external usenet poster
 
Posts: n/a
Default

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  
Old August 18th, 2005, 03:33 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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  
Old August 18th, 2005, 03:51 PM
MIMF
external usenet poster
 
Posts: n/a
Default

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  
Old August 18th, 2005, 04:01 PM
Klatuu
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 05:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.