|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 14th, 2007, 03:28 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Report with ADODB.Recordset
How can I use a ADODB.Recordset as datasource of a report.
The data is in a SQL Server. I have no problem connecting to the SQL Server and I can use the data in Forms or in any SELECT, UPDATE, DELETE and INSERT SQL statements without any problem. Only with reports it doesn't work. In the Report_Open event of the report I get a 2593 Runtime-error: This function is not available in a MDB at the commandline: Set Me.Recordset = MyRecordset -- RW 
|
|
#2
May 14th, 2007, 06:12 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report with ADODB.Recordset
Also posted this in de 'dutch' NG -- replied there...
Remove the me. in front of the recordset Maurice "RW" wrote: How can I use a ADODB.Recordset as datasource of a report. The data is in a SQL Server. I have no problem connecting to the SQL Server and I can use the data in Forms or in any SELECT, UPDATE, DELETE and INSERT SQL statements without any problem. Only with reports it doesn't work. In the Report_Open event of the report I get a 2593 Runtime-error: This function is not available in a MDB at the commandline: Set Me.Recordset = MyRecordset -- RW
|
|
#3
May 15th, 2007, 09:16 AM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Report with ADODB.Recordset
Dear Maurice,
Thanks for your answer (both in the English as in the Dutch DG). I did try to remove the Me. in the expression but the same error keeps comming. Set Recordset = MyRecordset Run time-error 2593 This function is not available in a MDB As I indicated I have no problem connecting to the SQL Server and I can use the data in Forms or in any SQL statements in my code without any problem. -- RW "Maurice" wrote: Also posted this in de 'dutch' NG -- replied there... Remove the me. in front of the recordset Maurice "RW" wrote: How can I use a ADODB.Recordset as datasource of a report. The data is in a SQL Server. I have no problem connecting to the SQL Server and I can use the data in Forms or in any SELECT, UPDATE, DELETE and INSERT SQL statements without any problem. Only with reports it doesn't work. In the Report_Open event of the report I get a 2593 Runtime-error: This function is not available in a MDB at the commandline: Set Me.Recordset = MyRecordset -- RW
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
