Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    create a query form (Access 2000)

    Looking for a sample db or examples of a form that lets a user create there own query by using text or drop down boxes. I really need a way for the user to create a query with out giving thme access to the db window. Any help is greatly appreciated.. Thanks...

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

    Re: create a query form (Access 2000)

    I don't have a sample database, since I never let users create their own queries., unless they really know what they are doing - in that case I give them access to the database window in their copy of the front end database.

    A very general way would be to invoke RunCommand acCmdNewObjectQuery from a command button. This will display the "New Query" dialog. But this would also let the user create action queries, something you may not want.

    If you allow the use of form filter and/or advanced filter, users can save a filter as a query.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: create a query form (Access 2000)

    Here is a small dbase it may have your answer its' size is 72K. It's done Access 97 should take much to modify
    Attached Files Attached Files
    threecrow

    Don't make excuses. It's what you do, not why you didn't.

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: create a query form (Access 2000)

    (Edited by HansV to make correct URL and make it clickable - see <!help=19>Help 19<!/help>)

    Here is a site that also might help

    http://www.rogersaccesslibrary.com/TableOfContents3.asp
    threecrow

    Don&#39;t make excuses. It&#39;s what you do, not why you didn&#39;t.

Posting Permissions

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