Why no user-defined functions as default values? (error 3388)

[Ed Havelaar]

I have a cool function that I want to use as a default value for a column in
my table. But I can't because apparently Access doesn't allow user defined
functions in expressions for default values. It's very annoying. Is there
any way around it?

What I need is something like AutoNumber, *except* I want the values to be
unique across six different tables. Any ideas?


Unknown function <name> in validation expression or default value on <name>.
(Error 3388)
The function you are referencing is either unknown (because the name is
invalid or misspelled) or is a type of function not allowed by the
ValidationRule or DefaultValue property. Among the types of functions not
allowed are user-defined, SQL aggregate functions.

 

[TC]

Already answered - in detail - elsewhere.

Ed, PLEASE DON'T MULTI-POST. That is where you post the same question
seperately, to several newsgroups. Instead, CROSS-post. That is where you
send the message >once<, to several newsgroups, by including all their names
in the Newsgroups line, seperated by commas (or whatever).

With multi-posting, no-one can see the answers you got, in other groups to
which you posted. So, someone will waste their time by answering a question
that has already been answered in one of the other groups to which you
posted. With cross-posting, readers of >each< newsgroup can see >all< the
answers that you got, in >all< the groups to which you posted.

TC

 

[Duane Hookom]

All your data entry should be done in forms. You can use user function in
default values in form controls.