How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I have an MS Access database where I assign tasks through

Customer Question

I have an MS Access database where I assign tasks through VBA to Outlook. However I guess the default Outlook mail application on Android/Apple that connects to exchange server doesn't support access created tasks. Any ideas of a workaround to allow mobile users to receive tasks in their calendar using access VBA?
Submitted: 8 months ago.
Category: Programming
Expert:  Bruce Wilner replied 8 months ago.

Sure, how about sending them a text message containing a hyperlink that allows them to download the task in a manner that can be imported into their local schedule?

Customer: replied 8 months ago.
That should work, how do you do that through Access?
Expert:  Bruce Wilner replied 8 months ago.

O.K., let's go over this from the top. What mechanism have you been using (before your Android/iPhone migration) to publish tasks out to your employees?

Customer: replied 8 months ago.
I have an MSAccess database that assigns tasks using VBA to their Calendars in Outlook 2013.
Expert:  Bruce Wilner replied 8 months ago.

Before you migrated to smartphones, what mechanisms were you relying on to publish tasks? I'm implicitly assuming that Office didn't implement a "calendar groupware listener," in the spirit of, say, an ORACLE listener. Can you configure it to send updates by e-mail to a pseudo-address and to have "inbound mail" at that pseudo-address (on whatever target device) result in the execution of a local task, like, download task description file and import into Outlook? This would be a snap on UNIX/Linux because you can achieve it all through sendmail (the ilk, not necessarily the literal product) aliases, no need for special Office shims.

Is any of this making sense?

Customer: replied 8 months ago.
No thanks we have office policies in place we have to use only Microsoft access products on our exchange server. I'm only looking for a VBA Microsoft Access solution.