How To Populate DBGrid from Crosstab Parameter Query (172593)
The information in this article applies to:
- Microsoft Visual Basic Professional Edition for Windows 5.0
- Microsoft Visual Basic Professional Edition for Windows 6.0
- Microsoft Visual Basic Enterprise Edition for Windows 5.0
- Microsoft Visual Basic Enterprise Edition for Windows 6.0
- Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
- Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
This article was previously published under Q172593 SUMMARY
This article demonstrates how to create a Parameter Crosstab Query using
the sample Nwind.mdb Access database file. It also explains how to create a
recordset in Visual Basic by running the query, passing the necessary
parameters to it, and then populating a Visual Basic DBGrid with the
resultant recordset.
REFERENCES
Visual Basic Help topic "PARAMETERS Declaration"
For more information, please see the following article in the Microsoft
Knowledge Base:
91710
: Can't Bind Name '[XXX]'" Error with Crosstab Query
Modification Type: | Minor | Last Reviewed: | 7/1/2004 |
---|
Keywords: | kbhowto KB172593 |
---|
|