Problem when closing a form on top of another form in Access

[jimtmelb1]

I have an Access 2000 database. I have a main form for data entry which is used the majority of times.

I am having a problem that I can't seem to rectify. From a toolbar along the top I can open other forms on top of this main form. Some a pop up forms and others are not.

When I open a full form on top of the main form and hit exit the main form is in a restored state and has frozen. I can't use the scroll bars or edit any field on this main form. I can only exit the form and try again.

This doesn't happen the first time you open a form on top of the main form, but it does happen and there seems to be no pattern. It will never happen when closing a popup on top of the main form.

It does happen if you open a popup and then close it and then open a full form and close it. When you close this full form the main form is restored and frozen.

Can anybody suggest why this is happening. Any assistance would be much appreciated.
Thanks
Jim

 

[Edski]

I can't suggest much but I have noticed that opening a pop-up and then closing it while another main form is opened results in the status bar being frozen. A work-around for this was to hide the main form and then make it visible again after closing the pop-up. You'll see a short flicker but it was the only way to fix this 'bug'. Perhaps it may work for you. As for your problem, I have one question: If the main form is frozen, how do you exit this form?

 

[TheAceMan1]

How are ya jimtmelb1 . . . . .

What version Access?

See Ya! . . . . . .

 

[Edski]

AceMan,
If you took your sunnies off you'd see that he wrote Access 2000 - in the first line of his post.
Sorry, just having a light-hearted dig ;-)

 

[TheAceMan1]

Edski . . . .

Yeah . . . . . I've been getting bit by alot of snakes lately . . . lol ;-)

See Ya! . . . . . .

 

[jimtmelb1]

Hi,

I have a scenario where it always happens. If I open my main form. Then I open a pop up form. I can close the pop up form successfully. Then I open another form on top of my main form which is not a pop up. As soon as I open this form the main form is disabled. So if I close the form I opened the main form is in a restored state and the only thing I can do is use the x in the top right hand corner to close the form. I cannot edit any fields or use the scroll bar. It seems like the main form is disabled.

If anyone can give me any further suggestions that will be great.

Thanks
Jim

 

[jimtmelb1]

Hi,

I have made a discovery. In the pop up form I have included some code to assist with the Mouse Wheel problem in Access 2000. When using the mouse wheel it cycles all records instead of scrolling down a form. Anyway Microsoft had a fix for the problem and I have implemented this in my database. I have to include the code below to each form where the mouse wheel had the problem.
If i remove this code it works perfectly (no forms are disabled).
With this code the problem with the forms continues. Can anyone tell me a way I can still have this code and not have the problem with the forms disbaling.

Thanks
Jim

Private Sub Form_Load()
Set clsMouseWheel = New MouseWheel.CMouseWheel
Set clsMouseWheel.Form = Me
clsMouseWheel.SubClassHookForm
End Sub

Private Sub Form_Close()
clsMouseWheel.SubClassUnHookForm
Set clsMouseWheel.Form = Nothing
Set clsMouseWheel = Nothing
End Sub

 

[Edski]

Perhaps Microsoft's 'fix' isn't such a good fix afterall.

I use the MouseHook.dll file to disable the mouse-wheel altogether, and the user can use the Page Up/Page Down keys, or the scroll bars, to move up and down a long page.

ps. Many users might like the way the mouse-wheel functions. In their case, they wouldn't call it a 'problem' ;-)