Solved

2007 Form repaint issue

Posted on 2007-11-30
1
791 Views
Last Modified: 2013-11-28
Here is the situtation. I have a form that when a button is clicked it runs a pretty extensive set of modules and procedures to pull in data and update the form. As a way of informing the user to the progress of the process I update the form's caption, so it is like a steady stream of what is happening behind the scenes. I have a repaint after everytime it updates the caption. In Access 2003 this worked fine, in 2007 the form seems to hang, and sometimes the application goes blank. When the entire process completes the form repaints. Same exact code and database running in 2003 where it works, 2007 there is the repaint issue. Has anyone seen this? If so, does anyone know of how to get access to repaint the form?
0
Comment
Question by:mlb3397
1 Comment
 
LVL 17

Accepted Solution

by:
Shanmuga Sundaram earned 250 total points
ID: 20383197
try using doevents and refresh methods. this should help you.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add records to a form to a table 11 37
Access 2016 7 33
Access VBA: Populate unbound combobox with SQL query result 5 28
Help with DoEvents 8 25
When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

785 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