Search results

I believe you should try to find how to simplify your report (less subreports, less queries). hard to do better suggestions without having an idea about what you've got in your hands. Can you upload something?

Thx for sharing what you've found

This is what I found with a bit of search...

Delete is a reserved keyword in Access and you should not use such words to name your DB objects. For the moment, put it between brackets, but for the long term it is strongly advisable to change the name of your table. Among other thing to avoid when naming objects are spaces (like in Last...

There is a contradiction between DELETE [CHI-TOWN].lastname etc which are fields from the CHI-TOWN Table and FROM Delete which refers to the Delete table. If you actually want to delete fields from records in the CHI-TOWN table (not the Delete table) for which matching records exist in the...

To the best of my knowledge there is no such thing as an orientation parameter for the OpenReport action. if you really want to do that through code you will have to look up code sample for the prtDevMode property in Access Help. But on principle you would just save each of the reports you...

Uneasy to help further without a better idea of what you are doing. Coudl you try to post your DB ? I suspect there may be a better approach to what you are doing like using Dcount, or another query or subreports...

Cookies are stored in a different folder but can be view through the Internet Temporary Files window. There may be other files categories that I do not know of, that are also in this case. Wouldn't it be a solution to set the worksations IE options to perform the deletion of temporary files...

More modules with fewer functions. As you noticed, when you call a func/proc in a global module, the whole module is loaded up in memory. The part of the VBA code you called will then be interpreted and executed. The memory load is linked to the number of lines of code in your module (albeit...

Look up the OpenReport statement in Access help to see how to open a report in print preview mode. Use Docmd.OpenReport ... with the right syntax in sublstitution of the last line (DoCmd.OpenQuery ...) in the above-referred code snippet

That's funny 'cos everblue's suggestion always worked well for me... I am wondering if taking out the repaint or putting it at the end wouldn't help? Also, can you give us an idea about what kind of code is behind the functions you call?

It's been a long time since I last got a right to a Snoopy dance.;) Try: SELECT IIf(InStr([YourFieldName],"AR")<>0, "AR ", IIf(InStr([YourFieldName],"SP")<>0, "SP", "CH")) AS Category, Count([Category]) AS Total FROM YourTableName GROUP BY IIf(InStr([YourFieldName],"AR")<>0, "AR "...

Have a look to these discussions: Customized autonumber Custom PK

Check whether you have opened db or recordset objects that you didn't close properly in your code (ex: Dim db as Database, set db = CurrentDb() ....your code.... Set db = Nothing 'Free up the pointer to your db object)

In the QBE grid, switch to SQL view, copy and paste the SQL statement here so we can see what it looks like :)

Nero, For the same reason underlined by Pat I've also definetly switched to APIs for that purpose. However, I did run into problems while using the regsv32.exe in another context (writing code to autmatically detect and repair broken references on startup). The point is that I cannot find a...

Can you let us have a look to your code?

Have you aken off the original Print menu item fro your custom menu bar?

This does not really sound like an abnormal behaviour. Files that cannot get deleted usually correspond to files in use at the time you try to delete them. This may explain why you sometimes manage to delete all files and sometimes not. Windows won't let you easily act upon files in use and it...

Why don't you eliminate the duplicates from your underlying query if they are of no use to you? (see the unique values and unique records properties of your query and look up DISTCINCT / DISTINCTROWS in access help)