Recent content by polpoint

///ok got this: Insert Into "InvoiceLine" ( CustomerRefFullName, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount, FQSaveToCache) VALUES ('Casa Grande Condominium', '80000001-1354637734', 'Charge for unit #207-#####', 150, 1, Insert Into "InvoiceLine" (...

Ok, when I do that (remove the quotes for the table & field names) I get "Could not find output table 'InvoiceLine'" If I add the quotes to the table name: Insert Into "InvoiceLine" ( CustomerRefFullName, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineAmount...

Tried that too. Here was the final statement: --------------------------- Microsoft Access --------------------------- Insert Into 'InvoiceLine' ( 'CustomerRefFullName', 'InvoiceLineItemRefListID', 'InvoiceLineDesc', 'InvoiceLineRate', 'InvoiceLineAmount', 'FQSaveToCache') VALUES ('Casa Grande...

I am using access to insert records into quickbooks using qodbc. I have a VBA DoCmd.RunSQL to insert an InvoiceLine using a statement I build dynamically. I have a MsgBox that reports the statement right before calling DoCmd.RunSQL and it says this: Insert Into "InvoiceLine"...