recordset.addNew

Hi all, I googled a bit and didn't find good explanation about AddNew method. so I post here. What are the differences between these 2 versions: 1. order_info.Open cmdTemp, , adOpenKeyset, adLockOptimistic if order_info.EOF then order_info.AddNew ...

Message posted on the April 28th, 2009 - 5:48 PM ET

>> adodb recordset.addNew

Hi using Access 2003. I would like to use a generic function to insert a new record and return the id of the new record. a parameter is the field list and another is the new values. Public Function SaveRecordGetNewID(TableName As String, IdField As ...

Message posted on the May 5th, 2009 - 8:19 PM ET

Wildcard Filtering on ADO Recordset

I am not an expert coder.. more of a copy cat As an example I will just use 1 record tables. I have a datatable with three fields. For ease I have just put in Excel (cell referance below) D1 E1 F1 CSXX850 8505141 22971.92 and I have a ...

Message posted on the October 26th, 2012 - 11:56 PM ET

ADO hierarchical recordset and DRD

Hi all, I know this is an arcane topic, but I'm sure one of you guys still has this kind of (useless?) knowledge floating around in there somewhere. I have a legacy app using the data report designer and I need to add a report to it. The report I ...

Message posted on the December 9th, 2009 - 11:44 AM ET

Moving from Access to Server Express, adodb.recordset

Hi. I've migrated into SQL Server 2005 Express from Access. Have transfered the data fine, and have most of my vba queries working. I've ran into a problem though: it seems that recordsets work slightly differently in server? I have the following ...

Message posted on the February 3rd, 2010 - 8:34 AM ET

Addnew throwing error 3027

In one sub I am trying to add a record to to "Abstracts" table. Records in the abstracts table are related to the States and counties tables. So I open a recordset with joins. I have tried several times after checking everything out and ...

Message posted on the February 11th, 2010 - 2:47 PM ET

Is there a faster way of copying one record from one ADO RecordSet to another?

Currently I have rsSource and rsDest. I have a number of records in rsSource, and rsDest starts out empty and disconnected. (I create rsDest from scratch in VB code.) I need to check something in rsSource's records first, then add each one that ...

Message posted on the September 3rd, 2011 - 2:02 AM ET

Addnew followed by Edit

I am using a DAO recordset to add a new record if fields don't match, but to edit other fields if fields do match (using source data that's sorted, so that all source records relating to the one record I am adding to a different recordset are ...

Message posted on the July 26th, 2010 - 10:13 AM ET

A better way to Add records to RecordSet

Thanks for taking the time to read my question. I have the following code that works. It just works really slowly. Is there a better way to do this? What I want it to do is iterate through all the fields in a table, which I've made a recordset, and ...

Message posted on the March 25th, 2010 - 8:11 AM ET

Error 3001 recordset find sql

I am new to VBA and am stumped by the error 3001 I'm getting for some data values. I tried using the suggestions given for similar posts in this group, but without success. Here is a summary of my problem: I'm using MSAccess 2007. From a form button ...

Message posted on the December 29th, 2009 - 12:26 PM ET

ADO Recordset .Findfirst anomaly (Access 2007 ACCDB front end)

My table, "ItemMaster" has a unique index "ItemDescription". It has other keys, including an autonumber Primary Key. Table's been around for awhile. In vba, I open up rstItemMaster as a DAO recordset on the Item Master as a ...

Message posted on the June 28th, 2010 - 9:16 PM ET

Addnew works but field wont populate

Folks, I have the following code that adds a new row to a recordset(table) but If refuses to populate the fields represented by the variant varFld which at the time is a field object of the Recordset(table) tblTest. Not sure what I am missing here. ...

Message posted on the June 24th, 2009 - 9:59 AM ET

Recordset processing problem

I have a very complex loop that does recordset processing. I'm getting an error on an .ADDNEW statement saying 'operation not allowed when object is closed'. Well... I am not closing the object except after I have exited the loop. What could cause ...

Message posted on the May 13th, 2009 - 4:00 PM ET

How CancelUpdate if form closed during Edit or AddNew

Using VB5. With MDI and MDI child forms, how do I prevent a user from closing(by clicking the "X") on either the MDI or MDI child form while a Edit or a AddNew is in progress(ie. before an Update or CancelUpdate)? I tried to trap the ...

Message posted on the June 4th, 2010 - 12:16 PM ET

recordset addnew