my database triggers the vba editor

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

Chad Cameron

Hi All,

I have been use the stop command in the vba editor. I am sure I have
removed all the stops.

When I open the DB and click on 1 button, it stops at the start of the
procedure. I press F5 and it runs through. I click the button again and
everything is fine.

If I close the DB and reopen it, the problem comes back on the first click
only.

Any ideas?
Thanks again for everyones help
Chad
 
Hi All,

I have been use the stop command in the vba editor. I am sure I have
removed all the stops.

When I open the DB and click on 1 button, it stops at the start of the
procedure. I press F5 and it runs through. I click the button again and
everything is fine.

If I close the DB and reopen it, the problem comes back on the first click
only.

Any ideas?
Thanks again for everyones help
Chad
Click to expand...

Try a couple of things: Debug... Remove All Breakpoints;

if that doesn't help, edit the module. Select the line that it stops on, Cut
it to the clipboard, make some trivial change (insert a blank line say), and
Paste it back. Compile again.

If that doesn't help, Decompile the database. Back it up first. Compact and
repair, then select Debug... Compile to recompile it.
 
debug -> remove all breakpoints worked.
Thanks


John W. Vinson said:
Try a couple of things: Debug... Remove All Breakpoints;

if that doesn't help, edit the module. Select the line that it stops on,
Cut
it to the clipboard, make some trivial change (insert a blank line say),
and
Paste it back. Compile again.

If that doesn't help, Decompile the database. Back it up first. Compact
and
repair, then select Debug... Compile to recompile it.
Click to expand...
 
Back
Top