Results 1 to 2 of 2
  1. #1
    buienxg is offline Novice
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    15

    access query displaying in the background

    I have an access database and some designed user forms for use with the database.



    two of the form buttons run queries when clicked.

    the query window is popping up in the background behind the userforms as it runs and i do not want this to happen however I do not know how to stop it from happening.
    I am talking about the query window in standard access table view (if that makes sense)

    Can someone help me please.

  2. #2
    Toyman is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    233
    That is because the form that is displaying is most likely has its property setting for "PopUp" set to yes. However, you should never allow your user direct access to the database's tables and query. You don't have any control as to how the data is accessed or changed. Instread, create a form based on the query and let your user access to the form instead. You can then set the "Popup" property to yes in the form, and it will open in front of the other form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. background image on Access 2010 form
    By lkspitz in forum Forms
    Replies: 2
    Last Post: 06-16-2011, 08:35 AM
  2. Displaying Form, but not Access itself
    By BayerMeister in forum Forms
    Replies: 3
    Last Post: 08-16-2010, 02:21 AM
  3. Query not displaying value
    By cwwaicw311 in forum Queries
    Replies: 5
    Last Post: 03-22-2010, 10:11 AM
  4. Displaying data in Access from SQL
    By BeckyAccess in forum Queries
    Replies: 0
    Last Post: 06-30-2009, 01:57 PM
  5. Displaying Query Properties in a Form
    By Bjar in forum Programming
    Replies: 1
    Last Post: 07-16-2008, 07:51 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