Disable Ribbon, Buttons, Navigation (1 Viewer)

vagues0ul

Registered User.
Local time
Today, 16:30
Joined
Sep 13, 2018
Messages
103
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?
 

isladogs

MVP / VIP
Local time
Today, 23:30
Joined
Jan 14, 2017
Messages
18,186
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

Code:
DoCmd.SetWarnings False
DoCmd.RunSQL "your SQL statement here"
DoCmd.SetWarnings True

Code:
CurrentDB.Execute "your SQL statement here", dbFailOnError

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
 
Last edited:

Users who are viewing this thread

Top Bottom