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

[Jim Dettman]

Susan,

 You will find the number of people using web apps to be very few and far
between.

 Microsoft has been taking a stab at web apps since 2007.  2010 was a
refinement of 2007.

 2013 was a complete reboot of the whole thing.  Since 2013, I know of
exactly four  developers that have taken a shot at them and that includes
you<g>.

 To my knowledge, there still remains only one web based Access app in the
windows store.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Sunday, May 22, 2016 11:59 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Help with an Access web app -- finding records
without matching related records

Criminy. nevermind..

 

I have no idea why the query I was using wasn't working, now it is.. Timing
I guess. Is anyone else having web app issues like this? I publish it, it
doesn't work. a few minutes later, I publish it again and it does? Just
me???? 

 

Susan H. 

 

 

Setup - I have a small Access web app tracking errata for a technical
publisher. As books are published, I entered a few details. After a few
months, I contact the author asking if we need to publish an errata list. A
web app is perfect because the other authors have access and it was simple
to create. 

 

I have a books table, a contact table, and an author table. (I have others,
but they're not relevant to this discussion.) Books being the primary entity
- and the view displays all book data plus the author's name as a foreign
key value from the author table. The view also displays a list of contacts -
which is often blank. Some books have many contact records; some have none. 

 

I need a view that will display books with no contacts. It's been a long,
long time since I've done any serious Access work and I think I'd have used
a NOT EXISTS subquery to do this in a regular desktop database. Correct? 

 

So if "Susan's Guide To Using Access Web apps" is published but I've not
contacted Susan, I want a quick view that will list her book - not just this
one of course, but all books that I haven't initiated any contact with the
author yet. 

 

I can't seem to do this in a web app - there has to be a way to display
books that have no contacts yet. I hope I'm just making this too hard. 

 

Susan H. 

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