QODBC has met my need so well till now and i know i have asked this question a couple of times: Where can i check for an update on if Invoice lines can be...
Mark!Thanks a lot.I really appreciate your help. Currently i have a read/write version of QODBC. If i rerun the build you emailed me, will i have any ...
Yes, it will remember that you have a read/write version, just install and you should be good. Matt Froncek QODBC Development Support QODBC Driver for...
Hi all, Iam using Access database with quickbooks and VB. I want to insert into the quickbooks database that I converted to 97 in access through Vb. Here is my...
Hi all, I was wondering if Im doing something wrong I am using the data Wizard in vb to create a form that connects to the quickbooks but everytime I finish...
ADVERTISEMENT VB Data Form Wizard I haven't wrote a single line of code and I'm getting the following error after creating a form with VB Data Form Wizard. ...
I know we used to see that a while ago, perhaps it has creeped out of the bug list back into the product. In any case, you should be able to ignore it and run...
First, make sure your date format matches the SQL date format required. View the entire SQL statement and compare it to the examples on our FAQ page, and let...
hello all, This is the new error I'm recieving . Any suggestions on why, I don't know what I did to cause this to happen if anything [QODBC]Expected lexical...
hi all, I'm using this code to insert into the db from vb and I get the error below, what am i doing wrong this time ..... Set cn = New ADODB.Connection ...
Try taking the brackets out from around the table name. It would be easier for you to test these SQL statements separately, like in our VBdemo application,...
I would leave the square brackets [] off. QODBC uses double quotes " to designate field names, but since employee isn't reserved just leave them off. Matt...
I have a major problem, Im working with the Evaluation program for QODBC and quickbooks and was wondering why, I can add and update certain tables using a form...
Can you be more specific as to what you are trying to do, as in what table, like invoice and what field(s)? Also there was a bug in a previous version that...
Hi all, I have been taking your suggestions to heart and making progress but as you would know that when you think you fix one thing you have another mishap...
Hi - My hard drive crashed and I re-downloaded the QODBC drivers I have one routine where I add invoices I am getting an error Expected Lexical Element: )...
Can you send the SQL statement it is generating? It can be found if you run the QODBC setup screen, press the "Messages" button, then the "Review QODBC ...
Hi all, I have been taking your suggestions to heart and making progress but as you would know that when you think you fix one thing you have another mishap...
I can't think of anything that would change, however you might try reinstalling QuickBooks, some pleople report problems on the first install of QuickBooks...
Andrew, That error, listed in our FAQ, usually means a simple syntax error. I don't find the field called SalesReceiptItemRefFullName anywhere in the data ...
http://www.qodbc.com/docs/html/qodbc/20/tables/qbview_d_sales_receipt_line.asp?qbviewd_id=69 I used the above QuickBooks view, which does show that data...
... values ... ceiptItemRefFullName"") ... you were ... <http://www.qodbc.com> ... Your suggestion moved me towards progress, although by itself it didn't...
Oops! I reread your post and see that you already answered the last part of my question re: single vs. double quotes *chagrin*... ... values ... you were ... ...
Yes, Double quotes and single quotes mean different things to QODBC. Double quotes signify table and field names, single quotes signify constant string values....
Hi I need to select/insert/update and delete data from QuickBooks via a back-office web system written in ColdFusion and figured QODBC may be the answer but I...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
