Recent content by DS

tried that, doesn't work....refresh simply updates and data that has altered, not add/remove records that match the query. I have also tried setting the timer and event property of the sub-forms and running them as individual forms....still no joy....so problem not to do with the fact they are...

Depending on how the data is bound to the tabs, I think you'll find that you have to run some VBA code on the delete event for the data (or create a command button) that deletes the records in the other tables. DS

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...

But doesn't the parent name return the name of the calling 'Report' and not the subreport control on the parent (i've got multiple subreport controls and i need to know which one was bound to my subReport)??? Thanks DS

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...

Thanks. I was thinking of the same, but if my memory serves me right, sub-reports do not replicate ALL the controls of the underlying 'sub-report'. My reports already have a couple of sub-reports (Heading and the Data). Anyway, I'll give it a go (also I do not know in advance how many reports...

Have a look at the SendObject method in the MSAccess Help file. Cheers DS

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...

Have a look at the PrtDevNames property in MSAccess Help. I think you'll find the answer in there somewhere! Not sure myself yet how it works. Good Luck DS

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...