A2003 Freezes on me

[Salad]

I have A2003 split; FE on the C drive, BE on the network. There are
some other people in the system.

The FE app is in A2003, the backend in A97.

I have an opening form; MainMenu that opens. I can go between various
forms and it appears to work OK. I then click Window/Unhide and unhide
the database window. I may or may not do anything in the database
window. I then click back on the MainMenu form and it freezes. The
command buttons don't work. Menu bars or toolbars don't work. No error
messages. It's just dead.

I thought...even tho the MainMenu form is open, let's open the MainMenu
form from the database window. So I select the form and dbl-click. I
get a stack overflow message.

The program works fine for A97. It appears to work fine for A2003.
It's simply when I toggle between database window and form that the
problem presents itself. Any ideas?

[Stuart McCall]

Re: A2003 Freezes on me

"Salad" <oil@vinegar.co mwrote in message
news:_L6dnavm4b Ex0I_VnZ2dnUVZ_ tqtnZ2d@earthli nk.com...

>I have A2003 split; FE on the C drive, BE on the network. There are some
>other people in the system.
>
The FE app is in A2003, the backend in A97.
>
I have an opening form; MainMenu that opens. I can go between various
forms and it appears to work OK. I then click Window/Unhide and unhide
the database window. I may or may not do anything in the database window.
I then click back on the MainMenu form and it freezes. The command
buttons don't work. Menu bars or toolbars don't work. No error messages.
It's just dead.
>
I thought...even tho the MainMenu form is open, let's open the MainMenu
form from the database window. So I select the form and dbl-click. I get
a stack overflow message.
>
The program works fine for A97. It appears to work fine for A2003. It's
simply when I toggle between database window and form that the problem
presents itself. Any ideas?

I've just run a test following your model as you described it. A2003 doesn't
present to me the problem you're having. I'm presuming your mainmenu form
isn't modal or opened with acDialog, else you wouldn't be able to open the
db window (AFAIK). So, do you have any code in mainmenu's module that hides
the db window? In the activate event, maybe? I can't really explain why that
might screw things up, but I think the stack overflow error is a significant
clue...

Sorry I'm unable to offer more, just trying to spark ideas.

[lyle fairfield]

Re: A2003 Freezes on me

Stack Overflow often happens when we get into an infinite loop.

Assuming Main Menu has a module and a Form_Open or Form_Load or
Form_Activate procedure, I would put a break point at the beginning of
such code, open the form from the Database Window and step through the
code pressing <F8>. If there's an infinite loop, you'll realize it
when your finger gets very sore.

Second I would try, in 2003, saving the MainMenu form as text.
Deleting it. Compacting the db. Compiling all modules. And then
loading the Main Menu Form back from the text file (all on a safe copy
of course).

Third I'd create a new Main Menu (actually I'd scrap the Main Menu
form and use Menus, but that's another issue.)

Fourth I'd try saving and loading the whole DB in the "As Text"
fashion.

Fifth I'd stop developing and get a job as a Keri Keri Gigolo (or is
that first?)

Did I mention "SAFE COPY?"

On Apr 25, 5:31 pm, Salad <o...@vinegar.c omwrote:

I thought...even tho the MainMenu form is open, let's open the MainMenu
form from the database window.  So I select the form and dbl-click.  I
get a stack overflow message.
>
The program works fine for A97.  It appears to work fine for A2003.
It's simply when I toggle between database window and form that the
problem presents itself.  Any ideas?

[Salad]

Re: A2003 Freezes on me

lyle fairfield wrote:

Stack Overflow often happens when we get into an infinite loop.
>
Fifth I'd stop developing and get a job as a Keri Keri Gigolo (or is
that first?)
>

Now that the Mexican peso is on par with the American dollar, lots of
them have left to go back to their mother country. This has opened up
many job opportunities. I'm now considering a future in watermelon
picking or chicken plucking.

[Salad]

Re: A2003 Freezes on me

Salad wrote:

I have A2003 split; FE on the C drive, BE on the network. There are
some other people in the system.
>
The FE app is in A2003, the backend in A97.
>
I have an opening form; MainMenu that opens. I can go between various
forms and it appears to work OK. I then click Window/Unhide and unhide
the database window. I may or may not do anything in the database
window. I then click back on the MainMenu form and it freezes. The
command buttons don't work. Menu bars or toolbars don't work. No error
messages. It's just dead.
>
I thought...even tho the MainMenu form is open, let's open the MainMenu
form from the database window. So I select the form and dbl-click. I
get a stack overflow message.
>
The program works fine for A97. It appears to work fine for A2003. It's
simply when I toggle between database window and form that the problem
presents itself. Any ideas?
>

I had the following code in the OnActivate event of my MainMenu form.
Application.Ech o False
Me.Visible = False
DoCmd.Restore
Me.Visible = True
Application.Ech o True

This works OK in A97. And it works fine in A2003 for me...as long as I
don't go to the database window then reselect the MainMenu. I commented
out the Application.Ech o lines and it works fine now. I'm not sure
where or why it's getting confused.