Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / January 2004

Tip: Looking for answers? Try searching our database.

Autonumber

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
netadmin - 22 Jan 2004 05:04 GMT
I would like to know if it is possible to have a
autonumber field work to produce the following. I would
like the autonumber to grab the initals of the user from
a text box and add a number sequence to it. Any code
would be appreciated.

Thanks
Ken Snell - 22 Jan 2004 05:14 GMT
No, the autonumber won't store letters in its field. Add another field to
your table that will hold the user's initials, and then write those initials
into the record when you create the record.

If you want to display the combination of the autonumber value (hint:
autonumber values are best used "in secret" and not shown to users) and the
user's intials, you can always concatenate the two values into a single
string value:

   [autonumberfield] & [userinitials]

Signature

      Ken Snell
<MS  ACCESS MVP>

> I would like to know if it is possible to have a
> autonumber field work to produce the following. I would
[quoted text clipped - 3 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.