In my program I need the current user name and computer name, Out of the blue I am having computers that fail on my call for the Computer Name. This is the error that it reports
The expression On Open you entered as the event property produced the following error:
The form action was canceled the expression may not result in the name of a macro, the name of a user defined function or event Procedures
There may have been an error evaluating the function, event or macro
Computers on the same network work are running correctly, so I think I can rule out any network related issues. To the best of my knowledge, no MS updates are causing it, even though I suspect it. All the work stations run the same 2003 Access runtime.
The code runs in my office and other computers correctly. I will post the offending code, I have tried 2 different ways to collect the computer name through the function I posted and Environ$("computername") both fail.
The computer names are not long or any odd characters. The one I am dealing with is “Wkstn15”
This code has been working for 4+ years and in the last 6 weeks I am having this problem sporadically. I am at a loss.