[AccessD] Seconds Missing

Hi Folks

Success, or so it seems at the moment......I changed the data type in the
SQL table and the variable/functions in the FE to String and set the Gobal
variable  UserLoginTime = Format(Now,"yyyymmdd,hhmmss") ./... (also orders
nicely)

This stores OK in my SQL table (eg 20040720,003047) and I have been able to
subsequently retrieve the correct record using my composite key using Global
variables for UserID and UserLoginTime of the current user.

Thanks all for your help (enough for today - as you can see from the eg
above it's 12:30:47 AM)

Martin


----- Original Message -----
From: "Martin Caro" <mcaro at bigpond.net.au>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, July 19, 2004 9:29 PM
Subject: [AccessD] Seconds Missing


Hi Folks

I have spent some time in the archives and reviewing past date/time issues
looking for a fix for this problem: I grab the user login time using NOW()
and save it to an SQL table however any seconds apparent in Access always
end up as :00 being save in my SQL table. I was using smalldatetime data
type which I changed to datetime but without success. I have played with
Format() a bit but maybe someone knows where my seconds have gone?

Martin

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com