Itemless
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 3 articles for 0.302 sec
Thanks for the reply and the encouragement. I have contiinued to experiment with this. One option is a scorched earth approach to delete records that have no child records. In the form's Unload event: Dim db As DAO.Database Dim strSQL As String strSQL = "DELETE DISTINCTROW tblPO.* FROM tblPO " & _ "LEFT JOIN tblPO_Items " & _ "ON tblPO.ReqID = tblPO_Items     

Group: microsoft.public.access.formscoding · Group Profile · Search for Itemless in microsoft.public.access.formscoding
Author: BruceM
Date: Aug 4, 2008 09:00

Excellent, Bruce. It helps to think out loud, and it's always worth considering the various scenarios. I agree with most of your conclusions too. If you think it is worth chasing up, it's easy enough to use the Unmatched Query Wiz (first dialog when you create a new query) to get any PO that has no line items. If you wish, you could then give that to a user as report for her to fix, or
Show full article (7.10Kb) · Show article thread
suer wrote: > Oh Caroline what a tale! What a shame it went wrong for Oso and you. > Isn't it funny how many people harbour a dream to live in Scotland > (myself included!). And how many cannot cope with it when they try! Seriously I am sure you will be most welcome BUT it really really is a lot harder than it looks and its getting harder every year. IT costs SO much more to do ANYTHING     

Group: microsoft.public.access.formscoding · Group Profile · Search for Itemless in microsoft.public.access.formscoding
Author: Allen Browne
Date: Aug 4, 2008 07:45

Show full article (4.74Kb) · Show article thread
    

Group: uk.rec.equestrian · Group Profile · Search for Itemless in uk.rec.equestrian
Author: Jill
Date: Oct 29, 2007 12:05

Show full article (1.66Kb) · Show article thread