Prev: Re-Name several text boxes
Next: product key for 2007
From: DVoosen on 23 Jun 2008 12:07
Hi,

I'm fairly new to all this. I don't know code. I do everything with
the development screens. With that said, I need to record the user
in a multi-user database in the audit trail record, i.e., who made the
change. There will be a sign in form. Do I need to have both the
computer ID and the User ID in memory? How do I create unique holding
variables? I hope you understand what I am asking for.

Thanks for your help!

Darlene
From: Arvin Meyer [MVP] on 23 Jun 2008 14:51
You can build a form that the user logs in to, then use an OK button to hide
the form. The relevant code would be (untested):

Sub cmdOK_OnClick
Me.Visible = False
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"DVoosen" <DVoosen(a)azblue.com> wrote in message
news:2f83e821-03a8-462c-a589-7f649845eeac(a)a9g2000prl.googlegroups.com...
> Hi,
>
> I'm fairly new to all this. I don't know code. I do everything with
> the development screens. With that said, I need to record the user
> in a multi-user database in the audit trail record, i.e., who made the
> change. There will be a sign in form. Do I need to have both the
> computer ID and the User ID in memory? How do I create unique holding
> variables? I hope you understand what I am asking for.
>
> Thanks for your help!
>
> Darlene


From: DVoosen on 24 Jun 2008 10:58
On Jun 23, 11:51 am, "Arvin Meyer [MVP]" <a...(a)m.com> wrote:
> You can build a form that the user logs in to, then use an OK button to hide
> the form. The relevant code would be (untested):
>
> Sub cmdOK_OnClick
>     Me.Visible = False
> End Sub
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> "DVoosen" <DVoo...(a)azblue.com> wrote in message
>
> news:2f83e821-03a8-462c-a589-7f649845eeac(a)a9g2000prl.googlegroups.com...
>
>
>
> > Hi,
>
> > I'm fairly new to all this.  I don't know code.  I do everything with
> > the development screens.  With that said,  I need to record the user
> > in a multi-user database in the audit trail record, i.e., who made the
> > change.  There will be a sign in form.  Do I need to have both the
> > computer ID and the User ID in memory?  How do I create unique holding
> > variables?  I hope you understand what I am asking for.
>
> > Thanks for your help!
>
> > Darlene- Hide quoted text -
>
> - Show quoted text -

Thanks for your help!

Darlene
 | 
Pages: 1
Prev: Re-Name several text boxes
Next: product key for 2007