Windowhide/Unhide

[andrewbaja]

Hi
I have just bought Office 2010. In XP when I build Dbs I use an 'autoexec 'to open the first form. This has the open form command, then 'windowhide' for security. I also run a dummy macro in the forms so that no one can right-click and bypass my security.
From the first form I open another form which has a password textbox, from this, a simple 'windowunhide', and window appears-simple.



I can make 2010 do this, but when I 'windowunhide'-nothing, because there is no window any more, just the stupid ribbon down the side.

Long-live XP because I feel I have just wasted my money on some pretty sparkly things and not much more.

[boblarson]

Long-live XP because I feel I have just wasted my money on some pretty sparkly things and not much more.

Access XP (2002) was not a good version. Access 2003 was much better than it. But besides that, it is much easier to do this stuff in Access 2010 (and give it time and I think you'll discover some real nice features as compared to Access 2002).

First, you don't need an autoexec macro to do this. Of course you didn't in Access 2002 either but that's a moot point.

To set your startup form, go to FILE > ACCESS OPTIONS > CURRENT DATABASE and select your startup form. Then lower down in the list you can uncheck the Show Navigation Pane button and then you should also uncheck the USE ACCESS SPECIAL KEYS checkbox so that F11 can't be used to open the Navigation Pane.

So, I may have missed some of what you want, so if that wasn't all of it, let me know and I, or someone else here, should be able to help you get it set the way you want.

And remember, it is quite a radically different design and it does take some getting used to. But you can't live in the past forever as it will get tougher and tougher to move forward if you stay on something which is going to not even work in future operating systems. So, it is better to not skip too many versions at a time otherwise it can cause you way more work at that point than you might have needed to do, or it can at least spread it out a bit.

[andrewbaja]

[QUOTE=boblarson;63204]Access XP (2002) was not a good version. Access 2003 ..............

Thank you very much. I'll try it and get back to you.

Andrew

[andrewbaja]

Hi Bob
I'll tel you what I want, then if poss, you or someone else can help.

I want to open the db and not see any ribbons or be able to change anything, except, when I, as the administrator wants to.
As I said before I did this via a password box and a windowunhide function.

I just want that no one can accidently change anything
Regards
Andrew

[pkstormy]

I think this will do it:

Docmd.ShowToolBars "Ribbon",acToolBarNo
or
DoCmd.RunCommand acCmdWindowHide (I think this just hides the window)

There's also these commands I found but I can't attest to them (I believe they just work on menu/toolbar items):

CurrentDb.Properties("AllowFullMenus") = false
CurrentDb.Properties("AllowBuiltinToolbars") = false

Note though that once run and set to false, you may need to change it in the options or set them to True to see the menus again.

[andrewbaja]

Thanks very much. I'll try these.

Andrew