Tech Support Guy banner
Status
Not open for further replies.
1 - 7 of 7 Posts

· Registered
Joined
·
3 Posts
Discussion Starter · #1 ·
Hey there.
I've got a database, in which there is VB module named "taz", in which there is a function named checktaz(), which returns true or false, depending on the string you send to it.
And i've got his table's field's validation rule (can't spell that sorry), and i want the validation rule to send the entered string to the function, and the function to return true or false, (and the validation rule works once it gets a true or false value).

how do i send the string to the function from the validation rule?

with many many thanks, dor.



p.s - sorry for all the misspellings...
 

· Registered
Joined
·
21,875 Posts
If you do not have a button yet you can add one to the form. Go to the properties for that button and on the event tab use the code builder to set up the event.
 

· Registered
Joined
·
3 Posts
Discussion Starter · #6 ·
Form?

I meant in tables... not forms...
In access, in the design of a field in a table you have a validation rule, you need to input an expression (like >=50.... if you don't want the user to input more than 50)....
now you can also send the string/integer to a function in a module which is on the same database... now how do i do that?
 

· Registered
Joined
·
1 Posts
So you want to run validation at table level? I see what you mean: for whatever reason, Access doesn't allow custom functions here.

Why not force the end user to use a form where you have more control?
 
1 - 7 of 7 Posts
Status
Not open for further replies.
Top