[AccessD] Recordset to a Continuous Form

Jim Dettman jimdettman at earthlink.net
Tue Oct 12 11:59:38 CDT 2004


Vlad,

 I've done this in other languages, but not in Access, but the technique
would be similar. Basically, you'd be duplicating everything that Access
does for a bound form.

  You'd have a form with a series of unbound text boxes to form the rows.
Using the absolute position property, you'd keep track of which row is the
"top" row in your current display.  Initially, you'd paint the rows by
looping through the recordset from that point forward by the number of rows
on your form.

  In the past, I've maintained the current rows in an array, which made
scrolling up/down faster as I would only need to fetch the new record, copy
it to the array, then put the array on the screen.  Rather then moving
elements within the array, I'd simply keep track of which element was first
on the screen. For example, the if there were 15 rows and the user had
scrolled down 5 rows, element 6 would be the top row and element 5 would be
the last row.  I'd paint the screen by going 6 - 15, then 1 - 5.

  Updating was accomplished by having the use scroll a record to the middle
of the screen (it was surrounded by a box to make it stand out), then
pressing "U" for update.  This applied for deletes as well.  I also allowed
the user to page up/down one screen at a time.

  In this way, your in total control of everything.  However with A2K and
up, the ability to bind a recordset in code to a forms recordsource has
really taken away the last excuse for using an unbound form (putting work
into a transaction).

Jim Dettman
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of ACTEBS
Sent: Monday, October 11, 2004 10:17 PM
To: access group
Subject: [AccessD] Recordset to a Continuous Form


Hi people,

Does anyone know of a method to display a DAO recordset within a A2K
continuous unbound form? Also, is it possible to edit the recordset and
save once changes are made?

Any help much appreciated...

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