Search results

I have a form, with 3 subforms on it. These subforms simply display a number of records based on a query set in the subforms recordsource property. What I want to do is automatically display the latest records in the subforms at regular intervals without user interaction. What I did was issue...

Hi, In my application, I create a report based on a report template and then create the controls required on it (all through VBA using COPY OBJECT and CREATEREPORTCONTROL commands). As I have to open this report in design mode, the user can see the report being designed, not very pretty! Is...

Is there a way of knowing if a report is opened as a subreport (from some code within the subreport when it is open) and if so what the 'parent' control was (I need to run a query dependent on the subReports parent control) Thanks DS

Hi, I have a table bound to a report (recordsource property set). In the 'detail' proc of the report, I want to know the contents of a field (not used in the report display anywhere) in the current record being formatted for print. How can I do this without setting a control on the report to...

Hi Folks, I've got an a application that prints a number of reports. The contents of the reports are based on a the user selecting a set of criteria to base the data extract on and the type of report to generate - a list, a pie chart or a bar graph. Each one of these types of reports has its...

How can I generate multiple copies of the same report (each will report a differnt set of data). The criteria for each report is held in a table, one record for each copy of the report. I currently loop through this table, alter the query used by the report and then execute docmd.openreport...