Hiding the Database Window

Hot Topic

Adding a command button to the toolbar or menu bar in Excel?
Left, Mid and Right functions not working on Office 2003
Control Break Trap will not work whilst Userform is displayed
IsError function from VBA6.3 to v6.0
VBA code for searching multiple tables in an Access database
Combo Box Syntax Error
Help with a formula
Strange problem with saving to a FTP-server
Excel disjunction
iexplore.exe - Application Error

Microsoft ISV

Help with reworking this code fragment to update from user input...
On Error not catching problem with a web query
VBA script not accessing another workbook
Passing field information from VB Express to MS Word 2000
Excel function PRICE
Automation Error During Execution of Stored Procedure Using ADO
VB .NET vs Access (combobox)
personalized command bar disappears when minimizing excel
Own Right-Mouse-Click Menu item in Outlook
Contact in Canada

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

Answer this question

Hiding the Database Window

  • rternier

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



  • Sumit_Dagar_8eba6d

    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.



  • thundur

    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...

  • Imesh

    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

  • the emrah

    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.



  • Hiding the Database Window
Answer this question