[AccessD] Help with an Access web app -- finding records without matching related records

[Mark Simms]

Good responses Jim....and I have a client who is interested in moving to
Office 365 from Office Professional desktop.
I told them: CANNOT DO. They asked "Why not ?"
I said we have over 10,000 lines of VBA code in both MS Access and Excel
2010 to run their Portfolio Management application. This application has the
equivalent functionality of cloud-based solutions that would cost them
$15,000 per month based on their customer asset base !!

Now they are facing the awesome expense of converting the application to
dot-net (see my previous experiences with this).

Or they face the expense of purchasing BOTH Office 2016 Professional
($300/seat) AND Office 365.

What a mess MSFT has made here with dragging their feet on programmability
under Office 365.

See below: for Office 365, they FINALLY provide Javascript programmability
for Excel.
Nada, Zip, Zilch, Zed for MS Access. It'll likely never happen....it will
stay a stupid, macro-driven app.
----------------------------------------------------------------------------
--------------------------------------
Build native solutions in Office
Add-in Commands

Add-in Commands make your add-in more discoverable and efficient to use. You
can create native UI extensions for your Office Add-in in Word, Excel,
PowerPoint and Outlook. Add new buttons to existing Office tabs, create your
own custom tab or extend contextual menus.

> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf
> Of Jim Dettman
> Sent: Monday, May 23, 2016 8:03 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Help with an Access web app -- finding records
> without matching related records
>
>
> Susan,
>
>   While I agree on the simplicity:
>
> A. It hasn't caught on....three years in and your hard pressed to find
> web
> apps anywhere.
>
> B. Reason - too limited.   There's not much you can do with web apps in
> the
> their current form besides basic CRUD.   So yes their great for data
> collection, but that's it.  No printing, reporting, e-mailing only
> within
> your own domain, etc all limit the usefulness of web apps.
>
>  So I would think twice about investing any real time or energy into
> web
> apps as Microsoft doesn't seem to be going anywhere with it based on
> the
> past two releases.  If you have something that fits well, such as doing
> data
> collection, then go for it.
>
>  But many companies are looking for true web based apps and in that
> regard,
> Access Web Apps don't even come close.
>
> Jim.