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 & 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
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 & 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