Format Toolbar

[mark curtis]

Dear All,

1) Can anyone tell me how to edit the toolbar so that it does not shown the icon that allows the database window to be accessed But still allow me to access the icon that lets me export to Word or Excel?

2) Is there anyway to hide the database window or tables in it except other than naming it SYStbl?

Basically I am after securing the database but I can not use Admin because the database is a single mde used by many people. Yes the performance is slow but quicler in this case than using detached tables.

Thanks
Mark

 

[Fornatian]

We must stop meeting like this!

1. The best way to customize a toolbar is to build your own rather than messing about with the standard ones - you never know when you'll need them urgently.

In a bit of space in your toolbar(right hand side at the top), right click to view the list of available toolbars - at the bottom there is a customize option - this will give you the option to copy standard menubar/toolbar options and add your own user defined buttons.

I think it's best to do a bit of reading up on it before you start or you can get in a bit of trouble - as with all things it's about pre-planning.

2. From the database window choose Tools-Startup and unclick 'Display Database Window'
BIG HINT(Take a copy of the database before messing about with this stuff or you could lock yourself out!!!). Close the database and re-open, to re-show the database window hit Alt + F1.
2a. if you are looking to hide specific tables etc right click on them in the database window and choose properties and click the hidden option.

Just a little insight into a massive subject which I'm not super confident about myself.

Ian

 

[Richie]

You could also create a main navigation form set to pop up to cover the entire access window just add command buttons to it to carry out the actions you want, you may find it easier than messing around with toolbars since the wizard will create most of the buttons you want, just a thought.

 

[mark curtis]

Thanks guys, without the help from people like you, life would be so much harder.

Mark