My form wizard

[David Mueller]

I wrote some VBA code that builds forms - a form wizard, really. I add
controls, subforms, events, etc.

Each time I add an event, the VBA window opens up. I know MS Access' wizard
doesn't do this. How do I prevent that VBA window from popping up? I found
code to minimize the code window immediately after adding an event. Great.

But more at issue is that when the window pops up (or when I minimize it),
the focus changes to the VBA window, effectively preventing the user from
doing anything else on their computer while the wizard works.

Any suggestions here? I'm not sure how to completely prevent that VBA window
from opening. Clearly, MS Access doesn't do this when its form wizard works.

Thanks
David

 

[Wolfgang Kais]

Hello David.

I wrote some VBA code that builds forms - a form wizard, really.
I add controls, subforms, events, etc.

Each time I add an event, the VBA window opens up. I know
MS Access' wizard doesn't do this. How do I prevent that VBA
window from popping up? I found code to minimize the code window
immediately after adding an event. Great.

But more at issue is that when the window pops up (or when I
minimize it), the focus changes to the VBA window, effectively
preventing the user from doing anything else on their computer
while the wizard works.

Any suggestions here? I'm not sure how to completely prevent that
VBA window from opening. Clearly, MS Access doesn't do this when
its form wizard works.

How did you add the event procedure?
See the example for the CreateEventProc method from online help.