Forum Discussion
ACCDE File - Hide Everything
Hello
I have a database for which I want to hide the navigation pane and the menu ribbon (everything) in a ACCDE file.
I just want my Home Page Form to open when the link to the app is selected and nothing else is visible.
DoCmd.ShowToolbar "Ribbon", acToolbarNo does not work.
I have tried a link on one of the previous answers and error 404 came up.
Help would be greatly appreciated.
Kindest regards
Adrian
rename your .accde as .accdr (runtime)
16 Replies
maybe you should check your startup code again. renaming it to .accdr will not result to any error.
remove/comment out all "On Error Resume Next" lines and compile your code.
btw, I tested:
DoCmd.ShowToolbar "Ribbon", acToolbarNo
and it did work on hiding the ribbon.
Hi Everyone.
The .accdr file change did the trick. I don't know how the error was fixed but when I closed the database twice and re-opened it there was no error, and everything is locked tight.
Thanks to everyone who contributed to fixing my problem.
It is greatly appreciated.
Kindest regards
Adrian.
merely renaming to .accdr will not cause any errors.
maybe your startup code has some errors. try compiling your db first.
and make sure to comment out code like:
On Error Resume Next
BTW, i tested:
DoCmd.ShowToolbar "Ribbon", acToolbarNo
and it did hide the ribbon. so the problem is that somewhere you have
errors and you disable the error handler.
Hi arnel_gp
The .accdr file change did the trick. I don't know how it was fixed as I closed the database twice and the third time there was no error. Everything is lock up tight.
Thanks to you and everyone who contributed to my problem. It is greatly appreciated.
Kindest regards
Adrian
Hi arnel_gp
The .accdr file change did the trick. I don't know how it was fixed as I closed the database twice and the third time there was no error. Everything is lock up tight.
Thanks to you and everyone who contributed to my problem. It is greatly appreciated.
Kindest regards
Adrian
Hi,
I want to hide the navigation pane
File - Options - Current Database - Navigation - untick Display Navigation Pane
DoCmd.ShowToolbar "Ribbon", acToolbarNo does not work.
That's strange. Where and when do you use it?
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEKHi Karl
I am currently using it on my C Drive but want to move it to our Server when it works.
Regards
Adrian
Hi Adrian,
What I meant: Where and how do you use this line of code to hide the ribbon? In which object, event, procedure, surrounded by what other code? Because usually, it just works.
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
rename your .accde as .accdr (runtime)
Hi Arnel_gp
It partially worked but this error appeared.
This points to an unhandled runtime error. It is a best practice to have an error handler in all procedures. Check out this presentation of the error handler in Northwind sample database, which you could borrow for your project: AP: Enhanced Global Error Handlers in Northwind 2.2 With Tom van Stiphout and Kim Young
For Hide the Ribbon, how about :
Application.CommandBars("Ribbon").Visible = FalseHi Kidd_lp
It did not work.
Hi Kidd_lp
Did not work.
