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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jrickard
-
Run time error 3346: No. of query values and dest fields not same
Thanks willir, I tried this, but no joy. For some reason VBA/SQL just doesn't seem to treat the string variable as one variable - it's continuing to evaluate the contents of the string and split it up into more than one string in some cases. Grrrrr- jrickard
- Post #7
- Forum: Microsoft: Access Modules (VBA Coding)
-
Run time error 3346: No. of query values and dest fields not same
PS Thanks for the reply PHV The process was actually inserting 92 records into the fields, so I looked at the unique ID immediately after these records, which is: A2051864567! 66! Bar This is suspiciously like the way we reference objects in Access, and once I removed this code from the...- jrickard
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Run time error 3346: No. of query values and dest fields not same
That's the strange thing - I just can't understand why it would be giving me that error. Here's the SQL: DoCmd.RunSQL ("INSERT INTO CONC_INTERESTS (ID, INTERESTS) VALUES ('" & strAccountno & "', '" & strInterests & "') ") The only fields in the CONC_INTERESTS table are the ID and INTERESTS...- jrickard
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Run time error 3346: No. of query values and dest fields not same
Hi folks I'm trying to use a DoCmd runSQL to insert recordset results into a table. I can do it successfully using a rst.addnew method if I declare the table as a recordset however I'd rather use the SQL Method. I can provide the code if need be - just hoping someone may be familiar with this...- jrickard
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
