Recent content by Sipozove

I just broke something... :eek: I'll come back to you...

arnelgp, I get this error: "The Expression you entered contains invalid syntax" It works in a form but not in a report.

George, Thank you for your concern. This table is needed because of an operation happening this year. i don't plan to create any table each year. The names of the fields are something I have to change but doing it carefully ;-) I thought about creating a query but I didn't want to do ti "just...

I'm trying to use a report for the first time. I want it to display some statistics. I can do just fine in VBA though a button which output a message. Case1 = Nz(DCount("*", "[tbl2022]", "[Field7] = '" & Replace("AAA", "'", "''") & "' "), 0) Case2 = Nz(DCount("*", "[tbl2022]", "[Field7] = '" &...

I'm reading it. I can relate many things ;-) My biggest struggles are the some function don't work the same way (DAvg!) and I have to tweak it so it works correctly. Then come the way I have to split a whole spreadsheet into many tables with relations. Not the technical aspect but more the...

Thanks! Very good start :-)

Ok, that was fast, simple and solid! Didn't see the expression option :-p Thank you very much.

Hey, I would like to disable a bound textbox in a multiple item form, based on another textbox/field value from the same record. I want to prevent users from entering data in a field/textbox if another field/textbox contains a specific string. The multiple item form is created from a SELECT...

Hello everyone! I consider myself as a MS Excel geek. And since some people tell me that too, it must be true. I have fun with it whenever I need to manipulate data. Then come the two big problems with spreadsheets: multi-users and data protection. I'm sure some of you had some disasters too...