Sunday, 15 August 2010

In MS Access VBA, what is the function for returning the time of day? (Not date AND time) -


How do I get the time of day in access VBA? I am trying to create a string to name the file in which it has a time value that I do not want the value of day-to-day, but only the time value is now () like the function:

  Current time = now ()  

But I only want the current time.

To obtain the string value that represents the time, use the following example:

  dim current time string current time = as time ()  

to draw the value of time directly from a variable type type:

  Dynamic exampleDateTime as the timetable date time string exampleDetermame = now () timestring = format (exampleDetIim, "MMA M, H: NN: SS AMPM ")  

No comments:

Post a Comment