Re: Maximising Access window



Ok Problem solved

Phil


"Phil Stanton" <phil@xxxxxxxxxxxxxxxxxx> wrote in message
news:z9CdnWNZhPcXh6LVnZ2dnUVZ8radnZ2d@xxxxxxxxxxxxxxxxx
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
spread***

Application.DoCmd.Maximize ' Why not
******************************

DoCmd.SelectObject 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.DoCmd.Maximize instruction not working?

Thanks

Phil



.


Quantcast