I had this thing working! But I did "something", and now it doesn't work.
A newbie to VBA, but not to programming; I "borrowed" some code I found here & other places on the web. I surprised myself when I got it work!
In cleaning up the code, I must have deleted something because now it doesn't work...
Scenario...I want to read the current Outlook contact record, grab the customer id, and pass it to Access to open the form (record) associated with that customer id.
Alas, I KNOW the Contact record has data in it, but the code is failing as though it doesn't. Second problem, while the database is opening, the form is not. I know that part of my code is sketchy at best, but I had the Outlook portion working! The other thing I don't understand is I put 'MsgBox' stmts in there to try & trap the error, but those didn't work either.
Please point me in the right direction. I don't know enough about VBA to debug it at this point. Also, the attached file is not an editable document; the system it is being developed on has its USB&CD drives (write functions) locked down. The best I can do is print & scan, but I think you'll get the gist of what I'm trying to do.
Thank you,
Karen.