Hi, hope someone can help me with this one...
I want to be able to open an Outlook contact form, linked to names on a client database.
I need this to work whether or not the user has Outlook open, so I'm creating it as a new Outlook application.
Opening it is fine, but when it's closed, if there was already an instance of Outlook open, this gets the focus.
Any code written in Access (eg to SetFocus to the form) doesn't seem to run until I manually return to the database. I've tried using WithEvents in the dim statement for my Outlook application variable and coding for the OnClose event, but this is the same. If I use Quit then the contact form closes itself after about 30 seconds.
Thanks for your help,
Sharon
I want to be able to open an Outlook contact form, linked to names on a client database.
I need this to work whether or not the user has Outlook open, so I'm creating it as a new Outlook application.
Opening it is fine, but when it's closed, if there was already an instance of Outlook open, this gets the focus.
Any code written in Access (eg to SetFocus to the form) doesn't seem to run until I manually return to the database. I've tried using WithEvents in the dim statement for my Outlook application variable and coding for the OnClose event, but this is the same. If I use Quit then the contact form closes itself after about 30 seconds.
Thanks for your help,
Sharon
