![]() "Kannancsit" schrieb im Newsbeitrag am using MS Access 2010. To use it in an SQL Statement youĬan create a user define function, for example Public Function getUserName() AS StringĪnd then use SELECT getUserName() AS UserName. Not 100% sure, but It does (and also in earlier version did) not work inside an SQL statement directly. ![]() ![]() You should be able to access all these environment variables with the Environ() method from VBA and from expressions. To check, what the environmentvariable contains open a command prompt and in there enter: Where doesn't it not work? In VBA, in an Expression or in a SQL Statement? Only difference: You have to write Environ("UserName") (" instead of ')
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |