Solved

Very Strange

Posted on 2013-12-01
5
162 Views
Last Modified: 2013-12-04
I have a break (at least I think that's what you call it when the code stops at a point and highlights the code concerned) that has me baffled. As you can see from the attached the offending code item has a value and should then run the code accordingly. But it breaks at that point.

I know that this is something silly I am missing but I don't know what.

It's run from a button on a form that opens a report. It must be something that is not yet recognised, saved or refreshed because when I close and reset the code window and click the button again it runs fine. It only happens when I have just opened the form and never again regardless of which record I move to.

The frustrating thing is that according to the little pop up box it appearers that the "FPMS" has a value.

Or perhaps it is an erroneous error caused by something else.  It sometimes asks for a parameter value, It takes this from the form which has the button. So the button opens the report which opens a query that is looking for a parameter which is the item number of the form that has the button. How can it not get that information when it is right in front of my eyes
Capture.PNG
0
Comment
Question by:DatabaseDek
5 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 39688582
Create a new database, import form, report  and just other objects to reproduce the issue.
Upload that database.
0
 

Author Comment

by:DatabaseDek
ID: 39688613
Just finishing up for today out all tomorrow will get back Tuesday

Thanks.
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39688855
Is it just stopping there without explanation or any error message?

If so, it sounds like a 'phantom breakpoint', which is not terribly uncommon.

Before importing your objects into a new database, try this:

-  Select and cut (delete) the offending line of code
-  Paste it back in at the same place
-  And/or try inserting some blank lines immediately above the offending line of code

Compile your code again, and try it again.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39688981
And the next ones to try is in the VBA window hit <Ctrl>+<Shift>+<F9> to clear all breakpoints.

If that doesn't work then try a compact & repair.
0
 

Author Closing Comment

by:DatabaseDek
ID: 39694847
That's got it.

If anyone knows why this happens, I'm curious

Thanks to all
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question