Results 1 to 2 of 2
  1. #1
    Sarah88 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Aug 2014
    Posts
    3

    Run Database while hiding Access Shell


    Hi I am really hoping someone out there can tell me how to get around this problem. I have made a database and I would like it to run without the Access Shell being visible, I would just like to use forms. I am running Access 2013 64 bit and I have made all the forms I need and have managed to find a solution that worked until I tried to open the "Split Forms" the whole database would lock up. This is the code I am using. I can't use the method of having a background and having that launch my switchboard as I have tried this solution but the switchboard takes up the whole screen and can't be minimized.
    Code:
    'global code
    Declare Function apiShowWindow Lib "user32" Alias "ShowWindow" (ByVal hWnd As Long, ByVal nCmdShow As Long) As Long
    and this is code is being used on the "on open" event on the switchboard form
    Code:
      Dim lWin As Long
        lWin = apiShowWindow(Application.hWndAccessApp, 0)
    I really hope there is a way I can get my split forms to run while hiding the Access Shell.
    I have seen other code solutions such as the one found here http://access.mvps.org/access/api/api0019.htm
    but I dont even know how to implement it as I am very new to vba coding.

    Please help

  2. #2
    burrina's Avatar
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    You would copy that code and paste into a new module and save it. Then when the db opens, you call that code with the criteria you want. Example:
    Call fSetAccessWindow

    HTH

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-27-2014, 05:54 PM
  2. Replies: 3
    Last Post: 01-07-2014, 09:57 AM
  3. Replies: 8
    Last Post: 02-05-2013, 02:36 PM
  4. Access 2010 vs 2003 hiding applications
    By fostekei in forum Programming
    Replies: 1
    Last Post: 12-07-2011, 05:08 PM
  5. Hiding Subtotals in Access 2007 Report
    By kristyspdx in forum Reports
    Replies: 8
    Last Post: 11-30-2011, 11:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums