Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Running Access 2000 queries in VB6
- Thread starter adamtate
- Start date
- Thread starter
- #2
OK i think i'm nearly there...
this is my code:
Private Sub Command1_Click()
Dim db As Database
Dim rs As Recordset
Dim fld As Field
Set db = DBEngine.OpenDatabase("h:\cruisetools.mdb"
Set rs = db.OpenRecordset("Product List Search by Product Code"
End Sub
I'm getting a runtime error. Too few parameters. Expected 1.
Can anyone tell me why this is happening? Apparently it's something to do with the SET RS=..... line of code.
PLEASE HELP... IT'S HURTING MY HEAD!
this is my code:
Private Sub Command1_Click()
Dim db As Database
Dim rs As Recordset
Dim fld As Field
Set db = DBEngine.OpenDatabase("h:\cruisetools.mdb"
Set rs = db.OpenRecordset("Product List Search by Product Code"
End Sub
I'm getting a runtime error. Too few parameters. Expected 1.
Can anyone tell me why this is happening? Apparently it's something to do with the SET RS=..... line of code.
PLEASE HELP... IT'S HURTING MY HEAD!
- Thread starter
- #4
Your post is not VB Script syntax, as typed variable are not allowed in VBS. and the subject explicitely says you have a problem with VB6.
Try this forum: forum222.
I know you have a problem and need help, but I guess you'll have more accurate responses in a forum with VB (or perhaps MS-Access) MVPs.
Hope This Help
PH.
Try this forum: forum222.
I know you have a problem and need help, but I guess you'll have more accurate responses in a forum with VB (or perhaps MS-Access) MVPs.
Hope This Help
PH.
- Thread starter
- #6
- Status
