[AccessD] Highligt Row in Continuous Form

Jim Dettman jimdettman at earthlink.net
Fri Oct 17 09:58:07 CDT 2003


John,

  Yes, the bound OLE object control is native to Access.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
Sent: Friday, October 17, 2003 9:07 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Highligt Row in Continuous Form


Jim,

Is the OLE control something built in to Access?  I tend to avoid (like the
plague) having things that have to be registered by my app.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Dettman
Sent: Friday, October 17, 2003 8:51 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Highligt Row in Continuous Form


John,

  Yes, that would work as well, as would storing a bookmark.  Both would be
faster then the function code posted.  The only drawback is that a requery
invalidates positions and bookmarks, but that is not a major obstacle as
long as your aware of it.  The sample MDB I worked up has an example using
bookmarks.

 You might want to take a look at the sample, as I use a slightly different
technique (wish I could claim that I thought of it) to control row colors.
The technique (use of a bound OLE control) not only allows for displaying of
different colors, but graphics as well.  Quite flexible.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Colby
Sent: Thursday, October 16, 2003 9:14 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Highligt Row in Continuous Form


I went in to look at the demo.  It uses an entire function to get the
current line number.  In my framework I use
.RecordsetClone.AbsolutePosition.  Can anyone comment on whether this
replaces the function?

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mitsules, Mark
Sent: Thursday, October 16, 2003 3:59 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Highligt Row in Continuous Form


Changing the Background Color of the Current Record in a Continuous Form
http://www.mvps.org/access/forms/frm0047.htm



Mark


-----Original Message-----
From: Mark A Matte [mailto:markamatte at hotmail.com]
Sent: Thursday, October 16, 2003 3:06 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Highligt Row in Continuous Form


Hello All,

In A97 on a continuous form...I want to highlight or identify the row that
has focus.  Change the color of something...anything...but only on that
record?  Is this possible?  Everything I tried changed the color of every
instance of that control...not just the one on the current record?

Any Ideas?

Thanks,

Mark

_________________________________________________________________
Enjoy MSN 8 patented spam control and more with MSN 8 Dial-up Internet
Service.  Try it FREE for one month!   http://join.msn.com/?page=dept/dialup

_______________________________________________
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


_______________________________________________
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