Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2003
    Location
    england
    Posts
    95

    Unanswered: opening db without seeing tabes etc

    i want to open the db straight from file with no tables etc showing at the time!

    Churz guys!

  2. #2
    Join Date
    Apr 2004
    Location
    Scotland
    Posts
    24

    Cool Re: opening db without seeing tabes etc

    Originally posted by lucyg_2000
    i want to open the db straight from file with no tables etc showing at the time!

    Churz guys!
    If i remember correctly - go to the tools - startup from your menu bar

    there will be a window popup with the option (top right) Display Form/Page:

    If set this to none (from the drop down) and click OK.

    If you don't want to see the database window unchek the box beneath this drop down menu!

    HTH

    Cam

  3. #3
    Join Date
    Apr 2004
    Location
    Scotland
    Posts
    24

    Re: opening db without seeing tabes etc

    what do you mean jsut the app - do you mean only the access app without anything in it
    or
    your application (ie a form) that opens when you start access??

    Cam

    ps when you reply hit reply and not a new thread!

  4. #4
    Join Date
    Nov 2003
    Location
    england
    Posts
    95
    lol i know! i keep on doing that!

    i mean say the client is accesing it from c: drive the application (just the forms) will open up.

    lucy

  5. #5
    Join Date
    Apr 2004
    Location
    Scotland
    Posts
    24

    Talking

    Originally posted by lucyg_2000
    lol i know! i keep on doing that!

    i mean say the client is accesing it from c: drive the application (just the forms) will open up.

    lucy
    What i'd do is on the tools-startup choose the form that you want to open up first and record it here

    is if you have main page (as a form) it will be in this list, click on it and click OK at the bottom and your done

    HTH
    Cam

    ( from this you can get a 'splash screen' - ie wleocme to this dB or something!)

  6. #6
    Join Date
    Nov 2003
    Location
    england
    Posts
    95
    but it still displays the menu bars at the top

  7. #7
    Join Date
    Apr 2004
    Location
    Scotland
    Posts
    24
    there is an option to disable the menu bar - bottom left - but as i haven't tried this i'm not sure what it'll do (and if it can be reversed -BACK UP just in case it all goes wrong)

    Anymore than this and i'm in the league of amateurs i'm afraid!

  8. #8
    Join Date
    Nov 2003
    Posts
    1,487
    From what I can piece together here, it seems like you want to display just your database application without the Access parent window displayed in the backgound.

    If this is the case then one method (and the most commonly used through VBA) is to use the API function ShowWindow which is pooled from within the USER32.DLL file.

    Here's a couple routines for you. Place them into a database code module:
    Code:
    'This Function is used to either Maximize, Minimize, Show
    'as Normal, or to Hide Access altogether.
    
    'This function can  be used to completely hide
    'Access window and just show your form on the desktop.
    'Make the form popup and from it's Open Event, call the
    'fSetAccessWindow function with SW_HIDE as the argument.
    'Warning: If you're hiding the main Access window, make
    'sure your error handlers are good. Because with the
    'window hidden, if an error is raised, pressing "End"
    'on the Error window will NOT make Access window visible
    'and you will be left with just the form open. A
    'recommended method is to make a call to fSetAccessWindow
    'with SW_SHOWNORMAL from your error handlers.
    
    
    '************ Code Start **********
    '
    Global Const SW_HIDE = 0
    Global Const SW_SHOWNORMAL = 1
    Global Const SW_SHOWMINIMIZED = 2
    Global Const SW_SHOWMAXIMIZED = 3
    
    Public Declare Function ShowWindow Lib "user32.dll" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long
    
    
    Public Sub HideAccess()
        Call ShowWindow(Access.hWndAccessApp, SW_HIDE)
    End Sub
    
    Public Sub ShowAccess()
        Call ShowWindow(Access.hWndAccessApp, SW_SHOWNORMAL)
    End Sub
    USAGE:

    In the On Open event of your main startup Form use the HideAccess Sub procedure.

    In the On Close event of your main startup Form use the ShowAccess Sub procedure.

    Have fun......


  9. #9
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Look up StartupShowDBWindow
    or
    AllowSpecialKeys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •