We can found here some of tricks that we can use in MS Access
https://msdn.microsoft.com/en-us/library/aa662933(v=office.11).aspx
https://www.experts-exchange.com/articles/18341/CommandBars-Part-III-Using-Built-in-Shortcut-Menus.html
http://www.fmsinc.com/microsoftaccess/DatabaseSplitter/index.html
https://www.everythingaccess.com/tutorials.asp?ID=Error-Handling-in-Access-Basic
https://www.access-programmers.co.uk/forums/threads/error-handling.204831/
if property sheet not visible use
- Press CTRL G to get an immediate window
- Enter this: CommandBars("Property Sheet").Enabled = True and hit Enter
selecting the autonumber field by
SELECT @@identity FROM MyTable