Randy, Thanks, I don't know where the threading information is, I'll ask Matt if he can dig it up so I can put it on that page. brad ... QODBC Driver for...
Hi there, I'm getting an odd error code occasionally when updating a customer through qODBC. 3100 - The name "name" of the list element is already in use. ...
There are two things to remember. Name means that it must be unique across ALL entity lists. i.e. customer, vendor, other name, and employee. Second, QB...
d. Taylor, List entities like Customer must have a "Name" that is unique across the following tables: Customer, Employee, Vendor and OtherName. You can do a...
I've read long and hard about this and I can't seem to get a definitive answer. I am trying to retrieve information about a single invoice- I know it's...
Sev, Use listID instead, should be about as fast as it can be. Slowdowns in finding invoices by number are usually caused by text or spaces in the invoice...
Alfred, I have not seen that data available from QuickBooks. You might try contacting Intuit and asking if that data is available to applications via the SDK,...
All, I am trying to make a multiline journal entry using qodbc & QB 2003. The exact queries I am using are below in the order I run them. It seems that when I...
The Accountant at my clients company made some changes to the quickbooks file. Now, when I try to update an item record I get this error. Do you have any idea...
Ok, I finally have a chance to work on this again. Anyways, I got the quickbooks file to open without the Quickbooks application running. But whenever I...
When I try to cut and paste the Audit Trail report from http://www.qodbc.com.au/sp_report.htm I get a "There has been an internal error when processing the...
I have created a series of worksheets that link to a sheet I call earnings. Using QreportGrabber I bring in a Standard P/L report to the earnings sheet. Now...
If you go to www.qodbc.com/schema.html you will see that those two fields are not updatable. Look at the column titled "MOD" for Modifiable. Chuck Vigeant...
Switch to MS Access. A Database is much more flexible and powerful. Patrick ... From: tawrren1963 To: qodbc@yahoogroups.com Sent: Friday, February 18, 2005...
Bocabeachguy
bocabeachguy@...
Feb 20, 2005 6:28 am
1036
Thank you for the reply Mr. Vigeant, That is the problem, I cant update the accounts field. Therefore we are unable to update items in our web application now,...
I could guess that maybe you have multiple copies of QuickBooks installed and the driver is confused? You might try loading QuickBooks in a batch file at...
I suggest you post to our support board, we need to know details like what version of QuickBooks you are using, as it might be one that does not support that...
Tom, Using QReportGrabber, you can link a spreadsheet cell to a single value of a report, locking it in place. There is a new version of QRG which will support...
I am not sure what you trying to do... but each item HAS to have an account associated with it; this is a usual QuickBooks practice. Otherwise reporting would...
The computer with the loading problem has only one copy of Quickbooks but there are multiple computers that are linking to the Quickbooks file, which all has...
... If you are going to have multiple people linking to the same data file, QuickBooks should be open before you connect, because otherwise it's going to be...
Brad, Is there anything in the QuickBooks and/or QODBC pipeline to alleviate this problem of QuickBooks loading very slowly in the background? Right now a ...
Steve, No changes to QuickBooks are expected in the near term, but we will be doing some things to the driver to speed up access to data this summer. brad ... ...
I am trying to build a MS Access report to extract the sales tax amounts paid on Bills we paid. We have separated this amount as we post each bill and...
Please post your SQL statement to the www.qodbc.com FAQ section. We need to know what version of QB you are using, what filters you are using -although your...
... Is this the only table where this happens? You are having a problem importing the data into QuickBooks, do you have a similar problem using linked tables?...
Hi all, I am trying to insert like 1000 jobs in the Customer table. How the "INPUT" statement works? Does some one has an example?? Using the INSERT statement...
INSERT is the mechanism to import data. And yes it can be slow for that many records. Please visit www.qodbc.com FAQ section for more information. Chuck...
... Yes, a drawback of QuickBooks' choice of interface, processing takes time thru the QuickBooks SDK, but it's better than IIF generally because of the ...
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.
