I'm trying to use the Profit And Loss By Job sp_report query in Crystal Reports 8.5 and I get a "Column not found: Amount_Title" error. I get that message with...
Jerry, Can you tell us which version of QODBC and QuickBooks you are using so we can look up the specs for those reports? The documentation was recently ...
What would the be the simplest way of determining the next Invoice number in Quickbooks? I've thought of "SELECT max(refnum) from invoice" or something like...
The next invoice number is not available via the QuickBooks SDK, so our driver cannot access it. For what reason do you need it? If you want QuickBooks to...
First I would upgrade to the current build 50 because there is no field titled like that in the report you mention. Try a * instead of the specific field names...
When installing the QODBC driver I see QB Canada 2003 and 2004, and QB US 2002. I want to use the driver against QB 2002 Canada. What are my options? Thanks...
Got it to work, thanks. By the way, where do go to find a good instruction manual on using sp_reports? Jerry ... field ... specific ... all, thanks. ... using...
I've inserted the following code into my Access control to insert a new customer and job into Quickbooks and occasionally it works fine but it seems that when...
In the installer screen you should see a list of versions, use the mouse or down arrow to scroll through the rest of the list below which you cannot see. Yes,...
MSysConf is not an error, but rather a setup file Access always looks for, and it should be ignored if not found. This is why you only see it happen once. brad...
Sorry, my mistake, QuickBooks had no SDK in the 2002 Canada edition, so you will need to upgrade to a later version to use QODBC. thanks! brad ... QODBC Driver...
Are you saying that Access ignores MSysConf after failing to find it in the first insert attempt? I'm still wondering why it fails to execute the insert sql...
... Jerry, I don't know the answer as to why Access fails to run the first time, perhaps Matt can help on this thread. brad QODBC Driver for Quickbooks -...
... Jerry, Try this: http://www.qodbc.com.au/sp_report.htm It's new, let me know what you think. thanks! brad QODBC Driver for Quickbooks - Plug-in to your...
I would suggest one of two things. Either redo you code to use ADO or do a call to find a record first and ignore any errors. If you do a find like SELECT Id...
Hi, i have an invoice with 3 lines. When i tried to update one of the lines (2nd line) using qodbc, it updates the first line instead of the second line. An...
I'm a new user in qodbc. I have a problem when i connected it by using vb.net (Web Application). when i try to connect it show these message "ERROR [00000]...
Max, Make sure that you are using the latest version of QODBC - build 50, make sure you have a web evaluation code (Serno starts with X) and make sure ...
Yes of all. I try do all that i can see in web qodbc. but it's still not work. I buy the QODBC Web Editions. i try to use VBDEMO and it's work but never work...
Copy the above TestDCOM.ASP script to your scripts directory. Run from a browser and send the results back here. It will tell us what it working and what is...
Download www.qodbc.com/images/testdcom.zip and copy TestDCOM.ASP script to your scripts directory. Run from a browser and send the results back here. It will...
Hello, I am currently using Quickbooks 2003 Contractor edition. Since this software lacks a nice service managing program within, I had someone create a nice...
hi i'm having a problem with inserting a record into InvoiceLine table. from the reference table in qodbc.com, i figured that the only fields required are...
hi i have two recordset open from access database. one contains orderheader information (customer name, billing address, shipping address, and other info such...
Neither way will work, actually! Please see our FAQ page for the full code details, you need to make use of the cache flag to tell it when you have hit the end...
The internet version setup steps are off the main QODBC Product menu, the direct link is: http://qodbc.com/QODBCweb.htm We are working on a doc specific to...
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.
