Tags: access, autonumber, complaint, database, entering, form, mainform, microsoft, mysql, number, oracle, sql, table, therecord, tracking, users, value

How to Show AutoNumber Value in Form

On Database » Microsoft Access

2,589 words with 4 Comments; publish: Mon, 31 Dec 2007 00:29:00 GMT; (250202.64, « »)

I have a simple complaint tracking Db with one main table and one main

form for entering data. I need for the users to be able to see the

record number for future reference when they come back to the

application to update or close that record. The record number is field

RecordId and is an AutoNumber field. (Also the primary key) Is there a

way to show the AutoNumber value in the form when a new record is

opened?

All Comments

Leave a comment...

  • 4 Comments
    • DHRRush wrote:

      > I have a simple complaint tracking Db with one main table and one main

      > form for entering data. I need for the users to be able to see the

      > record number for future reference when they come back to the

      > application to update or close that record. The record number is field

      > RecordId and is an AutoNumber field. (Also the primary key) Is there a

      > way to show the AutoNumber value in the form when a new record is

      > opened?

      As soon as the user dirties the record (begins typing) then the ID number

      will become visible. The database doesn't know what the next number will be

      until that happens.

      --

      I don't check the Email account attached

      to this message. Send instead to...

      RBrandt at Hunter dot com

      #1; Mon, 31 Dec 2007 00:30:00 GMT
    • DHRRush wrote:

      > I have a simple complaint tracking Db with one main table and one main

      > form for entering data. I need for the users to be able to see the

      > record number for future reference when they come back to the

      > application to update or close that record. The record number is field

      > RecordId and is an AutoNumber field. (Also the primary key) Is there a

      > way to show the AutoNumber value in the form when a new record is

      > opened?

      Just create a text box w/ the Autonumber column as its ControlSource

      property. You might want to disable and lock the text box so the users

      won't be tempted to mess about w/ it; though they would only get an

      error message saying they can't change it, its best to avoid all that by

      just not allowing them to fiddle w/ it.

      --

      MGFoster:::mgf00 <at> earthlink <decimal-point> net

      Oakland, CA (USA)

      #2; Mon, 31 Dec 2007 00:31:00 GMT
    • You're right, I din't realize it because the second field was a date

      set to autofill with the current date. Once I got to playing with the

      records, it behaved as you described.

      Thanks.

      #3; Mon, 31 Dec 2007 00:32:00 GMT
    • You're right, I din't realize it because the second field was a date

      set to autofill with the current date. Once I got to playing with the

      records, it behaved as you described.

      Thanks.

      #4; Mon, 31 Dec 2007 00:33:00 GMT