Using Access to enter Appointments

  • Thread starter Thread starter GeraldF
  • Start date Start date
G

GeraldF

I am trying to develop a small access form and table to
enter appointments into outlook. I do not at this time
wish to become proficient in Access and Vb programming
so just need a few pointers.

Some of the code I have borrowed from recommendations
posted on line.

I do have several questions.

1) Why does &amp when used in the onclick event give a
red line in the VB module:

Set outappt = outobj.CreateItem(olAppointmentItem)
With outappt
.Start = Me!ApptDate & " " & Me!ApptTime
Endwith

2) Some appointments will be "all day events". When I
select an "All Day event" check box I would like Start
Time (not date), Duration and several other form objects
not to be enabled. This could be accomplished by an
Onchange or OnClick event for the "all day event" check
box, but how do you force the form to reset the objects?

3) How are ApptDate and ApptTime handled for an "all day
event". Should I supply an ApptTime an ApptLength?

Thanks
 
1) Why does &amp when used in the onclick event give a
red line in the VB module:

Set outappt = outobj.CreateItem(olAppointmentItem)
With outappt
.Start = Me!ApptDate & " " & Me!ApptTime
Endwith
Click to expand...

& is old VB code replace with Me!ApptDate &" "& Me!
ApptTime

2) Some appointments will be "all day events". When I
select an "All Day event" check box I would like Start
Time (not date), Duration and several other form objects
not to be enabled. This could be accomplished by an
Onchange or OnClick event for the "all day event" check
box, but how do you force the form to reset the objects?
Click to expand...

Set the desired objects enabled property to false when
the "All day event" object value is true

3) How are ApptDate and ApptTime handled for an "all day
event". Should I supply an ApptTime an ApptLength?
Click to expand...

ApptTime and ApptLength not needed when "All day event"
is true.


Wow. Just imagine where I will be in a week!
 
Back
Top