Search results

@CJ_London The onl6 difference between your suggestion and my attempts, is that I didn’t prefix the statement with Forms! This is because The function received aForm as Form that represent the current opened form. I’ve no way to access my computer for the next10 days. Do you think this could...

@June7, good answer, thank you. I solved quite all, except a little thing. I googled all the day without an answer. Given the following <function x (aForm as Form)> how can I access by name same of the controls belonging to aForm? This is the code Sub setFormats(aForm As Form) Dim TableName...

I need just a little hint to solve the problem: How can I set the conditionalProgramming rules by code?

@CJ_London: your suggestion run, but not with date. But it helped me.

As I cannot attach a conditional formatting on a Table, I need an abstract function to chech if a set of records or all records have errors inside, and show these errors into forms and/or reports. Because, to achieve this goal in the 'standard' mode, I have to define the rule for a field of a...

In a MS-Access 2016 DB VBA, I have the following: 1: A table T 2: an expression containing References to table T fields like the following one > len([Codice Fiscale]) < 16 3: an eval function > eval ("len([Codice Fiscale]) < 16") correctly returning 'Impossible to find the name [Codice...

thank you, both the answers are usefull! Trying to go further, what if I create a module named "Validation" and inside a function named with the name of each table? Like Function Persone( row as Persone) as boolean ' the function shoudl return true or false after checking each column and, if...

Well, this is my first post in this forum. I have a medium complex database, in Access 2019, with more than 100 tables, a lot of relationships and, of course, a large set of forms and reports. Those forms and reports often uses the same fields from the same tables. Just as a sample, I have a...