Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Using Access to enter Appointments

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GeraldF - 20 Jan 2008 23:43 GMT
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
GeraldF - 22 Jan 2008 07:31 GMT
In article <MPG.21fd7c71bd88da229896f9
@news.microsoft.com>, me@somewhere.com says...

> 1) Why does &amp when used in the onclick event give a
> red line in the VB module:
[quoted text clipped - 3 lines]
>     .Start = Me!ApptDate &amp; " " &amp; Me!ApptTime
>   Endwith

&amp; 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?

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?

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

Wow. Just imagine where I will be in a week!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.