neillovell
Programmer
Hi,
I have a timesheet database which, as a front end, has a form which references a query which in turn references a table. The query filters all records from the table whose LogOnName field matches that of the CurrentUser() (I'm using the security features of Access to have people log on).
My company wants the form to be a webpage, so I created a data access page (based on the form) but had problems accessing the data by double clicking on the .htm file. I've found that this is because since I am outside of Access there is no value returned from CurrentUser() when called from my query (users get a log in prompt when accessing the .htm file by double clicking, but this is a standard windows one).
So...
can I set the CurrentUser() to return the logged in user, the name that appears in the log in box when users double click on the .htm file?
If you need me to be clearer please say!
I have a timesheet database which, as a front end, has a form which references a query which in turn references a table. The query filters all records from the table whose LogOnName field matches that of the CurrentUser() (I'm using the security features of Access to have people log on).
My company wants the form to be a webpage, so I created a data access page (based on the form) but had problems accessing the data by double clicking on the .htm file. I've found that this is because since I am outside of Access there is no value returned from CurrentUser() when called from my query (users get a log in prompt when accessing the .htm file by double clicking, but this is a standard windows one).
So...
can I set the CurrentUser() to return the logged in user, the name that appears in the log in box when users double click on the .htm file?
If you need me to be clearer please say!