I'm not sure if this is the right place for this, but I'm having an issue I'm trying to solve for a customer, and it's not going well. Searching online I'm seeing this has been a common problem for many people, but there aren't really any solutions that I can find. Here's the problem:
If I create a contact template database and try to save a contact as an Outlook contact, everything works fine. BUT... after splitting the tables into FE and BE, cmdSaveAsOutlookContact no longer runs. Trying to call acCmdSaveAsOutlookContact give a 2046 error, but I can't find how to get around this error. The closest thing I've found to a solution, I'm not sure how to implement since my VB isn't all that great. If anyone has any other suggestions or can assist me on how to implement these steps, I'd be greately appreciative. Here's the steps one forum explains to use:
1) Clear out the local / temp table, with a "docmd.runsql Delete * from
_tmpTblOutlook" or whatever you name the temp / local table.
2) On your button that will run the saveasoutlookcontact, first run an
append query that will append the currently selected contact to the temp /
local table.
3) Then open a small confirm popup that has a command button that says
something like "Export to outlook Now"
4) The recordsource on the confirm popup should be the local / temp table,
where you have ensured that the selected contact's info has already been
appended to the table.