Form Logging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jen - 11 Aug 2006 17:02 GMT

I have a form I want to open as my first screen. I want to have one command
button on the form that will open my main entry screen. This is easy but my
question is I want a table to track each time that form is open with the
users name and date. I know how to establish this if you add new records but
I have never done it for opening a form with no records...

Thanks in advance...Jen

Reply to this Message

ManningFan - 11 Aug 2006 17:09 GMT

Make a new table called tblLog. In it, put a FormID field, a Username
field and a DateStamp field. Then write to the table the same way you
write to a table when there's data. The only difference is the data
will sit in a seperate table. When you need the data, use a query with
a link to the FormID to know who opened what form at what time.

> I have a form I want to open as my first screen. I want to have one command
> button on the form that will open my main entry screen. This is easy but my
[quoted text clipped - 3 lines]
>
> Thanks in advance...Jen

Reply to this Message

Jen - 11 Aug 2006 17:19 GMT

Did all that but figured it out after I read your answer the problem was the
user/date had to trigger on the "Load" inorder to generate the information.

Thanks Jen

> Make a new table called tblLog. In it, put a FormID field, a Username
> field and a DateStamp field. Then write to the table the same way you
[quoted text clipped - 9 lines]
> >
> > Thanks in advance...Jen

Reply to this Message