Break Occuring with no Break Point

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I'm not sure what's happening here, but a break is occuring with no
break point in sight. I'm using Access 2003. The database is used by
one person. I was asked this morning to make a couple of cosmetic
changes to a spreadsheet which is the output of a macro. I did so and
tested and all looked fine. I set some break points while testing and
removed them when I was done. A while later my user sends me a screen
shot of the macro code and one of the lines is highlighted in yellow -
like a break. Ok, so I open up the database, click on the button that
runs the macro and sure enough, the code comes up as if a break point
were set. I was able to hit the F8 button to start stepping through
the code and then clicked the "run" button and everything went on it's
merry way. So I cleared all breakpoints, saved the form and closed
the database. I opened it up again, ran the macro and all was good.
My user tried it and she was still having the same problem. I don't
know what else to try here. Any suggestions?
.



Relevant Pages

  • Re: Date range on reports
    ... > box to your report with a control source like: ... >> In the Database window (Database window: The window that appears when you ... >> In the New Form dialog box, click Design View, and click OK. ... >> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Newbies first image: BSOD 0x7B
    ... Having all the components mentioned in the macro platform component would be ... > - add this component to the database using the Component Database Manager, ... > Info:Creating: LSI Logic FC909 Fibre Channel Adapter ...
    (microsoft.public.windowsxp.embedded)
  • RE: Macro to VBA
    ... intLogonAttempts = intLogonAttempts + 1 ... MsgBox "You do not have access to this database. ... Database Administrator ... from the macro that does the checks and opens the form if everything passes. ...
    (microsoft.public.access.modulesdaovba)
  • RE: Manipulating MS Access records with excel VBA + ADO
    ... and other SQL filters into the code. ... Then in the 1st macro ... You have the choice of searching through the database by making a SQL to ... ' Macro recorded 1/19/2009 by Joel ...
    (microsoft.public.excel.programming)
  • Re: Combine Multiple tables into One Master table
    ... You can use a macro with 3 TransferText actions, one for each table, to get the data imported into your Access tables. ... the Open event of a form which always opens when the database opens - but then what if today's import has already been done. ... And then make an Update Query to add the data to the other fields from the related records in the other two import tables. ...
    (microsoft.public.access.macros)