Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 164924 - Last Review: January 19, 2007 - Revision: 2.3
OFF97: DataSource Property Unavailable for Bound Controls
This article was previously published under Q164924
SYMPTOMS
When you add a data-aware (bound) control to a UserForm, the DataSource
property is not available to link the bound control to a Data control.
CAUSE
This behavior occurs when you use any of the following controls:
DBGrid
DBListBox
DBCombo
MSFlexGrid
WORKAROUND
You must use the DataSource property to bind a data source to a control.
Because the DataSource property is not an available property, you cannot
bind the control to a data source. To workaround this problem, use Visual
Basic for Applications commands to populate the controls that are listed in
this article. For additional information, please see the following articles
in the Microsoft Knowledge Base:
164922Â
(http://kbalertz.com/Feedback.aspx?kbNumber=164922/EN-US/
)
OFF97: How to Fill the Microsoft Visual Basic 5.0 FlexGrid Control
164923Â
(http://kbalertz.com/Feedback.aspx?kbNumber=164923/EN-US/
)
OFF97: How to Fill a UserForm ListBox with Database Values
STATUS
Microsoft is researching this problem and will post new information here
in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATION
When you install the Enterprise Edition of Visual Basic version 5.0, the
Microsoft RemoteData control, version 2.0, becomes an additional control
that you can add to the list of available controls for the Visual Basic for
Applications control Toolbox.
Without a RemoteData control, a Data control or equivalent data-aware
controls on a form cannot automatically access data. The RemoteData
and Data controls are examples of DataSource controls. You can perform
most remote data access operations using the DataSource controls without
writing any code at all. Data-aware controls that are bound to a DataSource
control automatically display data from one or more columns for the current
row or, in some cases, for a set of rows on either side of the current row.
To bind a data-aware (bound) control to a field in a database at run time,
you use the Properties window to specify a Data control in the DataSource
property at design time.
NOTE: The DataSource property setting is not available at run time.
APPLIES TO
- Microsoft Word 97 Standard Edition
- Microsoft PowerPoint 97 Standard Edition
- Microsoft Excel 97 Standard Edition
- Microsoft Office 97 Standard Edition
| kbprb kbprogramming KB164924 |
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
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
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please