Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    I THINK is bc I have big queries that takes longer to compile so when someone enters a value and then click on search it takes a while for the program/computer to process because of the big and different inefficient join query that cause the second screen to pop behind.

    I alter the query I hope this helps. I am monitoring it.

    If it does not help I will make a replicate with dummy data and forward your way.

  2. #17
    johnseito is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2013
    Posts
    419
    Hi June7,

    I tested like 100 times to the query that I had altered that I thought was the culprit. It was fine, no problem after that 100 times and the altered.

    However, in another query that normally I have never see it occur, but out of randomness it did this one time. I am not sure why, but it always occurs regardless of where when it takes a longer time to load the form or run the script that caused the form to pop behind.

    I don’t know why sometimes the same query can be very quick to process while other times it takes longer. I think it might be the computer/ cpu/ processor being busy at that moment and that caused the form to pop behind. If this is so, how to resolve this.

    What is you advise and thought on this ?

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Running Queries simultaneously via form
    By ChobeyGuddu in forum Forms
    Replies: 3
    Last Post: 01-25-2017, 05:30 AM
  2. Replies: 2
    Last Post: 03-15-2016, 08:49 AM
  3. Replies: 2
    Last Post: 03-13-2015, 08:34 AM
  4. Running Queries from a form
    By HaYuM in forum Queries
    Replies: 1
    Last Post: 08-23-2013, 03:12 AM
  5. Running multiple queries in form
    By daniejm in forum Forms
    Replies: 3
    Last Post: 01-02-2013, 08:45 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums