Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-09-2002, 12:09 AM   #1
striker
Useless and getting worse
 
Join Date: Apr 2002
Location: South Somerset (Nowhere near Clevedon)
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
striker
messy screen during runtime

I have a VBA procedure which is run using the onclick from a button on a form. When the procedure runs it makes all the open forms invisible and then runs a query, the query takes info from hidden text boxes on various forms. After the query has run the procedure closes all the forms.

The problem I have is that the screen doesn't seem to refresh and leaves bits of the forms on the screen which looks messy.

Ive tried repainting the forms before running the query too no avail.

Anyone got any ideas on how I might force the forms to do their stuff before the query runs.

striker is offline   Reply With Quote
Old 05-09-2002, 01:00 AM   #2
Atomic Shrimp
Humanoid lifeform
 
Join Date: Jun 2000
Location: Portsmouth, England
Posts: 1,954
Thanks: 0
Thanked 8 Times in 7 Posts
Atomic Shrimp has a spectacular aura about Atomic Shrimp has a spectacular aura about
You could experiment with DoEvents (after repainting).
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
- it's not radioactive, and contains only a few crustaceans.
Atomic Shrimp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 09:33 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World