Results 1 to 6 of 6
  1. #1
    williamc3502 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    5

    How to assign a dialog window mode for query

    Hello everyone.



    I want to ask how to set the window mode of query to dialog?

    For instance, there is a button which allows us to run the query in a form. What I want to do is query of dialog window mode can be obtained after clicking the button.

    Is it possible to do this?

    Thanks so much!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I'd open a form based on the query; you'll have control over the mode then.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    williamc3502 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    5
    ys, I also did that. But, I still cant adjust the window mode. There is no options on that. Besides, when I click a button to open a form, I can set the window mode.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Which is it? Have you looked at the arguments available for OpenForm?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    williamc3502 is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Jun 2012
    Posts
    5
    Actually I used the macro tools to the "OnClick". When I choose "OpenForm", there is a option called "Window mode" for me to choose. However, when I choose "OpenQuery", there is no options about the window mode. So, I don't know how I can set this

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Most of us do not let users into tables or queries directly. You have very little control over them. Again, I'd open a form based on your query. I don't think you can do what you're asking with a query.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. How to assign a specific value to each record within a query
    By Access2007_NewUser in forum Access
    Replies: 1
    Last Post: 04-22-2012, 08:28 PM
  2. Replies: 2
    Last Post: 09-01-2011, 10:48 PM
  3. Form doesn't open in Dialog mode
    By accessnewb in forum Programming
    Replies: 3
    Last Post: 08-02-2011, 08:38 AM
  4. Replies: 4
    Last Post: 01-14-2011, 10:37 AM
  5. need query to assign sales leads to reps??
    By RickM in forum Queries
    Replies: 0
    Last Post: 03-12-2009, 02:44 PM

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