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 » microsoft-access-courses - Extra column with plus signs and ID is 02 after 99 | Access forum
microsoft-access-courses - Extra column with plus signs and ID is 02 after 99 | Access forum
Resolved · Low Priority · Version Standard
Wed 22 Nov 2006, 23:16Delegate Mark said...
Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Extra column with plus signs and ID is 02 after 99
A user of my database at work showed me the main table in datasheet view and it now has an extra column with + signs against every record and the ID field goes to 99 then each record has ID of 02 after that, it should go to 100, 101 and so on.
Thu 23 Nov 2006, 12:48Trainer Tom said...
RE: Extra column with plus signs and ID is 02 after 99
Hi Mark
By the sounds of it you have a subdatasheet (covered in Access Intermediate Course) in your main table and if you click on the + you will find related records to your IDs.
Also if your IDs are set to Auto Number then your ID would be 100, 101. The fact that you are getting a "02" after each record woud suggest that your Id is not set as your primary field because there are duplications in ID field and default property for the field maybe set to "02". Otherwise hard to say without seeing full database structure.
Hope this has shed some light on the issue. Thanks you for using BEST Training Support Forum. Remeber your collegues, friends and family are invited to use our forum as well.
Regards
BEST Training
Fri 1 Dec 2006, 12:01Delegate Mark said...
RE: Extra column with plus signs and ID is 02 after 99
Thank you Tom, it is resolved now. I think I may have had a link to another table as an experiment then deleted (or something like that). Anyway I over-wrote the first 02 after the 99 as 100 and the rest of the 02s changed to 101, 102 etc--relief!
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:Convert A Form Into A ReportIf there is a form that you want to to save as a report: |
