[mso] Re: Access Unbound Object Frame Fails to Open Excel Chart
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Thu, 17 May 2007 15:48:38 +0200
Randy,
Long shot... Have you tried using DoEvents?
HTH
Lisa
> I believe this is an Excel issue even though I start out
> talking about MS Access.
> I have an Access application containing a form with two
> unbound object frames. Each object frame contains an Excel
> chart. The objects are set to "Auto Activate" on GetFocus.
> When I click on each object individually they open without
> any problems.
>
> The problem is that I want to use a command button on the
> form whose OnClick process does a Me.cntlDeals.SetFocus and
> then a Me.cntlSchedule.SetFocus command. When I click on the
> command button Access activates a window containing Excel and
> the first object opens without any problems, but when Access
> attempts the second SetFocus command I get an Excel
> Application error. The error is:
>
> The instruction at "0x300baff9" referenced memory at
> "0x00000000". The memory could not be "read".
> When I click on the command button I sometimes get the error
> listed above. On other occasions when I click on the command
> button the first spreadsheet opens without problems and the
> second one opens, but only after I have made the Access
> window containing the command button active again.
>
> I have tried putting a 4 second delay between the two
> SetFocus commands thinking that Excel needed more time to
> become fully functional before I attempted the second
> SetFocus. This did not work.
>
> I don't understand how the .SetFocus command differs from
> actually clicking on the unbound object on the Access form.
> In both cases the focus is set on the unbound object frame
> thus the AutoActivate on GetFocus occurs. The only difference
> that I see is that when manually clicking on each form you
> actually have Access as the active window. When
> programmatically running the .SetFocus, Excel is the active
> window for the second .SetFocus command.
>
> Clicking on the unbound object on my Access form sets the
> focus to that object. When I click on the first unbound
> object on the Access form Excel starts and the chart opens
> within that instance of Excel. When I click on the second
> unbound object the second chart opens within the instance of
> Excel which is already running. This works without failure. I
> think the key to this working without failure is that Access
> is the active window at the time the unbound object is activated.
>
> If I place a MsgBox comment between the two .SetFocus
> commands the error goes away. Unfortunately, I have to go
> back to the Access form to reply to the MsgBox window. My
> users will not like having to do that. There must be
> something happening when I go back to Access to reply to the
> MsgBox that is clearing up the problem. I need to find some
> way to programmatically give the Access instance control
> (make the window active) without making its window visible.
> That is to say, keep the Excel instance visable while at the
> same time giving Access what it needs to get the second chart
> up and running.
>
> Sorry for being so long-winded on this. Any suggestions?
>
>
>
>
>
>
> Randy Harding
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.467 / Virus Database: 269.7.1/807 - Release Date: 16/05/2007
18:05
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
