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