[AccessD] A2000: Move to next record - Not Bound

Max Home max at sherman.org.uk
Fri Jun 9 10:42:53 CDT 2006


Go for it Drew, let's have a tutorial that we can all follow along, and for
those of us who have never left tables,  we can all learn

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com
Sent: 09 June 2006 16:04
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2000: Move to next record - Not Bound

First of all, congratulations! ;)

Second, unless I am dealing with a huge recordset, I prefer to create a
record 'class', one with a property for each field.  I then load the
recordset (when the form loads), and set a collection behind the form,
containing all of the records.  Then you can add 'navigation' buttons which
simply load the next or previous record.

Drew

-----Original Message-----
From: Darren DICK [mailto:darrend at nimble.com.au]
Sent: Friday, June 09, 2006 8:17 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2000: Move to next record - Not Bound


Hi all
I am going to try an unbound experiment (I know I know) - all the Unbounders
-
back in yer seats
 
So...What's the syntax for not binding a form to a table or query
 
I assume you find the first record in the table you want to display and bind
the
form to one record at a time?
(So it's not true unbound - I agree but...)
 
How do you move to the next or previous records?
Using something like... 
select * from Accounts where AccountID = me.txtAccountID + 1 
won't successfully navigate me forward or back - I need to 'ignore' deleted
records etc
 
So what's the general consensus for navigating forward and back through
single
records at a time?
 
many thanks in advance
 
Darren
 
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list