Nextlocation
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 10 articles for 0.303 sec
I tried out the queries, and they seem to work great. Thanks again. "Bob Barrows [MVP]" wrote: > fktx wrote: > > No, it's not possible to have 2 different LocationIDs on the same > > date. We can only occupy 1 location per date, so we are guaranteed to > > have at most one record per date. Hope this helps. Thanks in advance. > > > > OK, try this: > > 1. Create a saved query called NextLocation     

Group: microsoft.public.access.queries · Group Profile · Search for Nextlocation in microsoft.public.access.queries
Author: fktx
Date: Jul 10, 2008 09:54

Thank you for all your help. This looks like it might work, but unfortunately, I no longer have access to the database files. I'll test the queries tomorrow morning and let you know then. FK "Bob Barrows [MVP]" wrote: fktx wrote: No, it's not possible to have 2 different LocationIDs on the same date. We can only occupy 1 location per date, so we are guaranteed to have
Show full article (1.72Kb) · Show article thread
fktx wrote: > No, it's not possible to have 2 different LocationIDs on the same > date. We can only occupy 1 location per date, so we are guaranteed to > have at most one record per date. Hope this helps. Thanks in advance. > OK, try this: 1. Create a saved query called NextLocation with this sql: SELECT s1.StationID, s1.Date_Time, s1.LocationID, (SELECT Top 1 LocationID FROM Stations     

Group: microsoft.public.access.queries · Group Profile · Search for Nextlocation in microsoft.public.access.queries
Author: fktx
Date: Jul 9, 2008 19:31

This is guaranteed spam from unconfirmed opt-in mailing lists for spurious addresses at poopypants.com or other vanity domains. hormboy@fw.merk.com is a USENET spamtrap seed. ---------------------- From jr@jrtr.org Fri Nov 16 12:39:25 2007 Received: from mx0.public.com (mx0.public.com [66.112.160.20]) by public.com (8.12.10/8.12.10) with ESMTP id lAGHdOST096233 for <x@public.com>; Fri
Show full article (1.85Kb) · Show article thread
strNextNum = DMax("ProjID", "Projects", "Left([ProjID],3)=" & [LocnID]) As you had it, your criteria was: "Where 1st 3 characters of ProjID are '[LocnID]'". That is: not equal to the value of LocID, but equal to the name of the field itself. 1) You can't use Functions for the DefaultValue of a table, so you need to put this in the form & handle it during data entry. 2) you might want     

Group: microsoft.public.access.queries · Group Profile · Search for Nextlocation in microsoft.public.access.queries
Author: Bob Barrows [MVP]
Date: Jul 9, 2008 18:28

I am having a terrible time trying to automate some numbering in a subform. The first table is for locations: LocnID LocnName 001 first location 002 second location The location number is not autonumbered. It is incremented using the following in the main form: Function nextLocation() nextLocation = DMax("LocnID", "Locations") + 1 End Function The second table
Show full article (1.53Kb) · Show article thread
In article <aPaVg.13588$7I1.5952@newssvr27.news.prodigy.net>, Edwin <thorne25@juno.com> wrote: > Cindi wrote: > > Below are several color printer listings I saw on eBay. The printers in > > CompUsa selling for $49. What price should I bid? > > > > > > http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=290035542969&ssPageN > > ame=STRK:MESE:IT&ih=019 > > > > http://cgi.ebay.com/ws/eBayISAPI     

Group: news.admin.netabuse.sightings · Group Profile · Search for Nextlocation in news.admin.netabuse.sightings
Author: USENET n.a.n-a.s reports
Date: Nov 16, 2007 10:41

In article <aPaVg.13588$7I1.5952@newssvr27.news.prodigy.net>, Edwin <thorne25@juno.com> wrote: Cindi wrote: Below are several color printer listings I saw on eBay. The printers in CompUsa selling for $49. What price should I bid? http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=290035542969&ssPageN ame=STRK:MESE:IT&ih=019 http://cgi.ebay.com/ws/eBayISAPI
Show full article (4.52Kb)
Cindi wrote: > Below are several color printer listings I saw on eBay. The printers in > CompUsa selling for $49. What price should I bid? > > http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=290035542969&ssPageName=STRK:MESE:IT&ih=019 > http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=290035543295&ssPageName=STRK:MESE:IT&ih=019 > http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd     

Group: microsoft.public.access.formscoding · Group Profile · Search for Nextlocation in microsoft.public.access.formscoding
Author: George Nicholson
Date: Feb 2, 2007 10:49

Cindi wrote: Below are several color printer listings I saw on eBay. The printers in CompUsa selling for $49. What price should I bid? http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=290035542969&ssPageName=STRK:MESE:IT&ih=019 http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=290035543295&ssPageName=STRK:MESE:IT&ih=019 http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd
Show full article (4.18Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Nextlocation in microsoft.public.access.formscoding
Author: Laura
Date: Feb 2, 2007 10:08

Show full article (2.65Kb)
    

Group: comp.graphics.apps.pagemaker · Group Profile · Search for Nextlocation in comp.graphics.apps.pagemaker
Author: Anybody
Date: Oct 5, 2006 13:05

Show full article (1.25Kb) · Show article thread
    

Group: comp.graphics.apps.ulead · Group Profile · Search for Nextlocation in comp.graphics.apps.ulead
Author: Anybody
Date: Oct 5, 2006 13:05

Show full article (1.25Kb) · Show article thread
    

Group: comp.graphics.apps.pagemaker · Group Profile · Search for Nextlocation in comp.graphics.apps.pagemaker
Author: Edwin
Date: Oct 5, 2006 09:56

Show full article (1.01Kb)
    

Group: comp.graphics.apps.ulead · Group Profile · Search for Nextlocation in comp.graphics.apps.ulead
Author: Edwin
Date: Oct 5, 2006 09:56

Show full article (1.01Kb)