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

DWUTKA at marlow.com DWUTKA at marlow.com
Fri Jun 9 10:32:05 CDT 2006


Have you ever created a class module?  We'll start with the basics, it's not
too difficult.  If not, what version of Access are you using?

Drew

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


Dude
That's like explaining calculus to my cat
What do I know about Classes - Collections? - nothing

You'll have to aim much lower for me I'm afraid

Many thanks
 
Darren
------------------
T: 0424 696 433

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com
Sent: Saturday, 10 June 2006 1:04 AM
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

-- 
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