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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query works in access but not thru vb6

Status
Not open for further replies.
jadoogar

jadoogar

Programmer
Oct 23, 2003
61
IN

I have stored variables from diff text boxes, combos etc to mem variables and made an insert into tablename values (x(1)...,x(n)) but when fired from VB error message "Too few parameters expected 35 is coming " Microsoft ODBC access driver" connectivity is used same time when I copy paste the formed query from immediate window to MS Access query its saving record.

Can you diagnosis please

insert into test values ("6/6/2007","01","05","01","Imali Bazar","110142","1504","01","1","10","03027100","Ambapada"," ","11","12","14","16","17","18","19","20","21","22","0","23","24","25","26","27","28","29","30","32","0","0","33","01","23","Y","38",0)
--------------
 
Status
Not open for further replies.

Similar threads

M
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
382
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
396
Andrzejek
Andrzejek
Moss100
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
378
Andrzejek
Andrzejek
ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
286
ziffer68
ziffer68
bryger
  • Locked
  • Question
pass-through query in MS access
Replies
2
Views
162
bryger
bryger

Part and Inventory Search

Sponsor

Back
Top