Search results

I investigated all the options and the problem is that the report creation (docmd.outputto or docmd.openreport and then printout as PDF with pdfcreator or docmd.sendobject) keeps the reports in the memory. All the rest of the recordsets,... are closed. Now my DB keeps running at 20Mb memory...

i solved the issue to make seperate DB with the mail function. The call this function from the Main DB en after close the seperate DB, this clean the memory after each report. Tried many things the last 3 days and this is the only things what works.

Thanks for the reply, tried it but bad luck :(

tried with pdf creator and no succes,this proofs the reports keep staying in the memory

I added the doevents I changed to subs i commented out the email, speeds ups, commented out int the email sub the docmd.outputto line and speeds ups. commented out also docmd.openreport doesnt change Seems the docmd.outputto uses the memory but don't free it after the job Somebody some tricks...

The code works butt it start to get slow after 15 reports and access use a lot of memory, when the memory goes up to 720 Mb then i get error messages like error 91 I learn a lot of myself with the help of this forum but this one i working last full week on it because the amount of reports...

Every night i create a batch reports and send them with email to people. The first reports go quickly but then memory usage of acces keep growing and then start to get slowly. I Think i close every recorset that i use but still keep getting slow. The reports have a chart inside so maybe thats...

Docmd.setwarnings false will disable them all. Put it in the OnLoad Event of the mainform you open when you start the DB See here more about relationships. It's more important for keeping the data right in your DB (Duplicate Data, Orphan records, ...)...

Some problems with your JOINS, you only had one-to-one JOINS and therefore it only shows records if it has data in other linked tables. I changed qryMainClients and now have more results. You really should set up some relations for your tables PS: If you not want the warnings that you add a...

Can you upload a stripped down version of your DB?

Give a look at the NZ function. This will transfrom null values to 0 (or to the one wich is defined)

Explain more wath your formula have to do. Also to calculate how much day left you need some date wich i not see in formula.

At the end it worked and that's what we need. I'm also not a complicated coder a find a way to get somethings worked with more querys, espicially if i need a Max or one of that kinds one. ;) SQL is not my thing so try to solve with queries ...

Think there is a joining problem then because i have some querys with 3/4 tables and not have any issues about it. How the query reacts when you put yourself the criteria in?

hope this helps, yes its VBA but just want to show you the DateSerial tool i use in my queries where i have to update a date depending on the conditions datum = DLookup("datum", "tabel1") Debug.Print datum endofmonth = DateSerial(Year(datum), Month(datum) + 1, 0) Debug.Print endofmonth...

i use a query with the fields on the form , correct me if i'm wrong but you have a 3 search fields? code i used in the criteria of the query like "*" & formcontrol & "*" if the control is blank then it not apply filter on that column

i use batch files and vba so i can use windows task scheduler to perform task on the times i want Batch: start msaccess "c:\TD GBS\TD - Dienst GBS.accdb" /cmd "30_minuten" VBA: strCommand = Command() If StrComp(strCommand, "30_minuten", vbBinaryCompare) = 0 Then DoCmd.SetWarnings False...

I should go this way, i do it to, so you always are sure it works. If somebody close the file then you don't know. If something go wrog you can add mail to error handling. If have an DB wich FE is used by many people but also one a server for task to update/import/mail reprts at specific times

AND [Me.Text114.Value]='" & Me.Text114.Value & "' " You saying txt114 is txt114. Think this has to be deleted

Txtboxcolum is name if the column(yes/no) where the chkbox is bounded to. In the query you set there criteria for that column true My mistake wrong name choise. Had to be chkbox.