Thanks guys. ADezii's code is working fine as frmFirstName is a control on the form. It's the specific syntax that always catches me out i.e. when to use single versus double quotes, use of ! versus a . as in the two examples you've shown.
Anyway, it's working a treat and I'm grateful to both of you for taking the time.
Cheers
David
User Profile
Collapse
Profile Sidebar
Collapse
dsajones
Last Activity: Nov 28 '12, 09:24 AM
Joined: Nov 19 '12
Location:
-
Open Outlook Contact from Access
I've managed to find code on the web that allows me to link to a contacts database in an Outlook public folder and I've managed to open a contact using the following line:
Code:Set olContact = MyContacts.Items.Find("[FirstName] = ""Darren""")
Outlook.Contact item
MyContacts contains the name of the folder that these contacts are stored in.
After setting olContact...Last edited by zmbd; Nov 19 '12, 04:30 PM. Reason: [Z{please format code using the <CODE/> button in the toolbar}]
No activity results to display
Show More
Leave a comment: