Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    60

    Unanswered: Triggering the Query Builder

    In Access, is there a way to trigger the Query Builder as a dialog box and have it return a SQL string? I want to hook it into a function. I have a "..." button to the right of my txtSQL text box. OnClick of the button, I want to put something like the following:

    Code:
    Private Sub cmdTrigger_Click()
        
        txtSQL = fRunQueryBuilder()
    
    End Sub
    Doable?
    Matt Alexander
    mattalexx@softhome.net

    Don't click here.

    Odigo: 5408962
    AIM: mattalexx
    ICQ: 138006220

  2. #2
    Join Date
    Mar 2002
    Posts
    192
    Closest thing i could find was a command called "invokeBuilder". Not sure if that is even relavent but maybe it may lead you to what you're looking for in the help files. If checking syntax is not an issue then you might be able to get away with using just an inputbox.

    i.e. inputbox "", "", MySqlString

    If syntax is an issue then you'll need to build the logic to check syntax.

Posting Permissions

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