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 strongm 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

Status
Not open for further replies.

adamtate

Technical User
Dec 18, 2002
23
GB
Anyone got any ideas how to run a microsoft access 2000 query in a form in VB6?

PLEASE make this english, as i've not used VB for about 5 years, and am struggling like hell with it!

Thannks guyz... :D
 
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!
 
nope... i dont think so... i need help with VB Script... as far as I can see i'm in the

"Home > Forums > Programmers > Languages > VBScript Forum"

How am i in the wrong forum?

I JUST NEED HELP! LMAO!



 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top