Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Access Training and help » access training course - Access Primary Keys
Resolved · Low Priority · Version Standard
Reza has attended:
Excel Advanced course
I have got two questions; In regards with primary key, how can access increment user specified PK. In other words, if I decide to set my OWN primary key (i.e. 9874, 9875, 9876,...) how can we assign Access to increment by one each time we enter the new data/record in form.
My next question is, I have seen in other forms that once user enters the date into one field, the information for other specified field retrieved automatically. For example, as soon as I insert the Date into my Date Field of my form, the Week number pops out into my Week Number field. I think this is something to do with Lookup/Searching wizard.
Thank you
Hi Reza
As far as the primary keys in Access goes, you just need to set the start number of the primary key and then Microsoft Access will auto-increment the same as normal. So you are still using auto-number, but you are just giving Access a user defined start number.
In relation to the auto fill, you would be best by checking with the developer of you system as they could be using vba or visual basic coding.
Hope this helps
David
Hi David,
I have tried on many occasions to define my own start number for primary key and let Access to auto-increment it. Still it does not work. Can you please instruct me step-by-step how do I define it.
Also recently I have error msg "OpenReport Action Cancelled " when I attempt to click on my buttons. Any solutions?
Regards
Rez
|
|
Access tip:Insert The Current TimeTo insert the current time into a Table field or Form textbox use: |
TrustScore
4.8
/ 5
2239 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
