Re: Maximising Access window
- From: "Phil Stanton" <phil@xxxxxxxxxxxxxxxxxx>
- Date: Sat, 31 May 2008 21:56:49 +0100
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
.
- References:
- Maximising Access window
- From: Phil Stanton
- Maximising Access window
- Prev by Date: Many to many relationship
- Next by Date: Re: Many to many relationship
- Previous by thread: Maximising Access window
- Next by thread: Reset subtotal within a query
- Index(es):