Search results

I am not sure the problem is the outputTo statement because i had already tested just oppening the report and closing it after that and the problem is the same. I am goint to try to re-install the Add-in anyway.

Ok, now i understand. Thanks. And for the DB, unfortunately i am not sure I can send it you because of confidentially politics with my client i am going to see if i can do something. When i make the test i always check on the Task Manager. It is there when i am monitoring the increasing in...

I am a little confused. If I don't set the record query in desing manually and I don't set it in the Report_Open Event, when it should be setted? I am not sure I am understanding.

I set the recordsource in the Open event because I use this report with two differente queries depends on user request. I made this test changing the Query definitions so I don't have to open the report, just use the OutputTo so I am able to generate more reports but still memory is not...

I didn't mean the report was trying to update the record. The value is asking for is used on the report. Since I set the recordsource in the Report_Open event, I think the report doesn't find this value because the report is already closed whent the OutputTo action is executed. Anyways, this...

vbaInet: I had to leave this problem for a while but finally i get to make the changes you send mi last time. However i couldn't make it work, closing the report before th OutputTo is not working. I suppose the report is not saving the query because is asking for parameter values. I tried...

vbaInet: About changing txtFormulaire, this is a parameter for my report query. It doesn't work if I replace it by a string variable as you suggest me. The report it is not the same every time. Every pass on the loop generates a different report. I can just make a copy and rename. I really...

Setting my report acHidden don't save memory. In fact, the report wasn't visible. I wonder if this is the way Access work that closing the report doesn't free memory. I don't have idea how Access manage memory. I've been searching but i can't find a reference that explain this behavior to know...

VbaInet, Here are the answers: 1. I am opening a form to indicate the user to wait until the exportation finish. It is just a form with a label showed during the process 2. txtNoFormulaire is a textbox in my form which value is used as a parameter to the report query. This parameter indicates...

That is a good point to save memory, but i don't know and i didn't find the way to tell the report what record do i want to print. At least, i couldn't see a parameter in the outputTo function to send it a query. I am using Access 2007 SP2. That's why I am able to use the OutputTo function now...

This is the code that generates the reports, i hope this is more helpful. I haven't write it all because i have the same problem even if i just call the report outside of this function. I mean, just the fact of opening the report and closing it it is making the memory used by Access increase...

I run a query to determine what are the records to generate. Then, for each record to print - I open the report with : Docmd.OpenReport [ReportName],acViewPreview - I export it to PDF: Docmd.Output To acOutputReport [reportname], PDF Format (*.pdf), [FileName] - I close the report...

I have a memory problem generating reports in Access. I have a functionnality which it is going to be run in daily basis by the user to generate the reports for records created on that day automatically and export them to pdf files. This works fine but on a day can be until 250 reports to...

Thanks Wayne for your reply. In fact, I have already tried to requery the recordset but i didn't work. Anyway, I open the recordset after my c# application writes the new value on the table, so I suppose the new value should be there. I think this delay is similar to the situation when you...

I have a program where I am calling an application programmed in C#. When my process finish, it writes a value on a table on my Access database which a want to read. I am using a recordset to get this value on my code VBA. But the problem is that sometimes I am not getting the value updated if...

Concerning the network problems, A user lost communication whit the database due to network problems but it didn't happend again. Besides, I have been experienced slow performace with his network which will make me think that this could have caused the problem. However, i have other users that...

Yes, I have the same probleme in both sub forms. For you suggestion, I just wonder if adding this calculation to the query would have an impact on the execution time of the query. Thanks

These are the calculations First subform three textboxs =Sum([HreTravaille]) =Sum([HreAttente]) =Sum([HreReparation]) HreTravaille is Number (single) HreAttente is Number (single) HreReparation is Number (single) Second subform...

I have two continuous sub-forms with calculated textboxs on the form footer. The formula it is just the sum and product of the values of every record. I haven't had problems until a user complaines it is getting on the textboxes this "#error" message on both sub forms. This happens randomly and...

Thanks jdraw for your tests and answers. I see that the copy of the memo field with the recordset works. But I still wonder if it could be anything else wrong with my program the way I was doing the update or it is really a limitation of Access 2003. As I told you before I made the copy...