I have used VBDemo and my own Access routines to add and change data, one record at a time, and am now ready to begin program design to accomplish my objectives.

Please provide me an overview about how to use the various batch functions provided with QOBDC so that I can incorporate the appropriate the appropriate udate method in my programs.

Thank you!

Sorry about being unclear.

As an example, my application will create an Access table that contains one record for each invoice I want to add to Quickbooks.  There may be as many as 50 records in this table, typically containing one line item each.  These invoice records will be posted to various customer record, not the same customer record.  The customer ListID and other Quickbooks key data will be in my Access table.

The question then is how to use the batch functions to insert all the records in my Access table.  Do I:

1. (a) Clear the last batch, (b) start a new batch, (c) use VB code to insert one invoice, (d)update the batch, then proceed to repeat from (a), or
2. (a) Clear the last batch, (b) start a new batch, (d) insert all invoices, (d) update the batch, and exit the program, or
3. Are the batching functions to be used in a manner different then I have described.

Are the batch functions required when adding or changing data in Quickbooks, whether updating one record or multiple records in an application?  If the batch functions are necessary, why were they not required when I updated various Quickbook records using VBDemo or my own access routine, albeit only one record in every case?  Can my Access application use batch functions to update multiple Quickbooks files at the same time and then update all batches using the appropriate file names, or will I need to update one Quickbook file at a time?

I am clear on the concept of batching.  I am asking how I apply QODBC's batch concepts in my Access program.

Thanks for your help.

I am attempting to use the batch functions because we process our customer updates and invoicing in batches.  I am also a novice Access programmer.

How do the batch functions get launched in VB.  I created a command button on my Access form in order to launch the batch process.  I used the following command to launch the clear batch function:

• docmd.openstoredprocedure (sp_batchclear customer)

This statement gives me a compile error, so I am not launching the stored procedure correctly.

Can you help?

Actually the command is:

DoCmd.RunSQL "sp_batchclear customer"

but you don't need to use batches in the first place. See: Inserting invoice lines built from external data using MS Access