Streamline collaboration across teams: Add notifications to your Access 2013 web apps

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

Alan Cossey — Sun, 10 Mar 2013 22:11:45 GMT

Looks like my problem has been sorted out with Office 365 Preview. Thanks to those involved.

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

Alan Cossey — Fri, 08 Mar 2013 16:04:30 GMT

I know this is totally the wrong place to post this, but Office 365 in the UK are taking no notice. My Office 365 Preview Access 2013 web databases no longer work and neither do they in Office 365 live. It has been like this for 24 hours now. I thought Office 365 was meant to have 99.9% uptime or something. So far I've had 0% uptime since starting to "use" the live version yesterday.

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

grovelli — Wed, 27 Feb 2013 07:53:28 GMT

"We'll pick the Messages table, and tell it to examine the ID field."

How do you tell Zapier to do that?

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

rw.perkins@ntlworld.com — Fri, 22 Feb 2013 21:18:20 GMT

Hi Alan.

See blogs.office.com/.../get-started-with-access-2013.aspx for advice on which versions allow web apps,

I hadn't looked closely for SendEmail in 2013. Looks like you are correct. Also gone is attachment fields, reports in web databases, SharePoint user groups for easy permissions, and probably more. At first sight it looks like a step backwards. Moving a 2010 web database to a 2013 web app will be a lot of work if like me you used all the functions I mention above. And, the hybrid database, and sync function to publish changes to all the users. We are now back to distributing client front ends to each user.

But, the SQL storage is obviously a step forward, along with the ability to connect to the tables from other software.

Not sure your other questions yet.

Regards,

Roger.

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

Alan Cossey — Fri, 22 Feb 2013 19:38:20 GMT

Roger,

I've been unable to find SendEMail in Access 2013 web databases. It looks like that functionality has been taken away.

Anyone,

On an earlier blog post I asked if it is possible to handle Rich Text in Access 2013 web databases, but I've not seen any replies. It would be good if there is a way.

1st new question

How do you base a view (aka form) on a parameter query, please?

2nd new question

Can anyone please tell me which Office365 plans enable the use of Access 2013 web databases? Access 2013 web databases are excellent and the Access Team has done a superb job with it, but are being let down by the appallingly complicated Office 365 marketing. I currently have an old (2010) Office 365 subscription which will be upgraded to Office 365 (same name, folks) sometime in 2013. So I don't have any idea of when I can start to use Access 2013 on that subscription and thus am looking to transferring to a new subscription. Can I use E1 or so I stick with P2? If I subscribe now to a new P2 will that be Office 365 with Access 2013 web databases or will I be still stuck with Access 2010 web databases only?

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

Weichen.Yang — Fri, 22 Feb 2013 01:06:04 GMT

using microsoft cdo for windows 2000,can do same thing. but not trying in web application.

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

rw.perkins@ntlworld.com — Wed, 20 Feb 2013 17:39:19 GMT

Hi Andrew.

Is this not possible with macros and the SendEmail function? I have used that extensively in my 2010 web database.

Roger

re: Streamline collaboration across teams: Add notifications to your Access 2013 web apps

Andrew Stegmaier — Tue, 19 Feb 2013 21:52:01 GMT

@Jeff - It sounds like you architected a solution were there was an Access desktop database that used VBA to call another program, such as outlook, that sent the email? (feel free to correct me if that's not right).

You can continue to do something similar with an Access 2013 web app. You'd need to have a separate Access Desktop database that connects to the SQL server tables that store the data for the web app. Then, you can use the same VBA code to send the email. The resulting solution would have two components--a web interface that you could use for some functionality, and a desktop database that runs behind the scenes and sends the email.