Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Microsoft ISV Community Center Forums >> Visual Basic for Applications (VBA)

Hiding the Database Window

Hello. I have been developing a reporting system in Access, and want to hide the database window before distributing the file to the users. I've tried using the settings on the Startup dialog box, and I've also tried setting the "StartupShowDBWindow" property programmatically via VBA, but nothing happens. I don't get any error messages, but the database window stays visible. Any suggestions? Thanks
[414 byte] By [RachM] at [2007-12-23]
«« DropDownList SelectedIndexChanged not firing
»» cluster discrimination scores
# 1

Hi,

That's odd! Have you set up user groups as it could be, although can't be sure, that you may have admin permission to the database and so the database window is shown. While other users the database window isn't displayed, do you have a test machine to try out what the user will see when they run the database, if so try the database out.

DerekSmyth at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 2
Thanks for the suggestion. I have actually managed to solve the problem by exporting all my forms, reports, queries, modules into a new database, and now it works fine. So it looks like it's just an Access funny...
RachM at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 3
Well I thought I'd solved it, but I haven't! As part of the startup process, I programatically re-attach the tables, and this is why the Database Window is visible. If I comment out the line calling the function to re-attach the tables, then the Database Window is hidden as I want. Can anyone suggest a way to ensure that the Database Window remains hidden while the tables are re-attached? Thanks
RachM at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 4

Try this:

DoCmd.SelectObject acForm, , True

DoCmd.RunCommand acCmdWindowHide

Put this code somewhere in the start up, or in the initial startup form. This code will actually hide the database window at anytime.

QE at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
# 5

Make sure you make a back up, you don't want to lock yourself out.

DerekSmyth at 2007-8-30 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
Microsoft ISV Community Center Forums
Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified