Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Finding out the added record in a "DataEntry" form ...

 
   Database Forums (Home) -> Visual Basic -> DAO RSS
Next:  sql server agent insql2005  
Author Message
Russell Potter

External


Since: Jun 10, 2007
Posts: 6



(Msg. 1) Posted: Sun Jul 22, 2007 9:55 pm
Post subject: Finding out the added record in a "DataEntry" form ...
Archived from groups: microsoft>public>vb>database>dao (more info?)

In a form whose "DataEntry" property is
"true" and which has had data`entered
into it, thereby creating a new record
in the form's underlying recordset, is
there any way, in VB, of finding out
the identity of that new-created record
(so that I could, say, make that record
the recordset's current record)?

I seem to remember the "Recordset::AddNew"
method makes the newly created record the
recordest's current record, but is there,
say, some other of "Recordset"'s method's
that does a similar thing with setting
the current record to a known location?

Russell

 >> Stay informed about: Finding out the added record in a ""DataEntry"" form ... 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Problem with "Recordset.Edit" on a "DataEntry" form in Ace.. - I have a form (called "MainForm") whose "DataEntry" property is set to "true" and whose "RecordSource" property is set to table "MainTable", which itself contains two string fields naned "main1"...

How to add new record in VB Form using Dao Library - Hi i developed some database in access. now i had planned to convert in to vb6.0. i had designed my form and i linked the tables also. when i m using data control. when i will open that form its going to first record. But i don;t want like this. I need...

error 3167 "record deleted" - Hello, I have searched in newsgroup for the following error and found nothing which can help me. Two people are working together with an visual basic application in one database. The database is access 2000 and visual basic makes an connection to the..

Updating DAO Record Moves it to the End of the Recordset - I am trying to loop through a DAO recordset and replace characters as needed. However, when the replacement consists of just appending a character, the first record in the recordset seems to move to the end of the recordset after the first iteration..

Add new record in DAO recordset locks entire table (using .. - I'm having problem with using DAO recordset in MS Access 2000 to append record into a table. Following is the code: Dim wkSpace As Workspace, db As Database Dim rstTrans As DAO.Recordset Set wkSpace = DBEngine.Workspaces(0) Set db =..
   Database Forums (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]