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?
Disable Ribbon, Buttons, Navigation
- Thread starter vagues0ul
- Start date
isladogs
MVP / VIP
- Local time
- Today, 06:01
- Joined
- Jan 14, 2017
- Messages
- 18,942
See this example app for all the code you need to remove menus/ribbon etc: Controlling the application interface
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
The first of these also means you won't see messages when there is an error
The second is better as you will ONLY see a message when an error occurs
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
Code:
DoCmd.SetWarnings False
DoCmd.RunSQL "your SQL statement here"
DoCmd.SetWarnings True
Code:
CurrentDB.Execute "your SQL statement here", dbFailOnErrorThe first of these also means you won't see messages when there is an error
The second is better as you will ONLY see a message when an error occurs
Last edited:
will give it a try and let you konw
