Using VB, when records are brought up in datasheet view (either a query or
table), is it possible to highlight (or in some way visually flag) certain
records? If so, how is this 'highlighting' accomplished? Note that the
records would most likely not be contiguous. The purpose being to bring
those records to the users attention when required.
Thanks,
Gord
Note that I am using Access 2007 1 2534
You can use Continuous Formatting to format fields that meet certain
conditions.
Alternatively, if you are trying to highlight the fields that are required
or the control that has the focus, see: http://allenbrowne.com/highlight.html
Or, if you want to highlight the text in a field that matched search
criteria, see: http://allenbrowne.com/AppSearchHighlight.html
(The last one applies to A2007 only.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Gord" <x1******@telus .netwrote in message
news:JpwPk.5932 $%%2.269@edtnps 82...
Using VB, when records are brought up in datasheet view (either a query or
table), is it possible to highlight (or in some way visually flag) certain
records? If so, how is this 'highlighting' accomplished? Note that the
records would most likely not be contiguous. The purpose being to bring
those records to the users attention when required.
Thanks,
Gord
Note that I am using Access 2007
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jay Davis |
last post by:
I use xemacs and syntax highlighting for my IDE, but I'm not a big
fan of the default syntax highlighting colors. For instance,
in 'def fun():' both 'def' and 'fun' are the same color. I kind of
like the vim colors, but what would be really useful is to find
various examples of highlighting that people have used, to see
which ones just look right. I looked through google groups but
didn't find any source of highlighting examples. Is...
|
by: Mark |
last post by:
Hi there, I have a subform, set as a continuous form.
When a user selects a particular record in that subform, how can I make that
particular record stand out (color or font change, size, etc) from
the other records in the list?
Thank you in advance,
Mark
|
by: Dave |
last post by:
Hi,
I have a form that displays jobs and the time that is left before the job
runs over.
there is a timer on the form that runs every minute to update the time
remaining for each job
i want to put a check on the timer event that will highlight a job that has
gone over its alloted time
ie
|
by: Matthew Kramer |
last post by:
If I'm at row 10,000 of an Access table with 60,000 lines. Is there
some way I could highlight all the rows from row 10,000 to the end of
the table (row 60,000) in an easy way rather than having to highlight
and scroll down all the lines from 10,000 to 60,000.
In excel, I believe you can do a ctrl-shift-arrow key down and it brings
you to the end of the dataset in a second. Any equivalent in an Access
table?
Thanks.
|
by: matthewemiclea |
last post by:
So I think this may be a stretch, but I have a subform that is
displayed on a main form. The subform is based on a query that brings
records from a table(It does not bring all fields, but the main
identifiers, since there would be too many to be able to display). The
user specifies criteria on the form, which narrows down the number of
records shown in the subform. Underneath the subform, there is another
subform that consists of 25...
| |
by: Bob hotmail.com> |
last post by:
Everyone
I have been spending weeks looking on the web for a good tutorial on how to use regular expressions and other methods to satisfy my craving for learning how to do FAST c-style syntax highlighting in C# but I have yet to find anything useful
I know there are people at MS that know this stuff like the front of their hand and I know there are many people out on the web that are proficient in doing this as well but it seems nobody...
|
by: Arnold |
last post by:
Greetings Gurus,
In a mainform's header, I have a combobox named comboStudents. The
rowsource for this combobox is:
SELECT -999 As StudentID, "<Add New Student>" As FullName, "aaa" As
LastName, "x" As FirstName From qryStudents UNION SELECT StudentID,
FullName, LastName, FirstName FROM qryStudents
ORDER BY LastName;
|
by: rockstar_ |
last post by:
Hello all-
I'm developing a Content Management software for my own site, and
possibly package and deploy to other sites (for friends, family, etc.)
The content management software is combined blog, photo, and site
management tools. One the of the tools I would find INREDIBLY helpful
is the ability to block out and syntax highlight code. I would like to
be able to, as I'm writing a blog post about something I've done in
Python (for...
|
by: Breezwell |
last post by:
I have done some searching on this one and I have yet to find any information that sheds light on what I am trying to do. At lease from what I can understand.
Basically, I have a main form which has a single subform. The subform presents a datasheet view of a a query. The query results present information in such a manner that a single column, call it GroupCode, can have numerous duplicate entries. This is actually desired as a normalized...
|
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,...
|
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...
| |
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
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...
| |