Problem implementing error logging as per Allen Browne example

  • Thread starter Thread starter Fred Boer
  • Start date Start date
F

Fred Boer

Hello:

Allen Browne discusses error handling at the following link:
http://members.iinet.net.au/~allenbrowne/ser-23a.html

He suggests setting up a table to log error information. I've tried setting
up such a table and am having a problem with the creation of a field to hold
the name of the current user. Allen describes the possible table structure
in a chart. He suggests a text field called "UserName", which has a default
value of "=CurrentUser".

When I try to create a table with this field I get the error message:

Unknown function 'CurrentUser' in validation expression or default value on
'tblLogError.username'

What am I doing wrong, here?

Thanks!
Fred Boer
 
Hi Fred,

You can't set up the field at the table level to use the CurrentUser
function. Just set up the table field as Text with no default value. The
CurrentUser value will be passed to the table by the function.

Hope that helps,
Jeff Conrad
Bend, Oregon
 
Can you use CurrentUser in the Debug window? If not, it could be a
references problem.
 
Dang it! Now I can't even *pretend* that I had tried to understand the code
before using it.. <g>

Thanks a lot!

Fred
 
Oh, I *do* love the newsgroups! As soon as I had corrected the error that
Jeff pointed out... I immediately ran into a references error! <g> It is
working just fine now, thanks!

Fred
 
Hi Fred,

No problem.
The chart does give the impression that you should set up the table field
with a default value so your misunderstanding is justified.

Jeff Conrad
Bend, Oregon
 
Back
Top