>>> I am writing a code which is actually performing multiple inserts on a
table.
Currently I am combining all my insert queries and passing as command text
to ADO command object.
There is one more way by opening a recordset and call AddNew on recordset
multiple times and then batch update.
>>>
For what provider?
It makes a difference as the SQL Server Provider allows multiple commands
Also - do you have to check to see if row is already on table?
RE: Form For Crosstab Query ... My next step is to place the query on a continuour form, and add a command... FROM (TimeRecords INNER JOIN Staff ON TimeRecords.StaffID = Staff.StaffID) ... I would like to add an additional column that sums the multiple of each ... (microsoft.public.access.forms)
Re: Bash commands: maybe they want to drive us crazy? ... Here is the man page SYNOPSIS for grep, ... be multiple files with /grep/. ...>format of any command. ... It is very difficult to run a command... (comp.os.linux.misc)
Re: Multiple Recordset from a Stored Procedure ... This sample shows how to return multiple recordsets from database ... Also I note that ADO help suggests that we can roll our own multiple ... "If you open a Recordset object based on a compound command statement... (comp.databases.ms-access)
Re: Printing to file with more than one page ... I have 27 figures and I need to print them to .pdf file,... I know, how to print on one page with command "print", but I can't find, how to print on more pages. ... You could use the subplot command to put multiple plots on one figure. ... storing handle of each in the figs... (comp.soft-sys.matlab)
Multiple Combo Boxes as Criteria for Continuous Form ... combo boxes and click command button that will then list some information ... The code for the command button is: ...Private Sub Btn_OpenUpdateList_Click ...form multiple times.... (microsoft.public.access.formscoding)
