Compile Error

[jonamua1971]

Hi All
Thanks in advance for any help i will get.
i have a database that works just fine when it is not splinted.
i have a form where we can send appointments to Outlook Application but when it is splinted its gives a message (compile error- user-defined type not defined)
Private sub cmd addappt-click()
;;
Dim,Obj outlook As Outlook.application
the above statements are highlighted each time we try to set an appointment.
Also the Reference tab is not highlighted to for to see the library references
Thanks

 

[KeithG]

You need to set a reference to the Microsoft Outlook object Library. Or you could use late binding instead of early binding.

 

[jonamua1971]

Thanks Keith for your response
i don't understand what you by late/ early binding.
Remember that the Database works just fine when it is not splitted.
the problem starts when i put it on a network by splitting frontend and backend
Thanks

 

[KeithG]

instead of Dim,Obj outlook As Outlook.application

Use

dim ObjOutlook as object

set objOutloo=CreateObject("Outlook.Application")