Manually assign unique numbers in the asset id field box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nuuser4access03 - 29 Apr 2008 23:04 GMT

I am new to access 2003 and trying to learn how it works. I am in charge for
checking out materials at my company and was hoping i can use Access 2003 to
keep track instead of an excel spreadsheet that i am currently using...
Therfore i created an existing template that was on my computer labeled Asset
Tracking. I followed the steps through the wizard to create the database and
want to change a couple of things which i dont know how... First there are
certain fields that i do not want the template to have for example employee
id, work phone, depreciating value etc. How do i remove those fields without
altering anything else in the database??? Second on the asset id field box
the database creates an auto number when entering and assigning assets to an
employee... How do you disable the auto number feature so i can manually
input a unique number for that asset??? I have been searchin and searchin for
nearly two years now for an answer and still have not solved the problem.
Will someone please help!!!

Reply to this Message

Arvin Meyer [MVP] - 29 Apr 2008 23:51 GMT

The answer to all your questions is the same. You can easily alter the
design of a table (assuming that you don't violate your data integrity, if
you've already entered data) by opening the table in design view and
changing or adding and deleting anything you want to. Change the autonumber
to a long integer (they are the same datatype) or if your AssetIDs are
really text, change the datatype. Make sure that you change the
corresponding fields in other tables. You will probably break relationships
if you change datatypes or delete Primary Keys, so you need to see what they
are prior to your starting, and re-establish them after you have finished.

One nice thing about Access, is that you can easily make copies and
experiment, confident in the knowledge that you are working on a copy. Once
you are satisfied, just use the final copy and save the original somewhere
else, or delete it.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I am new to access 2003 and trying to learn how it works. I am in charge
>for
[quoted text clipped - 18 lines]
> nearly two years now for an answer and still have not solved the problem.
> Will someone please help!!!

Reply to this Message

nuuser4access03 - 30 Apr 2008 00:10 GMT

I will go ahead and try what you mentioned below... Thank You Very Much for
your help!!

> The answer to all your questions is the same. You can easily alter the
> design of a table (assuming that you don't violate your data integrity, if
[quoted text clipped - 32 lines]
> > nearly two years now for an answer and still have not solved the problem.
> > Will someone please help!!!

Reply to this Message