Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Help   Contact   Merch   Join   Order   Logon   Forums   
 
Back to Access Developers    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
MouseMove Event Error Loop
Werner Mildt 
      
17 hours ago
Is there any way to find this kind of error in my program?
I just added Richards new FormLayOutF Function.
It really Workes very good, thanks Richard.
I don't know if this error is related to the FormLayOutF Form or
I have another problem some ware else!
Calling the FormLayOutF from my CustomerListF Form did not work. ERROR
Using the FormLayOutF it worked???

Werner Mildt OP  @Reply  
      
17 hours ago

A Toykan  @Reply  
      
14 hours ago
It’s reporting that the code in the MouseMove event has an error, which naturally triggers every time the mouse moves. You mentioned added Richard's FormLayoutF function - I'm not completely sure which code it is, and actually I'm away from my computer right now, so I couldn't locate it through my phone- but I don't think there should be any code in the MouseMove Event in the first place. Looks like you accidentally put something there, check MouseMove event event and clear any unnecessary code from there.
Werner Mildt OP  @Reply  
      
13 hours ago
This has nothing to do with Richards FormLayoutF Form.
PS Rechard, I reviewed  FormLayoutF Form and found why it did not work correctly.
I forgot to put the Public Function OpenFormLayout() into the Global module, it works just fine.
The only question I have, why are the settings not saved.
When I reopen the CutomerListF Form, the setting are all lost.

The error happens when I try to go into Design View.
Kevin Robertson  @Reply  
          
12 hours ago
Have you added =MoveDisplayFields() to the Load event so CustomerListF knows to load the settings when the form loads?
Richard Rost  @Reply  
          
11 hours ago
Kevin is right. Saving the layout and restoring it are two separate steps. Once FormLayoutF has stored the control positions, CustomerListF still needs to call MoveDisplayFields when it opens so those saved positions get applied again.

Put it in the CustomerListF Load event, for example:

Private Sub Form_Load()
    MoveDisplayFields
End Sub

Or, if you are using the event property directly, use:

=MoveDisplayFields()

Also make sure the code that saves the positions is actually being run before you close CustomerListF.

The MouseMove error is a separate issue. As A Toykan pointed out, MouseMove fires constantly, so any error in that event will keep popping up every time the mouse moves over the form. Open the MouseMove event for CustomerListF, find the exact line that fails, and fix or remove that code if it does not belong there.

I would also go into the VBA editor and run Debug > Compile. That will often catch errors hiding elsewhere in the form's code before they surprise you at runtime.
Add a Reply Upload an Image
Next Unseen

 
 
What's This?

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 9/19/2026 6:05:00 AM. PLT: 1s