98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Primary Key
Primary Key
Resolved · Low Priority · Version 2003
Mon 17 May 2010, 14:32Delegate Beverley said...
Beverley has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course
Primary Key
If i want to set the Primary Key as a school identifying number ie SCH1 can i get acccess to copy that format but changing the number down the list to show SCH2, SCH3 etc or do i have to do each entry manually?
Mon 17 May 2010, 16:59Trainer Tanya said...
RE: Primary Key
Hi Beverley
The answer is yes......
Create a new column and call it SchoolID for example.
Set the data type of SchoolID field to an Autonumber.
Move down into the field properties of that field and add the following code to the Format property: "SCH"&
When you add a record in datasheet view this column will be completed for you by Access. SCH1
The next record will be SCH2 etc....
Best wishes,
Tanya
Tue 18 May 2010, 09:13Delegate Beverley said...
RE: Primary Key
HI I have done this and it works find down to SCH9 and then it goes to 1SCH0, is there anyway to change this to say SCH10?
Many thanks
Tue 18 May 2010, 22:15Trainer Tanya said...
RE: Primary Key
Hi Beverley
Try replacing the code I gave you with the following code
"SCH"0.
Put this in the format property of the SchoolID field. I tested this and it works with SCH10 etc
Tanya
Tue 25 May 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Changing MS Programs Text SizeA handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize. |
