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

Charlotte Foust cfoust at infostatsystems.com
Fri Jun 9 11:02:00 CDT 2006


The recordset is bound, obviously.  It's the form that is unbound, which
is what the question asked.  I believe I disconnected that recordset but
it's been a long time since I've looked at that demo. 


Charlotte

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

That's not really unbound anymore, now is it?  You are binding the
recordset in memory, instead of 'reading' it and letting it go.

Drew

-----Original Message-----
From: Charlotte Foust [mailto:cfoust at infostatsystems.com]
Sent: Friday, June 09, 2006 10:38 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2000: Move to next record - Not Bound


No, the simplest way (ignoring those useful and clever classes that some
of us adore) is to hold a recordset containing all the records in
memory.  You don't bind the controls at all, you have code to populate
each control when you move forward or back in the recordset.  The
details differ depending on whether you're using DAO or ADO, but that is
the general idea.  I have a NoTables sample database you can download
that uses an unbound form for data entry and edit if you want to take a
look.

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Foust,%20Charlotte



Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Friday, June 09, 2006 6: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