I am using VB 6 and an Access DB. I am wanting to run a query-based report which is determined by the user.
I have tried to use the SQL command:
Select * from TABLE where FIELD = [E];
and declare EE as a parameter and then
set EE= text1.text
in order to fire the SQL.. I have also tried to use Querydef and define the query in the Database and then set the querydef's parameter = the text1.text but neither has worked.
The first method I tried gave the error "NO value given for one or more parameters"
Please help me