Finally i have completed most of my form design and code and now i want the form to be loaded without any menu or ribbon of access. Also i want to disable message when entering a data into table via query. So what type of code or action/s i need to achieve the task?
To disable warning messages when running action queries, go to Access options, client settings and untick the checkbox next to Action queries. However:
a) this means you won't be warned when a serious error occurs - bad news
b) as its a client setting, it needs to be made on each client PC
A better method is to replace your queries with VBA statements using one of the following methods