Bill Patten
bill_Patten at earthlink.net
Fri Jun 9 11:01:51 CDT 2006
Yea, I'm in for a class on classes. Sign me up. Bill ----- Original Message ----- From: "Max Home" <max at sherman.org.uk> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Friday, June 09, 2006 8:42 AM Subject: Re: [AccessD] A2000: Move to next record - Not Bound 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com