[AccessD] Populate field with userid Environ A97 vs A2k+

O'Connor, Patricia (OTDA) Patricia.O'Connor at otda.state.ny.us
Tue Nov 20 11:34:06 CST 2007


I am upgrading an Access97 to Access2k to Access2k3.  I know about
having to create a function to use it in A2k and A2k3 (GRRR)  

I have been using =Environ("UserName") to populate a field (LastUpdtBy)
in a new record in my A97-tables for years.  

I created the function that was recommended and it works in my vb/vba
code portions. It is not working in the table field default.  Gives me
the runtime error # 3388 "unknown function 'Environ'.

Is there a workaround?  If there is one in the archives, please send a
complete link. I have tried finding something suggested in mails but
can't find them easily.

I still think this ban was ridiculous or at least they should have
created a valid totally useable workaround

Thanks -  Have a wonderful Thanksgiving ALL
Patti
**************************************************
* Patricia O'Connor
* Associate Computer Programmer Analyst
* OTDA - BDMA
* (W) mailto:Patricia.O'Connor at otda.state.ny.us
* (w) mailto:aa1160 at nysemail.state.ny.us
************************************************** 
--------------------------------------------------------
This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments.  Please notify the sender immediately by reply e-mail and delete the e-mail from your system.





More information about the AccessD mailing list