By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,474 Members | 3,214 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,474 IT Pros & Developers. It's quick & easy.

form requery and conditional Formatting glitch?

P: 1
Hey all, first time here.

I have a database that is designed to be opened and viewed at other locations on the network.

I use Form (A) to modify Data in Table (A), and Form (B) is used scrictly to view.

Now It works great and updates every 10 seconds with a form.requery on a timer event.

Now This display is to give Scheduled and Actual times. As times are posted, I use Conditional formatting to change the colors reflecting on time, due soon, or late.

However, my problem is if the Computer is left alone, eventually the computer will stop (seems to be random) adjusting the colors as I requested. As soon as you hover the mouse over the form (Access Window), it will then wake back up and adjust the colors again.

However I wish to not use form.requery only because i want the window to not slide back up to the top of the list every time.


Any Suggestions?
Jan 8 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
Well as for the requery, that is simply by design because it has to display the first record(s) from the top of the database.

If you are able to put a bookmark into the location where you'd like to be and then requery from that point, you're able too.

If you need assistants in how to do that in code, let me know.


Joe P.
Jan 22 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.