Search results

Thank you, Minty. You were fast. Interesting the link you sent me but, I must say, the runtime switch is ineffective. I am struggling with 2 computers because I did not find a reliable method to test runtime on the same computer on which full access is installed. The last unpleasant surprise...

I need to make a copy of my current database to a certain location that can be changed. For this I use a piece of code that works very well in full access but gives a fatal error when running in runtime. After investigating the case, I came to the conclusion that the error occurs when the...

@CJ London I want you to know that I still analyze your answer even if it does not exactly match my situation. You're right, I've inherited a situation that has made me make things more complex. But I do not claim to have found the best solution. I want to test the code you sent to me and figure...

Hi Mark, Me too I am happy and a little amazed by the result. I would have liked to understand what was going on, but now I'm more concerned about the problem that you and CJ London have raised (sort of). I'm thinking if I can rely on the method of calculating my balance each time I view the...

@Mark Thank you very much! Your suggestion, to do (all) calculation prior the report opening, WORKED! I have deleted all the calculations in the text boxes and used temporary variables to bring the results into the report. Now all results appear instantly, as they should. It was strange to...

@theDBGuy Hi, Most of the calculations are made by queries and a small part is made in the report. To be more precise, what I'm trying to do is a kind of cash flow. My report should show in detail the current day transactions and finally show how much money I have, based on all previous...

UPDATE: I noticed that the delay only appears on Report View (not in Print Preview) and it seems it is related to the display of the results rather than their calculation because when I try to scroll, even just a little, the results disappear and when I stop scrolling they reappear after the...

I have created a report that displays with some delay the results of it's calculated fields. It's about 15-20 seconds delay that I assumed was due to too much computing effort. I thought it was normal because, during this time, simple arithmetic operations were performed with about 20,000...

Uncle Gizmo, thank you for the links. Unfortunately, they did not help me. However, I found some interesting things, especially in the third link. For my part, somehow I managed to solve the problem with the delay by unchecking bi-directional support in the printer driver settings. To my...

I am trying to print a short access report on Epson LX-300+II and I have two problems: 1)the report begins to print with 15 seconds delay 2)I can't choose the font I need, respectively Draft Condensed, because it don't show up in my Text Box Property Sheet After some investigation, I have come...

Well, I'm back with a VERY BIG THANK YOU. It worked perfectly. #Error was due to my regional settings, different than yours. I just formatted the date and fiddled a little with my (a little more complicated) real case scenario and now I am very happy with the result. Thanks a lot.:)

Thank you very much. I will try this first thing in the morning and I’ll be back with the results. I think it might work. Thanks.

Indeed, this is what I want. Maybe the fact that I have #Error instead of rows numbers is due to the fact that in Control Source of my text box is just the word Row. If I understand correctly, I have to add the rest of the expression in order to get the results shown in your image? I’m asking...

Have you changed the image? The first one was correct. And I see that somehow my totals for nrC are lost.

I'm using Access 2016. I was not paying attention to Enable Content button but I restarted your db and there is no warning. Maybe if you can tell me what are you trying to do... There is a function/property named Row in Access 2010? P.S. In your image is exactly what I tried to achieve.

Sorry, I don't understand. I see #Error instead of row number. What do you mean by adding the word Row in Control Source of the Text Box? Thanks.

OK. I have attached a (very) simplified version of my problem. Running Sum is set OverGroup and setting OverAll does not produce the result I expect, which is starting over on new day. Thank you.

Sure. If I press Grouping&Sort button, I see a group on Date then a group on ID. In fact, this report is a copy from another, grouped only on date, where numbering is as I expected. The problem is that I added a new group, the ID group, inside (nested on) the Date group

Hi all, I have a report, grouped by day then by some ID. If I use a textbox with ControlSource=1 and RunningSum OverGroup/OverAll I have the results shown below, different from what I need (restart after each day). Any suggestions ? ex...

to theDBguy: Sure thing, DSum() was my first choice but, if I remember well, I found that is somehow slow even for not so big sets of data (2000 -3000records) Anyway, my report is working very well as it is but what is showing is correct only if it runs from the beginning(day1).:banghead: