[AccessD] MS Access Web Apps Javascript(?) Add-Ins - Was:Re[2]:Access and source control

Mon Jan 25 09:06:06 CST 2016

I think these have potential for developers who can see small problems and
supply a simple add-in solution -- things that are common and that we take
for granted. 

I wrote about these last month. As an example I downloaded one so I include
directions for using the interface -- very simple and the whole point is to
simply let users know the feature is there. But, the add-in I downloaded is
a simple add-in that removes spaces before and after the text -- a simple
task for most of us but one that involves knowing about the TRIM functions,
applying the and possibly even replacing raw data with the results so
existing formulas can use the data. 

Now, even though I know how to do that, why would I put in the extra time
and effort if all I now have to do is click a few buttons in that add-in and
it does it all for me? 

So, I think if developers and power users alike with think of this feature
as ease-of-use and quick solutions rather than customization, they will find
many uses for them. I also see developers using these to create small
inclusive units that they can combine to create more complex solutions --
perhaps --- I'm still not sure about this last part. That might not be
possible. 

Susan H. 

<<What's wrong with throwing the power users  bone? :) >>

  Nothing at all, but there's nothing left for developers there.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Monday, January 25, 2016 09:00 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] MS Access Web Apps Javascript(?) Add-Ins -
Was:Re[2]:Access and source control

I can't address Access web apps but add-in access is not built into the
interface, so I think users will make more use of them -- at least using
them. I don't know if developers will be more inclined to create them. Jim I
compare them to apps for smart phones -- they have a very limited and rather
universal purpose. 

What's wrong with throwing the power users  bone? :) 

Susan H. 

 I'd rather not be so overly negative on them, but they are so limited, you
just cannot do anything meaningful with them expect in a very limited scope.

  Check out this page:

https://msdn.microsoft.com/en-us/library/office/jj250134.aspx

 Which just about fully describes what you have available to you. For a
developer, there's not a lot there to work with.  They have added some newer
features in 2016, such as e-mailing (only within your own domain though),
downloading of data into Excel, and some linking to Power BI, but still your
limited fundamentally by what you can do in the web app.

 Microsoft is simply aiming for the power users and nothing else.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Salakhetdinov Shamil
Sent: Sunday, January 24, 2016 02:18 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS Access Web Apps Javascript(?) Add-Ins - Was:Re[2]:
Access and source control

 Hi Jim --

<<<
They are great for throwing together a basic app that does CRUD operations
>>>
Yes, that was my impression too.
But recently released Office Add-Ins together with Office UI Fabric and
other related technologies seems to be the "game changers" as they are
HTML/CSS/JavaScript -based/-driven and only "the skies are limits" in this
case...

Thank you

-- Shamil

>Sunday, January 24, 2016 12:30 PM -05:00 from "Jim Dettman"
<jimdettman at verizon.net>:
>
>Shamil,
>
><<It looks like using VS 2015 "dumb" MS Access Web Apps can be 
>extended/enhanced by using Office365/SharePoint JavaScript(?) Add-ins 
>by so making them real candidates for modern "web solutions">>
>
> While to a certain extent that's true, I think if you dig into the 
>Access Web Apps, you'll find yourself so restricted you won't find them 
>worth the effort despite the ability to extend them.
>
> There are only a few forms and a handful of controls that you can use, 
>and almost no events to speak of.  They are great for throwing together 
>a basic app that does CRUD operations, but that's about it.  Try to add 
>any real logic and you'll find it quite difficult.
>
> They are focused and intended for use by a power user.
>
>Jim.
>
>-----Original Message-----
>From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
>Of Salakhetdinov Shamil
>Sent: Saturday, January 23, 2016 08:22 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] MS Access Web Apps Javascript(?) Add-Ins - Was:Re[2]:
>Access and source control
>
> Hi Gustav --
>
>Thank your your reply. Yes, I also haven't had any new MS Access apps 
>developed here for 10+ years.
>
>>>> Some ask for ”web solutions”
>It looks like using VS 2015 "dumb" MS Access Web Apps can be 
>extended/enhanced by using Office365/SharePoint JavaScript(?) Add-ins 
>by so making them real candidates for modern "web solutions" - here is 
>a set of the links:
>
>Create add-ins for Access web apps
>From < https://msdn.microsoft.com/en-us/library/office/dn605890.aspx > 
>Office 365: Bind and manipulate data in a SharePoint Access app From < 
>https://code.msdn.microsoft.com/officeapps/Office-365-Bind-and-4876274e
>> Create JavaScript web apps using CORS to access Office 365 APIs From
><
https://msdn.microsoft.com/en-us/office/office365/howto/create-web-apps-usi
>ng-cors-to-access-files-in-office-365>
>See also:
>Set up an add-in catalog on SharePoint
>From < https://msdn.microsoft.com/en-us/library/office/fp123530.aspx > 
>But
I
>must note that I haven't yet made any Add-Ins for MS Access Web Apps - 
>I have tried by I have failed to follow MSDN work-through as my VS2015 
>setup seems to be missing Office Add-Ins templates, and I currently do 
>not know where from to get them installed if that possible at all for 
>VS 2015 Professional edition.
>
>Thank you.
>
>-- Shamil
<<< skipped >>>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com