Using MS Access from Outlook

  • Thread starter Thread starter THH
  • Start date Start date
T

THH

I need to copy data from Outlook to a current field in
Access.

How can I launch Access from within Outlook?
 
-----Original Message-----
I need to copy data from Outlook to a current field in
Access.

How can I launch Access from within Outlook?
Click to expand...
Hi THH,

Are you aware that Access can reference Outlook as a
linked table(s).

You will need to add a reference to the Access Object
library (Tools | References).

Use the following which is copied from online help.

' Include the following in Declarations section of module.
Dim appAccess As Access.Application

Sub DisplayForm()
' Initialize string to database path.
Const strConPathToSamples = "C:\Program " _
& "Files\Microsoft Office\Office\Samples\"

strDB = strConPathToSamples & "Northwind.mdb"
' Create new instance of Microsoft Access.
Set appAccess = _
CreateObject("Access.Application")
' Open database in Microsoft Access window.
appAccess.OpenCurrentDatabase strConPathToSamples
' Open Orders form.
appAccess.DoCmd.OpenForm "Orders"
End Sub

you might like to post further questions on this
particular issue to the Access programming newsgroup.

Luck
Jonathan
 
Back
Top