need for a field with record no.

  • Thread starter Thread starter ezil
  • Start date Start date
E

ezil

I need a field which always shows the record no of that record other than id
field
Any function is there to do this? Otherwise how to do this If i sort the
records, the field value also should change to currect record no.
 
The record navigation buttons in Access already do that. If you want custom
code, just set a textbox equal to:

=IIf([NewRecord],"New Record",[CurrentRecord] & " of " & Count(*))
 
Actually i want these details directly on table not by seeing the form or
report text box. If i number sequentially also if anybody enter previous date
details and after sorting out it again become not in sequence. I dont want to
create a form for this table
 
Actually i want these details directly on table not by seeing the form or
report text box. If i number sequentially also if anybody enter previous date
details and after sorting out it again become not in sequence. I dont want to
create a form or query for this table


Arvin Meyer said:
The record navigation buttons in Access already do that. If you want custom
code, just set a textbox equal to:

=IIf([NewRecord],"New Record",[CurrentRecord] & " of " & Count(*))
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


ezil said:
I need a field which always shows the record no of that record other than
id
field
Any function is there to do this? Otherwise how to do this If i sort the
records, the field value also should change to currect record no.
Click to expand...


.
Click to expand...
 
You should not give users direct access to tables nor to queries because it
is so easy to make a mistake and edit or delete something the user should
not have done. By architecture (relational database design principles) and
design, Access tables do not have a "record number" (though if you don't
insist on monotonically-increasing sequential numbers, Autonumber comes
close). When developing an application, I sometimes open a table directly,
but when I package it for users, I do not give them that capability.


I don't know why you would be opposed to creating a form, but that's your
choice.

I for one, however, won't be jumping through any hoops to try to assist you
in using the product wrongly.

Larry Linson
Microsoft Office Access MVP
 
Then you will have to look at the record navigation box at the bottom of the
table. If you are the only one who will ever look at the data, you may work
from tables or queries. If more than 1 person ever uses your application,
you should NEVER allow them to view data directly through tables or queries.
It is far to easy to make a mistake and delete lots of data when using a
table or query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


ezil said:
Actually i want these details directly on table not by seeing the form or
report text box. If i number sequentially also if anybody enter previous
date
details and after sorting out it again become not in sequence. I dont want
to
create a form or query for this table


Arvin Meyer said:
The record navigation buttons in Access already do that. If you want
custom
code, just set a textbox equal to:

=IIf([NewRecord],"New Record",[CurrentRecord] & " of " & Count(*))
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


ezil said:
I need a field which always shows the record no of that record other
than
id
field
Any function is there to do this? Otherwise how to do this If i sort
the
records, the field value also should change to currect record no.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top