Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 199028 - Last Review: July 15, 2004 - Revision: 1.1
ACC2000: Cannot Use acOLEDelete to Clear Object Frame
This article was previously published under Q199028
Advanced: Requires expert coding, interoperability, and multiuser skills.
You cannot use the
acOLEDelete argument of the
Action method to clear an unbound object frame.
To work around this problem, set the unbound object frame's
Visible property to
False to hide it from the screen. To do so, follow these steps:
- Open the sample database Northwind.mdb.
- In the Database window, click Forms under Objects, and then click New.
- Create a new form not based on any table or query, and save the form as form1.
- Add an unbound object frame to the form. In the Insert Object dialog box, click Create from File, and then click Browse.
- Browse to the Windows folder, and double-click Setup.bmp.
- Click OK.
- Right-click the unbound object frame, and click Properties on the menu that appears.
- Set the following properties of the unbound object frame:
Name: Ole1
Enabled: Yes
Locked: No
- Add a command button to the form. Right-click the button and change the Name property to Btn1.
- Set the OnClick property of the command button to the following event procedure:
Private Sub btn1_Click()
Me!OLE1.Visible = FALSE
End Sub
- Open form1 in Form view and click the command button. Note that the unbound object frame disappears from the screen.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior
- Repeat steps 1 through 8 of the "Resolution" section.
- Set the OnClick property of the command button to the following event procedure:
Private Sub btn1_Click()
Me!OLE1.Action = acOLEDelete
End Sub
- Open form1 in Form view, and click the command button. Note that the unbound object frame is not cleared.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate