[AccessD] Seconds Missing

Gustav

Global UserLoginTime As Date

In my append query I have a virtual field....  When:getUserLoginTime  that
appends to the linked SQL table field.... fdDateTimeLoggedOn

Function getUserLoginTime() As Variant
    UserLoginTime = Now()
    getUserLoginTime = UserLoginTime
End Function

I have tried As Variant and As Date with the same result.

Martin



----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, July 19, 2004 11:05 PM
Subject: Re: [AccessD] Seconds Missing


> Hi Martin
>
> How have you Dim'ed the global variable and how do you store the value
> of it in the table?
>
> /gustav
>
>
> > Using an append query on an ODBC/Linked table.
>
> > I need to retrieve the record when the user exits using a composite
UserID
> > and LoginInTime key and insert a logoff time however, the value I have
> > stored in a global variable has seconds and the value stored in the
table
> > has been rounded to full minutes so I'm never going to retrieve the
correct
> > record unless the login was actually on the full minute.
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>