Recent content by Mona

I get a run time error '13' message for the following line:type mismatch Set rstAgency = dbs.OpenRecordset("Table1") Why am I getting this message. This is the coding I generated: Option Compare Database Public Sub PrintAgencyReport() Dim dbs, Database Dim tdf, TableDef Dim...

Why can't I declare these statements as I did?

I am using Access 2000 and I am getting the following message: user defined type not defined, for the following 2 lines of code: Dim dbs As Database Dim tdf As TableDef I am trying to create 1 large report that gives an agency's name as the form/report page header and a list of...

I am using Access 2000 and I am getting the following message: user defined type not defined, for the following 2 lines of code: Dim dbs As Database Dim tdf As TableDef I am trying to create 1 large report that gives an agency's name as the form/report page header and a list of...

I am using Access 97. I created 1 large report that gives an agency's name as the form/report page header and a list of Names, SubAgency, and Email on the body/detail of the page. I want to break up the large report into smaller reports based on each agency and I want create a file for each...

I am using Access 97. I created 1 large report that gives an agency's name as the form/report page header and a list of Names, SubAgency, and Email on the body/detail of the page. I want to break up the large report into smaller reports based on each agency and I want create a file for each...

I am using Access 97. I created 1 large report that gives an agency's name as the form/report page header and a list of Names, SubAgency, and Email on the body/detail of the page. I want to break up the large report into smaller reports based on each agency and I want create a file for each...

I have one large report in which I force a new page based on the group header(agency). This generates a new page for each unique agency. I want to know if it is possible to save each new forced page as a report. Is there is a procedure to generate each report and save each report to file?

I have 1 report I generated from 1 table. I need to generate multiple reports from this one report. I want to seperate the reports specific to what the user needs. I want to email and save these separate reports. Is there a procedure to generate these separate reports? Thanks for your help!