Search results

Hi, I have a report of which record source is a query defined in my Queries. I want to apply apply filter to the query before the command DoCmd.OutputTo acReport, stDocName, acFormatXLS I tried to open the report with the following command before sending the output DoCmd.OpenReport...

Hi No, i have not forgotten. But I could not realize that those problems were related with other. :) By the way, I set up a fresh system and tried what I have done before, and it all worked, even modifying the record source before opening the report. How confusing!!! But I will do as u...

Thx I have done so and it worked. But I have following questions in mind; 1- Does the query used as the record source of report run when I open in design view? 2- Does this way (opening the report temporarily) effect the performance of the application? 3- Might it create a bottleneck at some...

Ok, I will try what you have suggested. But what I really wonder is that, the original code runs well and as I mentioned before, the previous coder also manipulated the record source in the command click event. How can this run then? Or might I have missed some part when examining the code? Thx...

Hi, The below code has comments. And my problems are mentioned there. I will appreciate any comment or solution. Thx. 'This command button is placed on a form and is used to open a report. The report is named as PEOPLE_REPORT. Private Sub SHOW_PEOPLE_REPORT_Click() On Error GoTo...

:confused: Hi, i have been delegated a work. There are one MDB and one MDE file, which had been developed on Office XP. Clients are using the MDE file. On my computer, on which Win2K is runnig with Office XP installed, both original files are functioning right. In the code, the previous...