Search results

Its my post, I suppose you mean 15? Yes but that gives me the same error and I need the sum on main form because I use it for the total sum at the end of the report. Holy moly, I had it working today for passing the value from sub to main and I lost that backup by accident. Now I have the total...

I get the same error However, I figure it out to pass the value through the recordset i set, but then again, at the end of the report I need a Sum of all the textboxes to which I pass the value from subreports and the problem is that it only will read the text box on the current page because...

It works this way when Im refering to one field in the subreport. Now im trying to do something like this: Me.Text111 = Me.[sbrSubRep].[Report]![txtFieldOnSubRep] + Me.[sbrSubRep1].[Report]![txtFieldOnSubRep1] It gives me an error that one of them has no value, whats true but on the next...

Because I'm taking the sum of the first subreport + the sum of the second subreport n so on until 4th in that one text box on the main. Thanks Cronk, I will try it out a little later.

Too much stuff to translate and clean there :( What could I use as an alternative? Now knowing that passing a subreport control to the main report will fail to load in print preview, most probably.

When I put it in report header it loads in print preview, but in details and page footer it doesnt, huh? Edit: I dont know what else to do, guess its better I try to make the report without subreports?

yes txtFieldOnSubRep is name of the textbox in the subreport, "=[Reports]![rptMainRep]![sbrSubRep].[Report]![txtFieldOnSubRep]" this one works in code, however I still get the #Error on print preview. I went report view and yes it finally does show up there without #Error and the actual number...

I just cant figure it out. This is my case in details. On a button click I open a report which shows sth like bills, with filters. Parameters are the Id from form to equal the Id from report query and same for date. Now when the report opens, it shows 4 pages, so 4 records, 4 bills. The report...

Again error :/ Strange because I have another report on which it works with same query and subforms but only with one record, this one has multiple. Might that be the reason? Edit: not subforms, subreports**

On Report_Open Edit: I tried also to put it directly on report design in the text boxs control source but when I go print preview I get #Error =[Reports]![rptMainRep]![sbrSubRep].[Report]![txtFieldOnSubRep]

Im getting an error "You entered an expression that has an invalid reference to the property Form/Report" Main report name: rptMainRep Sub report name: sbrSubRep Me.Text111.ControlSource = [Reports]![rptMainRep]![sbrSubRep].[Report]![txtFieldOnSubRep] The txt box has Sum in it.

I have few subreports on that report, how can I reference to the recordsource of them in VBA? From Report_Open

That makes sense, so to leave the query empty of parameters and then apply on open. What about the speed? And difference when setting as RecordSource an already existing query vs putting a build SQL statement?

So to add the criteria on open report action? But what if the query already has a criteria in it which I dont need for that report? How can I remove that criteria? And I mean remove it, not change it. Because I need criteria on another field. Btw, I edited my previous post

I would like to know when to use these 2 options. For example, right now I have a query (qryQueryName) which is used as a record source for a report , only criteria it has is Id field = to Id field on the form, the report is something like a bill for a customer. Now I need a new report which...

I tired once to use Thunderbird for emailing but the problem I faced was the wait before the "SendKeys "^{ENTER}", True". It works well for few emails but if you are sending many at once but separately it gets problematic. When sending many the opening slows down and then the "SendKeys...

At the end I implemented this Zip files with 7zip Not whole code tho

Alright, I will test it out a bit later. I did try it a little and the code didn't want to create a zip file but I will check later in more details. Edit: now that I think about it probably because my file name had the xml extension, so I need to change it into zip.

I actually want only one flie which I create before the zipping process.

Thanks, I will try I a bit later.