[mso] Access Unbound Object Frame Fails to Open Excel Chart

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

Shell Trading US Company
909 Fannin St. - Suite 700, Houston, TX  77010, USA

Tel: +1-713-230 3114
Email: Randy.Harding@xxxxxxxxx
Internet: http://www.shell.com


*************************************************************
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).
http://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: