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 / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Manually Input Numbers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nuuser4access03 - 29 Apr 2008 20:05 GMT
I am currently a new user with access and dont know the entire features of
the program yet.  I created an Asset Tracking database using the on my
computer templates.  First, how do you manually input numbers on the asset id
field box when entering new assets and assign it to someone for check out
purposes??
quasimodo - 30 Apr 2008 11:58 GMT
nuuser4access03;2746811 Wrote:
> I am currently a new user with access and dont know the entire feature
> of
[quoted text clipped - 5 lines]
> out
> purposes??

You can't 'manually input numbers' on the assetId because it i
AutoNumber. Fill in the other text boxes and you will see AssetId wil
increment itself.. 1, 2,3....
AutoNumber is used for PK. If you want to input AssetID you have t
change Data Type of Field Name AssetID from autonumber to tex

--
quasimodo
Ron2006 - 30 Apr 2008 13:54 GMT
Or add another field to the table and call it  ASSET-ID or something
like that and add it to the forms etc to manually enter the "number"
there.

Ron
 
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.