Create and run select access SQL queries through VB

Hot Topic

Compile error in hidden module: AutoExec -- Help please
Just a few questions
shutdown
Write Games
VB?
Issuing commands through a console program (cmd.exe or telnet.exe)
Exeptions
Opening empty file as XMLDocument
checking properties of folders
classfactory cannot supply requested class

Visual Basic

Disable a warning
Beforeclose event problem
What's wrong with this code?
Problem with Picturebox control
how to create a new txt file at midnight each day and write to it
Data Connection Wizard
Use %USERNAME% in System.Diagnostics.Process.Start
Code Print Button To Print An Existing Word Document (VB.Net)
Listview Flicker question
VB2005 Icons for Binding Navigator

Create and run select access SQL queries through VB

Im attempting to have a user select the table,  fields and criteria to create a SQL statement query and run it immediately, from a form in MsAccess.
Ive tried to build and store the SQL statement in a string, set it as a new querydef,open an existing query and set its sql to the string. I have been unable to get this to work however. I either get a "obj var/ with block var not set" error or invalid SQL statement . However the syntax of the statement is correct according to tutorials ive followed. Can any1 offer sum help


Answer this question

Create and run select access SQL queries through VB

  • Thiago Silva

    I knew that was the right answer all along...

  • sam8sam

    Hi TechAddict,

    I'm glad to help.  However, I'm not quite sure how you're approaching this and can't really answer yet.

    Could you share some of the key code and stored procedure SQL that you're trying, and point out where it's popping an error

    thanks,
    Paul
  • Create and run select access SQL queries through VB
Answer this question