Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    48

    Unanswered: Making Access window invisible

    I am calling an Access module from within Excel with ADOB, no problems there.



    When the Access database is opened, the standard form appears. The form is the front end of the database and used by others for another application, but I do not want it shown in this particular application.



    I have made it invisible, but still the Access window with the standard toolbar ( File, Edit , View etc) remains.



    Can anyone please advise how I can programatically minimise this Access window or make it invisible?



    Code:
     
    
    'Excel code
    
    Set objAccess_Tx_Master = CreateObject(strFullPath)
    
    'objAccess_Tx_Master.Visible = True
    
    strPath = Application.ActiveWorkbook.Path + "\" + Application.ActiveWorkbook.Name
    
    FormInvisible = True   ' when Access opens, do not display form on opening
    
    objAccess_Tx_Master.Run "ThrowLoadProfleDataToExcel", strPath, FormInvisible
    
    
    
    
    
    'Access code 
    
    
    
    Sub ThrowLoadProfleDataToExcel(ByRef strExcelPath As String, ByRef FormInvisible As Boolean)
    
     'hide the form frmTransformer
    
        If FormInvisible Then
    
            Form_frmTransformer.Visible = False
    
        End If

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    If you want to minimize all of Access or something to that effect with the form, check the code bank for the Form Manipulation examples. There's a way in the examples where you can minimize all of Access or not even show any of the background Access stuff and show just the popup form (or not show anything). It may or may not be what you want but there's a lot of different examples worth looking at. I've used one of the examples to rid the entire background Access info and show just the popup form which worked rather nicely.

    Other than that, there are parameters you can use (in a shortcut or in vba) when opening an mdb/mde which also might be what you're looking for. For switches when opening Access: http://support.microsoft.com/kb/209207
    Last edited by pkstormy; 01-14-08 at 21:51.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Dec 2007
    Posts
    48
    Found it! Module 2 in FormManipulation2003 .mdb looks like it will do what I wish to do. Many thanks for pointing me in the right direction, Paul, and for posting the Form Manipulation examples

Posting Permissions

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