Appointment time

F

Frederico Ottoni

Hello there,

I with a problem on creating an appointment through vba. I want to
specify the time of beginning the appointment, but the system just
identify the date, and not the right time (it is create at time 00:00).
I am using somethig like this:

myAppStart = ("#" & Date & " " & appStartTime)
myItem.Start = myAppStart

appStartTime is like 3:25:00 PM#.
And if I use:

myAppStart = #06/17/2005 3:25:00 PM#
myItem.Start = myAppStart

then it works.

Please, someone help me.

Ottoni.

*** Sent via Developersdex http://www.developersdex.com ***
 
M

Michael Bauer

Frederico said:
Hello there,

I with a problem on creating an appointment through vba. I want to
specify the time of beginning the appointment, but the system just
identify the date, and not the right time (it is create at time
00:00). I am using somethig like this:

myAppStart = ("#" & Date & " " & appStartTime)
myItem.Start = myAppStart

appStartTime is like 3:25:00 PM#.
And if I use:

myAppStart = #06/17/2005 3:25:00 PM#
myItem.Start = myAppStart

Hi Frederico,

just type: myAppstart = Date & " " & Time
without '#'
 
Top