Thanks all.
I know that is possible to use RecordSource property but Access don't like sql string like SQL Server :)
I made another way ... I created by query a temporary table and attached my report to this temporary table.
I think that it is a good way for to not lose time to change sql...
Hi all.
When I try to set a recordset for a report appear an error message:
Run-time error 2593
This feature is not available in an MDB.
My source code is simply:
Dim Rs as ADODB.Recordset
Set Rs = New ADODB.Recordset
SqlString = "SELECT * FROM Table"
Rs.Open SqlString, conn
Set...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.