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

DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
3K
lameid
lameid
Kennelbloke
  • Locked
  • Solved
Split Function not working
Replies
3
Views
555
Kennelbloke
Kennelbloke
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
3K
dhookom
dhookom
M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
4K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
715
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top