Search results

Allright, so i have to make a new module. Add Public checkbox1 As Boolean Public checkbox2 As Boolean End Module then go to the form, and on the click event of the close button add If Me.chk1 = True Then chk1 = checkbox1 If Me.chk2 = True Then chk2 = checkbox2 .. ? Can't believe i...

They click on a customised button.

Correct. The idea is that the user enters data, then he/she can start the calculations. Then he/she will go to the Report section, open the report.

Im back :), The afterupdate events of the 2 checkboxes have to be Public instead of Private right ?

Yeah i was just thinking about using a variable. Even though i was hoping not to, its been a while since i had to work with them. And to be honest, i forgot half of it. ;) Well, thanks for your quick reply. Ill do some research on how to use those variables.

But the thing is, if i lets say Check checkbox 1. Close form and then open it again. The check in checkbox1 is gone. Dont i have to,somehow save or memorize the value of the 2 checkboxes, in order to actually use it in a later stage?

Good Morning, Ive got a question. I have a form which has 2 values. Value A Value B On that form ive made 2 checkboxes If Checkbox 1 = True Value A.visible = True Else Value A.visible = False If Checkbox 2 = True Value B.visible = True Else Value B.visible = False It works great. But...

Thanks. I dont know why it wont work here. I did find out that VBA gives a compile error, at .Visible... It sais it cant find the method or ..... Any ideas? edit: I found out what the problem was. The name of the textboxes had a misspelled name. :rolleyes: I got it to work now...

Thanks again! But i am sorry to say that nothing happends, even with .visible... :(

Thanks for the quick reply JR, but with Private Sub checkbox1_AfterUpdate() Me.avgd28 = Me.checkbox1 End Sub Private Sub checkbox2_AfterUpdate() Me.avgd7 = Me.checkbox2 End Sub It does not respond to the checkbox at all.

Good Morning (for me anyways :D), Ive got a form which is used to calculate averages. But what i would like to do is to "filter" it by using a checkbox. And the idea is to hide value2 when checkbox1 = True, and to hide value 1 when checkbox2 is true. Now ive tried it with several IF...

First of all, i'd like to say Happy New Year ! Secondly, i'd like to hear your guys' thought on how i could do this. 2-3 weeks ago, ive been making some forumulas to calculate averages. I ended up splitting the form, 1 for entering data and 1 for calculating the totals and everages. There...

Good Morning, Just wanted to keep you updated on this matter. Ive gotten to the point where i can calculate the Sum where monsternr="1" or monsternr="3" by doing the following: Sum13: IIf([querystabilisatieinvoer].[tblwatergehalte].[monsternr]="1" Or...

Hmm getting an error that Monsternr (samplenr) is not part of a statistic function. Which means there might be a error in the selection query right ? SELECT querystabilisatieinvoer.tbllabgegevens.monsternr, querystabilisatieinvoer.*, IIf(tbllabgegevens.monsternr="1",[watergeh],"") AS...

Thanks m8. Ill test it straight away! Cheers!

You can see it as groups. Group 1 = samplenr 1,3 Group 2 = samplenr 4,6 Group 3 = samplenr 7,9 So what i would like to do is get the average of 1,3 and use that value for group 1. etc.. As i mentioned in the reply above, my first thought was to filter the data. And eventually do (...

Sorry for the late reply. OT: Not really . Ive made a screenshot of the form to clear things up a bit. I had to put it in a .zip file though. The idea is, First i calculate the watergehalte (water density), which works fine. In that process every Monsternr/Proefnr (sample nr) will...

Good Morning, I am working on a form which is a continuous form atm. Up to this point things are going allright, but now ive come across something that i am struggling with. First of all, ill show you the query used for this form : SELECT querywatergehalte.tbllabgegevens.monsternr...

Sorry for the late reply. I fixed it by making a 2nd button, and giving it the VBA code IONS mentioned. And it works like a charm. Now i have two buttons, one send it to the printer, and the other one makes a .pdf file. Problem solved! Thanks for all the replies / help. And again, sorry...

Good Afternoon people, I am trying to get a hand of a few things when it comes to Access and VBA. There is just one thing i can not seem to figure out. Ive got a database which is made by a man who is no longer with us, and he made a button which opens a report, gives the printer an order to...