Change reports properties using msysobjects

  • Thread starter Thread starter Costinu
  • Start date Start date
C

Costinu

Hello,

I have a problem and I don't know how to handle it.

I want to read and change reports recordsource using msysobjects
table, but I can update this table and I don't know what to update.

It seems I know nothing :)

Please help me!!

Costin Calnuschi
 
You can only change the SQL of the saved query a report is based on or open
the report and change the Row Source property.
 
I want to change the report RecordSource only when is a SQL statement.
I want to create a query in database (this I know how to do it) with
the SQL statement of report and to change the RecordSource with the
name of the query.
The problem is that I have to do this using DAO. If I use Access
object is very simple. I search for 4 days and I think the solution is
to update system tables, but I don't have the permision to do this and
I don't know realy where I need to update.

Thank you.
Costin Calnuschi
 
Back
Top