Question about Access 2003

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I have an Access application running on Access 2003. When the application
starts, it opens a "start-up" form and the "Open" event for that form will
evaluate the user logon and then re-direct it to other form. The user logon
evaluation is written in VBA in a module and it will execute the user logon
evaluate function when the "start-up" form opens. The problem is when I
start the application, it opens the module window and it stops on the first
line of that evaluation code. I have to press F5 to complete the rest of the
code. What can I do to execute the entire code without a pause? Thanks.
 
Paul said:
I have an Access application running on Access 2003. When the
application starts, it opens a "start-up" form and the "Open" event
for that form will evaluate the user logon and then re-direct it to
other form. The user logon evaluation is written in VBA in a module
and it will execute the user logon evaluate function when the
"start-up" form opens. The problem is when I start the application,
it opens the module window and it stops on the first line of that
evaluation code. I have to press F5 to complete the rest of the code.
What can I do to execute the entire code without a pause? Thanks.
Click to expand...

It sounds like you have a "phantom breakpoint". There are various steps
you can take to get rid of this, and they get increasingly radical.
First try this:

1. Open the code module that has been popping up.

2. Modify some line in a trivial way, then change it back.

3. Click Debug -> Clear All Breakpoints

4. Click Debug -> Compile

5. Close the code module.

6. Click the Save button.


See if that takes care of the problem.
 
Back
Top