Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

My form wizard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David Mueller - 08 May 2008 15:38 GMT
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 - 09 May 2008 05:39 GMT
Hello David.

> I wrote some VBA code that builds forms - a form wizard, really.
> I add controls, subforms, events, etc.
[quoted text clipped - 12 lines]
> 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.

Signature

Regards,
Wolfgang

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.