467,925 Members | 1,664 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,925 developers. It's quick & easy.

form requery and conditional Formatting glitch?

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
  • viewed: 1822
Share:
1 Reply
Expert 256MB
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.

Similar topics

3 posts views Thread by Prakash Wadhwani | last post: by
4 posts views Thread by Randy Harris | last post: by
2 posts views Thread by Filips Benoit | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.