PKID reference numbers for Query / Form and Tablenames
No idea if this is practical or not and bearing in mind that I haven't used the later versions of access so apologise if this has been done already I like the idea of having autogenerated Object Primary Keys for query form and tablename objects that can be referenced in queries macros and vba. Once you get serious about building something in Access and you start to have 100s of queries forms and tables you sometimes want to tidy things up by giving them better names but find that its impractical as its unclear what VBA might break if you rename things. Using these keys would allow you to easily change the alias names without causing issues. You could even go further and have similar keys for form objects like buttons. I guess you could also reference them in macros and queries by their aliases and just accept that if users did this and the objects were renamed they would have to redo their code. Interested in peoples views on that.
Lightwave
shared this idea
2 comments
-
Lightwave
commented
I would have a feature that would allow the number to be displayed on forms as well - I place labels on my forms
F001 / F002 / F003 / F004 - this is really useful for documentation and any sort of communication help.Please user can you tell me which form you are having trouble with - I'm having trouble on F005 with field X002.
Advanced feature I know but its pretty good!
-
Lightwave
commented
Probably should have said reports as well