Kath Pelletti
kp at sdsonline.net
Thu Sep 4 21:33:33 CDT 2008
Your solution is nice and simple but think it is going to get me into all
kinds of problems when I hit names (workplacenames) with strange characters
and apostrophes in them.
And if I use code to handle the apostrophes (replace them etc.) then the
statement won't work.
hhmm..
----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, September 05, 2008 12:01 PM
Subject: Re: [AccessD] Next, Prev
> NextItemID =
> Dlookup("ID","qryMyFormQuery","[Name] > " & [Name])
>
>
> Incidentally, it's very bad practice to use "Name" as a field name - it
> can bite you in all sorts
> of ways.
>
>
> On 5 Sep 2008 at 10:51, Kath Pelletti wrote:
>
>> Must be the week for working on Next, Prev functions on the
>> list............
>>
>> This is a bit of an odd situation, but what I have a continuous form
>> which displays names and ID's. It's source is a query which is sorted by
>> the Name field.
>>
>> In another area of the application, I need to be able to know the ID of
>> the 'next' rec in that continuous form.
>>
>> eg. Continuous form shows:
>> Name ID
>> AAB 90312
>> AAC 23
>> AAD 845
>> AAE 32
>>
>> If I have a form for AAB open, I need to get the ID of the next item AAC,
>> which is 23.
>>
>> Maybe I am making this too hard, but the fact that the list is
>> alphabetically sorted has me thrown...............
>>
>> tia
>> Kath
>>
>> ______________________________________
>> Kath Pelletti
>> Software Design and Solutions Pty Ltd
>> kp at sdsonline.net
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
> --
> Stuart Mclachlan
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>