Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form to make query (XP)

    Can I set up a form using combo boxes to design a 1-time use query? Some of my end users are complaining about their inability to create queries and I really don't want them to get into the design view. And before I'm given a link to WendellB's User-Lever Security info, I do know about it, I'm just exploring Access' options....thanks!
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form to make query (XP)

    The Form Filter and Advanced Filter option for forms provide powerful ways to filter the data in a form (the Advanced Filter window is almost the same as the query design window). It is also possible to use combo boxes to create a filter for a form or report. So in general, it shouldn't be necessary for end users to create queries, even temporarily.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form to make query (XP)

    I thought so...(the combo box route), I knew it was there, I just have to play with that. I know how to set up the form with the combo boxes and all, but how do I make it open the datasheet? And in read-only?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Form to make query (XP)

    I think you may be getting a bit lazy. Have you tried using the object browser, help?

    If by datasheet, you mean the query in datasheet view, try something like this:

    DoCmd.OpenQuery "MyQuery", acViewNormal, acReadOnly
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Form to make query (XP)

    You can open a query (Charlotte has shown you how), but you might as well open a form or a report. With a form, you can control precisely which fields the user can or cannot modify, and a report is read-only by nature. See the following Knowledge Base articles:

    ACC2000: How to Synchronize Two Combo Boxes on a Form
    ACC2000: How to Filter a Report from a Pop-Up Form
    ACC2000: How to Sort a Report from a Pop-Up Form
    ACC2000: How to Filter a Report Using a Form's Filter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •