Can order number be displayed in a Form?

[Guest]

I have a Form set to 'Tabular' formatting, whereby ALL the records are listed. Is there any way to t display the order number for each record? For example, if five records are displayed, I want a 1, 2, 3, 4, and 5 to appear at the far left of the records. I know that this can be done in a Report, but I haven't figured out how to do this in a Form. I'm NOT looking for something here that will permanently store this data, I just want the records to be numbered when displayed in a tabular Form.

Any help would be appreciated.

 

[Cheryl Fischer]

You might want to take a look at:

http://www.lebans.com/rownumber.htm



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have a Form set to 'Tabular' formatting, whereby ALL the records are

listed. Is there any way to t display the order number for each record? For
example, if five records are displayed, I want a 1, 2, 3, 4, and 5 to appear
at the far left of the records. I know that this can be done in a Report,
but I haven't figured out how to do this in a Form. I'm NOT looking for
something here that will permanently store this data, I just want the
records to be numbered when displayed in a tabular Form.

 

[Guest]

Thanks Cheryl; I downloaded the example database off that URL, but when I try to open it on my machine, it requires a name and password. I looked around on the site to see if this issue was addressed, but I didn't see anything. Just that the author refuses to answer emails. Any ideas?

----- Cheryl Fischer wrote: -----

You might want to take a look at:

http://www.lebans.com/rownumber.htm



--
Cheryl Fischer
Law/Sys Associates
Houston, TX

I have a Form set to 'Tabular' formatting, whereby ALL the records are

listed. Is there any way to t display the order number for each record? For
example, if five records are displayed, I want a 1, 2, 3, 4, and 5 to appear
at the far left of the records. I know that this can be done in a Report,
but I haven't figured out how to do this in a Form. I'm NOT looking for
something here that will permanently store this data, I just want the
records to be numbered when displayed in a tabular Form.

 

[Cheryl Fischer]

I just downloaded another copy, extracted the MDB file from the ZIP file and
opened the database. No password was required. It occurs to me to ask if
you have other databases on your pc which are secured by Access Security.
Perhaps that may be causing the problem.


--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Thanks Cheryl; I downloaded the example database off that URL, but when I

try to open it on my machine, it requires a name and password. I looked
around on the site to see if this issue was addressed, but I didn't see
anything. Just that the author refuses to answer emails. Any ideas?

 

[Cheryl Fischer]

Regarding not receiving an email response, many/most of the frequent
responders in Access, as well as other, newsgroups do not respond to private
emails. It is not a question of "refusal" per se but the belief that any
question and resulting answers posted will benefit others who use the
newsgroups as a reference source. Anything else is "unpaid consulting".

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Thanks Cheryl; I downloaded the example database off that URL, but when I

try to open it on my machine, it requires a name and password. I looked
around on the site to see if this issue was addressed, but I didn't see
anything. Just that the author refuses to answer emails. Any ideas?

 

[Guest]

Thanks Cheryl, yes, that was exactly the problem. I was set up under a different database workgroup. I opened the file with no problem! Now to see if there's anything in it that I can use..



----- Cheryl Fischer wrote: ----

I just downloaded another copy, extracted the MDB file from the ZIP file an
opened the database. No password was required. It occurs to me to ask i
you have other databases on your pc which are secured by Access Security
Perhaps that may be causing the problem


-
Cheryl Fische
Law/Sys Associate
Houston, T

Thanks Cheryl; I downloaded the example database off that URL, but when

try to open it on my machine, it requires a name and password. I looke
around on the site to see if this issue was addressed, but I didn't se
anything. Just that the author refuses to answer emails. Any ideas

 

[Guest]

Oh, I wasn't being critical of this; I was just wanting to head off any potential suggestions that I contact the author of this database directly. Thanks for the help today

Rober



----- Cheryl Fischer wrote: ----

Regarding not receiving an email response, many/most of the frequen
responders in Access, as well as other, newsgroups do not respond to privat
emails. It is not a question of "refusal" per se but the belief that an
question and resulting answers posted will benefit others who use th
newsgroups as a reference source. Anything else is "unpaid consulting"

-
Cheryl Fische
Law/Sys Associate
Houston, T

Thanks Cheryl; I downloaded the example database off that URL, but when

try to open it on my machine, it requires a name and password. I looke
around on the site to see if this issue was addressed, but I didn't se
anything. Just that the author refuses to answer emails. Any ideas

 

[Cheryl Fischer]

The author is an MVP and frequent responder to questions in the various
newsgroups devoted to Access. Should you have a question about the database
or need help in implementing it, Stephen Lebans will see your post in the
newsgroup.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Oh, I wasn't being critical of this; I was just wanting to head off any

potential suggestions that I contact the author of this database directly.
Thanks for the help today!

 

[Cheryl Fischer]

You're welcome.

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

Thanks Cheryl, yes, that was exactly the problem. I was set up under a

different database workgroup. I opened the file with no problem! Now to see
if there's anything in it that I can use...