G
Guest
I am new to access reporting.
I am develping an application with Access 2K as front end (GUI) and SQL Server 2K as back end to hold the database.
I need a VBA code sample (or URL) to do following things:
1. Execute a stored procedure on SQL 2K
2. Get ADODB recordset and assign to report
3. Open report in preview mode
Please suggest me, if there are any other ways to do this.
Thanks in advance.
I am develping an application with Access 2K as front end (GUI) and SQL Server 2K as back end to hold the database.
I need a VBA code sample (or URL) to do following things:
1. Execute a stored procedure on SQL 2K
2. Get ADODB recordset and assign to report
3. Open report in preview mode
Please suggest me, if there are any other ways to do this.
Thanks in advance.