Passing Parameters to stored parameter queries using VB 5's Data Controls 
Author Message
 Passing Parameters to stored parameter queries using VB 5's Data Controls

Hi.

I have a Data control in a VB5 program to manage the main table (Businesses)
and then i'd like to use a data control with a subquery to show all the
contacts for that business. The way im doing it right now is changing the
.recordsource property of the subquery data control every time the main data
control is repositioned.

Is there a way to use stored parameter queries in an Access database,
instead of having to type the SQL in the .recordsource property?

Thank you in advance,

    Nuno Ferreira



Sat, 26 May 2001 03:00:00 GMT  
 Passing Parameters to stored parameter queries using VB 5's Data Controls
See my reply to "VB6 and ACCESS  ..... HELP". Same general principle.

~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please post/reply to the newsgroup(s) so
that everyone can benefit from the discussion.

Regards,

Klaus H. Probst, MCP


       ICQ: 22454937
~~~~~~~~~~~~~~~~~~~~~~~~~~~



Quote:
> Hi.

> I have a Data control in a VB5 program to manage the main table (Businesses)
> and then i'd like to use a data control with a subquery to show all the
> contacts for that business. The way im doing it right now is changing the
> .recordsource property of the subquery data control every time the main data
> control is repositioned.

> Is there a way to use stored parameter queries in an Access database,
> instead of having to type the SQL in the .recordsource property?

> Thank you in advance,

>     Nuno Ferreira



Sat, 26 May 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Passing parameter from VB 6 ADO Data Control to SQL Server Stored Procedure

2. Using a parameter Query with VB data control?

3. Passing parameters into stored procedure using Data Environment

4. Executing Access queries with Data Control and parameter passing

5. passing parameters to an access db's query from VB

6. How to pass datetime parameter to SQL7 Stored Procedure using VB

7. Passing parameters to SQLServer using a Pass-Through query

8. passing parameter to a parameter query

9. URGENT: Can't pass parameters using Crystal ActiveX control

10. Stored, Pass Through, Parameter Query on Access 2k and SQL Server 7

11. Passing Parameters to Crystal Report 5.0 (Stored Procedure Query )

12. Using Parameter Queries and Data Controls

 

 
Powered by phpBB® Forum Software