get the record number from the access db

hai,
I want to get the record number in access using select statement. please help. Thanks in advance.
indra.G

indra

You cannot get a record number in access. You can only identify it by it's primary key or other unique value.

Mary

hai,
I want to get the record number in access using select statement. please help. Thanks in advance.
indra.G

'As far as I know, you cannot retrieve it via a SELECT Statement but this is
'how I retrieve it via VBA coding:

Nice piece of code ADezii.

I assume it only works if the form is based on the table with no criteria or sort order.

Mary

'As far as I know, you cannot retrieve it via a SELECT Statement but this is
'how I retrieve it via VBA coding:

Expand|Select|Wrap|Line Numbers

1. Dim recClone As DAO.Recordset
2.  
3. Set recClone = Me.RecordsetClone()             'Copy of the Form's underlying Recordset
4. recClone.Bookmark = Me.Bookmark             'Resync Bookmarks
5. Debug.Print recClone.AbsolutePosition + 1    'Returns the Record Number

Nice piece of code ADezii.

I assume it only works if the form is based on the table with no criteria or sort order.

Mary

Sir,
I have created a database in access and iam using vb as front end. For the data report the data source is dataenvironment.For e.g I have nearly 100 records and i am selecting few records based on a condition in the dataenvironment sql command(select * from contract where vtcno>?) and placing the dataenvironment as the data source to the data reort. The selected records should be numbered(1,2,3...) in the data report by adding an additional field in the data report.
thnaks
indra

If you are creating your frontend in VB you might want to post this in the Visual Basic forum as well. Some of their experts do hang out here but you are more likely to get an answer to your question over there.

Mary