Lebans Highlight Selected Row - Microsoft Access / VBA

Steve K

Firstly, how the heck does this guy do it? Writing reams of (awesome)
code, debugging, responding to Newsgroups etc., all while commanding
the ridiculous price of FREE?!?!?! More power to him!

I'm hoping to use the Highlight Current Row functionality from the
FormatbyCriteri aSubClass database. My problem is that the highlight is
not scrolling. Selection rows works like a charm but the highlight
doesn't move when I scroll.

I am using Access 2003 on an XP machine. I have tried using the
database as is and also converting it to various other versions - no
go. I am prone to breaking things but I get this problem right out of
the box (zip file) without any modifications.

Oh yeah, why on earth has MS not implemented this functionality? Among
the 40,000 other gripes, this is surely one of the more common.

Thanks.

Nov 13 '05 #1

Subscribe Reply

8623

Stephen Lebans

That solution is for Access 97 ONLY and was never intended for A2K or
higher as Conditional Formatting is now directly supported.
See:
http://www.lebans.com/conditionalformatting.htm
New Feb 08,2002. Added support for Datasheet view and SubForms.

A2KConditionalF ormatting.zip is a sample MDB demonstrating how to
programmaticall y setup Conditional Formatting to simulate:

1) Highlighting of the Current Row for a Form in Continuous or Datasheet
View

2) Highlighting of Alternate Rows for a Form in Continuous or Datasheet
View

Version 2.7

Added sample demonstrating how to achieve a background
Hover/Highlighting of rows for a form in Continuous view.

Version 2.3

Added sample demonstrating how to achieve pseudo enable/disable of an
unbound control on a form in Continuous View.

Version 1.9

Added sample form to show how to apply conditional formatting to based
on a Boolean(Yes/No) field.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Steve K" <sk*****@gmail. com> wrote in message
news:11******** **************@ c13g2000cwb.goo glegroups.com.. .

Firstly, how the heck does this guy do it? Writing reams of (awesome)
code, debugging, responding to Newsgroups etc., all while commanding
the ridiculous price of FREE?!?!?! More power to him!

I'm hoping to use the Highlight Current Row functionality from the
FormatbyCriteri aSubClass database. My problem is that the highlight is
not scrolling. Selection rows works like a charm but the highlight
doesn't move when I scroll.

I am using Access 2003 on an XP machine. I have tried using the
database as is and also converting it to various other versions - no
go. I am prone to breaking things but I get this problem right out of
the box (zip file) without any modifications.

Oh yeah, why on earth has MS not implemented this functionality? Among
the 40,000 other gripes, this is surely one of the more common.

Thanks.

Nov 13 '05 #2

Steve K

Thanks! you rock!

Nov 13 '05 #3

Similar topics

5010

how do highlight a specific cell in a winforms .net datagrid?

by: Gerg | last post by:

The datagrid has a tablestyle applied to it, and there are DataGridTextBoxColumn and each DataGridTextBoxColumn has an array of DataGridTextBox objects. Private Sub highlight(ByVal str As String) Dim myTextBoxcolumn As DataGridTextBoxColumn Dim myTextBox As DataGridTextBox 'loop through the cells of the datagrid, searching for the string

.NET Framework

516

Lebans' calendar

by: Mason | last post by:

I have a quick, probably easy, question about Lebans' calendar program. I have a form that allows a user to click on different technicians. When this happens, Lebans' calendar comes up with various dates set to bold based on the technician selected. However, when I close the calendar and select a different technician, the bold dates carry over from the previous technician selected. I can't find a way to clear the bold days after the...

Microsoft Access / VBA

1848

mousewheelhook Stephen Lebans

by: ChrisR | last post by:

Hi Stephen Lebans Thank you very much for your effort and time you have spent writing and helping small hacks like me. I have just one problem with your mousewheelhook. I'm using Access 2002. I have db with an unbounded Main Form with numerous sub forms. The mousewheelhook works find with the subforms in the Main Form. Mousewheelhook is loaded in the Main Form Load event and unloaded in the same form in the unloaded event. The problem...

Microsoft Access / VBA

3058

Will Stephan Lebans answer questions about his Calendar 'control'?

by: DFS | last post by:

If you're listening, I want the middle of the calendar (showing 1 month) to open below the cursor position. It currently opens just to the right and below the cursor position. I hunted through the code, but can't determine what to alter. Very nice piece of work, by the way. Thanks

Microsoft Access / VBA

3051

Listview Highlight

by: Devron Blatchford | last post by:

Hi there, Just wondering if I change the back and fore colour of a listview item when the mouse hovers over it? I want to overide the default windows colour. Can someone please tell me how to do this? Thanks Devron

Visual Basic .NET

2594

Lebans Report to PDF Question

by: Tim Marshall | last post by:

I'm thinking of using Stephen Lebans Report to PDF utility/dll in a Jet application I'm running (I want to be able email some reports with complex information and the conversion to html just doesn't do it very well). I'm wondering what effect or possible conflict there might be on a system, such as mine or a user's, that already have Adobe Acrobat Professional installed. I'm assuming there wouldn't be - that Stephen's procedures would...

Microsoft Access / VBA

1795

Highlight Handle, anyone?

by: Number 11950 - GPEMC! Replace number with 11950 | last post by:

When you highlight a selection of text represented in an object on a form, somewhere in the Framework or alternatively in the Windows API there exists an array of variables that either contain as a string the portion of text before the highlight, in the highlight and after the highlight, or as an integer or long the beginning and length of the highlighted string or other related data. The question is where? TIA

Visual Basic .NET

1488

Steve Lebans Calendar Doesn't Higlight The Correct Dates

by: CuriousOne1 | last post by:

Hi all, I don't know if anyone has come accross this before. I've been using Steve Lebans Calendar control (available here: www.lebans.com/monthcalendar.htm ) for several database application I've built. I only noticed recently, that after I've selected a date range, by highlighting the desired date, e.g. from 1 August 2007 to 7 August 2007, if I then use the navigation buttons to scroll from month to month, the same number of days is...

Microsoft Access / VBA

8832

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9558

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9331

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9253

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8250

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6077

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4879

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2791

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2216

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General