Maximising Access window

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Phil Stanton
    #1

    Maximising Access window

    Here is a bit of code which opens an Excel file from a hyperlink activated
    on a form command button

    CreateHyperlink Me!Storage, "", ExcelPath ' Open Excel using Hyperlink
    DoEvents ' Does it's stuff

    fCloseApp ("XLMAIN") ' Close ALL versions of Excel, any
    spreadsheet

    Application.DoC md.Maximize ' Why not
    *************** ***************

    DoCmd.SelectObj ect acForm, Me.Name
    DoCmd.Maximize
    Me.Visible = True

    All works OK,except I am left with a minimised database and minimised form
    on the task bar. Have to click on the minimised form to bring it to full
    size.

    Why is the Application.DoC md.Maximize instruction not working?

    Thanks

    Phil


    Tags: None
    • Phil Stanton
      #2
      Re: Maximising Access window

      Ok Problem solved

      Phil


      "Phil Stanton" <phil@myfamilyn ame.co.ukwrote in message
      news:z9CdnWNZhP cXh6LVnZ2dnUVZ8 radnZ2d@posted. plusnet...
      Here is a bit of code which opens an Excel file from a hyperlink activated
      on a form command button
      >
      CreateHyperlink Me!Storage, "", ExcelPath ' Open Excel using
      Hyperlink
      DoEvents ' Does it's stuff
      >
      fCloseApp ("XLMAIN") ' Close ALL versions of Excel, any
      spreadsheet
      >
      Application.DoC md.Maximize ' Why not
      *************** ***************
      >
      DoCmd.SelectObj ect acForm, Me.Name
      DoCmd.Maximize
      Me.Visible = True
      >
      All works OK,except I am left with a minimised database and minimised form
      on the task bar. Have to click on the minimised form to bring it to full
      size.
      >
      Why is the Application.DoC md.Maximize instruction not working?
      >
      Thanks
      >
      Phil
      >

        Comment

        Previous template Next
        Working...