Results 1 to 2 of 2
  1. 10-11-2012, 09:52 PM #1
    darsunt
    darsunt is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    2

    Possible to create Form for creating queries?


    I don't think Access has this, but it would be nice to be able to create a Form that could create queries. For example, a text box that could take a value that could be entered into a WHEN statement, or a date range for a BETWEEN statement. Would this be possible?
    I don't mind writing a query and then creating a report from it, but one couldn't ask some one with no experience in SQL to do it.
    Reply With Quote Reply With Quote
  2. 10-11-2012, 10:05 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Sure; check out QueryDef in VBA help.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Creating a function that queries a one to many relationship
    By davideps in forum Queries
    Replies: 3
    Last Post: 04-28-2012, 10:12 PM
  2. Creating a form that will create custom reports/queries
    By ChEStud in forum Access
    Replies: 1
    Last Post: 06-20-2011, 03:56 PM
  3. Using queries to create new table
    By mradel in forum Queries
    Replies: 1
    Last Post: 10-26-2010, 10:34 PM
  4. Creating Relationships and Queries
    By nacho in forum Database Design
    Replies: 4
    Last Post: 04-16-2010, 03:22 AM
  5. automatically create queries
    By GEORGIA in forum Programming
    Replies: 8
    Last Post: 01-23-2006, 02:35 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums