Search results

for JHB: I will describe the situation as clear as I can. I have a Table with 3 columns: Date, Income, Payments. I have a report for every day which show the sum of Payments for that day, the sum of Income for that day, the sum of Payments until that day, the sum of Income until that day and a...

Hello theDBguy. I have such control, problem is that still I need all previous data to calculate. Maybe if I write every day result in a table and use it from there… that could be a solution. I hope however that I can do what I need in a more straightforward way.

I need to view a report between two dates and using parameters in my query does not work because I have a running sum. Ex.: start value=100; total for day1 =30; end of day1 =100+30; total for day2 = 17; end of day2 =130+17; total for day3=2; end of day3=147+2 etc. Obviously, end of day3 is...

First of all, thank you both, NauticalGent and arnelgp. I tried your suggestions even if I had tried them before. As I anticipated, they did not work but they caused me to recreate the troublesome form from scratch and test again the code sent by arnelgp. This time everything went as it should...

I have a report which contains all data within a month, grouped by days. The report is embedded in a form which contain a textbox. I need to be able "scroll" the report to a specific date, which I select/enter in the textbox. I have tried different methods like GoToRecord, FindRecord, SetFilter...

I've added to your reputation but nothing changed on the number of green bubbles. Can I add more? P.S. I've sent an email to you.

Wow! I was reading this: https://msdn.microsoft.com/en-us/library/office/aa172943(v=office.11).aspx and I was beginning to think that maybe I must try Down then Across and, in that very moment, came your answer. So quick and so... correct. Thank you very much. I am not used to ask for help, in...

I've removed confidential data and attached the module in question. If you choose first category from list (which is "c") and then date(1)=14.06.2018 and date(2)=now, it will be evident that 14.06 is ok (8 rows), then report jumps to next page because 15.06 has 40 rows.

Well, I have done that and, after reading your reply, I've done it again in every possible combination. The initial setup was KeepTogether:Yes, ForceNewPage:None, NewRowOrColumn:None. This is giving me the result which I've described. If I change NewRowOrColumn or/and ForceNewPage to...

I have set a report to print across then down some columns whose content come from a subreport. When the number of rows in subreport is under 30 (which is the maximum allowed by the size of the paper), the columns are printing as expected but, when is upper, the column "jump" to the next page...

Thank you arnelgp. Thank you Wayne. Both solutions works. In my case, if I will have to keep text in grouping footer, the only solution is arnelgp's.

Thank you, this is a good idea. The problem is that I don't know how to 'write' a blank row.:confused:

ok, maybe is not clear. I said TEXT in footer. I need to print on a preprinted document so the textboxes must remain in a fixed position in footer section. Problem is that when I add one row in detail section, the TEXT in footer section is automatically moved down with one row. I think is easy...

Hello (again), As shown in title, I have a report with some text in footer, which is moved down when I add rows in detail section. I need help to hold in place the footer text. I don't know, maybe some vba code to compensate the rows in detail section? (I don't think is relevant but I add that...

First of all, thank you, CJ_London, for your time. I was hoping that someone have done what you described. I would like to know if the "absolutely not" answer is an opinion or you did try to use a custom ribbon to restore functionality to access runtime. I am asking because I am half way...

To CJ_London: I've searched trough idMso's of access controls provided by Microsoft and, indeed, it seems that what i need is not included. But, because there are 'only' 1478 of them, I was hoping that I just missed something. So, thank you for telling me that is 'Absolutely not possible'. :) PS...

Thank you CJ_London for your advices. I will try to investigate in depth both of your suggestions. Until then, I need to know for sure if restoring report design/layout functionality with custom ribbon is it possible (or not) in runtime version of ms access.

Hello, Is it possible to move (slightly) some textboxes on a report, to match a preprinted document, if my database run in runtime version? I need to do that from time to time, when the preprinted document is not "perfect". I know that runtime version doesn't have any design capability, so users...