Try this.
Global gfEXE_DB As ADODB.Connection
Global gfConnectString as String
Dim mySQL as String
Dim rs as new ADODB.Recordset
gfConnectString = "Provider=MSDASQL.1;Extended Properties=DSN=Visual FoxPro Database;SourceDB=<enter location of you tables, ex. C:\temp\ . ...
Here is the routine that I use to create a calendar event. For setup purposes, we create both a setup and takedown calendar message.
Sub make_appt()
Dim olApp As Outlook.Application
Dim olappt As Outlook.AppointmentItem
Dim olNameSpace As Outlook.NameSpace
Dim olRecipient As...
Here is some code straight from an application that works. Users have to have rights to the calendar that they write to. Hope this helps. Be sure to include the outlook object module in your project references.
Dim olApp As Outlook.Application
Dim olappt As Outlook.AppointmentItem...
Our Help Desk asked me to give them their hardware checkout application the ability to automatically send appointments to the help desk outlook calendar for hardware setups. This I was able to do, however the delete aborts with a runtime error 91 "Object or with block variable not...
I have been asked by our Help Desk to set up an appointment in their calendar when someone checks out some Hardware and wants it set up. Anyone know how to do this?
Thanks
pburnham@ciwmb.ca.gov
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.