Type Mismatch Error in Access 2003

G

Guest

Dim dbNewdb As DAO.Database
Dim rdcDept As DAO.Recordset
Dim sSQL As String
sbudget = "111aaa"
saccount = "222bbb"

sSQL = "insert into MyTable(Account, Budget) values('" & sAccount & "',
'" & sBudget & "')"

Set dbNewdb = CurrentDb
DoCmd.RunCommand sSQL
rdcDept.Close
 
G

Guest

Are both fields Account, Budget are text type fields?
If any of them is a number type, then you can get this error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert query by using VBA in Access 1
simple syntax issue 2
INSERT INTO where data is on an Oracle database 3
Custom Function 5
How do I properly call an Access parameterized wildcard query from ASP? 4
Recordset in Access 2007 1
Set rst = db.OpenRecordset(sSQL) 0
Type mismatch error. 1

Top