Extracting data from reports

[Dhivya]

Hi,


Can we able to extract data from access reports using vba code. If so,kindly help me in this.

[ItsMe]

Data is stored in tables. Use queries to retrieve data from tables. Use Reports and Forms to show data retrieved.

[Dhivya]

I want to take metadata of the report like filters used in the report, layout properties, tables and columns used to build that report. Is there any code available for that

[ItsMe]

You can use DAO to access the properties of QueryDef. Your report will be a QueryDef in the CurrentDB.QueryDefs Collection.
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx