I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
Any ideas?
4  1762 
I don't know of a way to add colors to rows in a datasheet view in
Access. This is doable in a VB.Net datagridview (the .net equivalent of
a subform in datasheet view).
Rich
*** Sent via Developersdex http://www.developersdex.com ***
Two thoughts
1) Use a contionuous form. Can be made to look like a datasheet but allows
formatting
2) As there are presumably an unknown number of dates, you are going to need
an unknown number of colours, so that option is not on.
3) Try experimenting with a line whose visibility is changed by setting it
to False for the same date and True for a different date
Phil
"RussCRM" <sr*********@gm ail.comwrote in message
news:f7******** *************** ***********@f63 g2000hsf.google groups.com...
>I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
Any ideas?
Thanks for the help guys!
Realistically, I would be happy with two shades of gray just to
distinguish between different dates. Like, the most recent date would
be white, the next set of entries with a different date would be gray,
the next set white, etc. Sort of like alternating rows, only that I
want the color to change when it hits a different date. So some kind
of code that would look at a record's date, evaluate if its the same
or different, if it's different, set the row to the alternate color,
go to the next row, evaluate, change if, etc...
Could I do this with the True/False thing you suggested Phil? or is
there another way?
On Jun 18, 8:04 am, "Phil Stanton" <p...@myfamilyn ame.co.ukwrote:
Two thoughts
1) Use a contionuous form. Can be made to look like a datasheet but allows
formatting
2) As there are presumably an unknown number of dates, you are going to need
an unknown number of colours, so that option is not on.
3) Try experimenting with a line whose visibility is changed by setting it
to False for the same date and True for a different date
Phil
"RussCRM" <srusskin...@gm ail.comwrote in message
news:f7******** *************** ***********@f63 g2000hsf.google groups.com...
I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
Any ideas?
Have a look at Stephen Lebans website http://www.lebans.com/conditionalformatting.htm
Think there will be something there to help you
Phil
"RussCRM" <sr*********@gm ail.comwrote in message
news:a3******** *************** ***********@34g 2000hsf.googleg roups.com...
Thanks for the help guys!
Realistically, I would be happy with two shades of gray just to
distinguish between different dates. Like, the most recent date would
be white, the next set of entries with a different date would be gray,
the next set white, etc. Sort of like alternating rows, only that I
want the color to change when it hits a different date. So some kind
of code that would look at a record's date, evaluate if its the same
or different, if it's different, set the row to the alternate color,
go to the next row, evaluate, change if, etc...
Could I do this with the True/False thing you suggested Phil? or is
there another way?
On Jun 18, 8:04 am, "Phil Stanton" <p...@myfamilyn ame.co.ukwrote:
>Two thoughts
1) Use a contionuous form. Can be made to look like a datasheet but
allows
formatting
2) As there are presumably an unknown number of dates, you are going to
need
an unknown number of colours, so that option is not on.
3) Try experimenting with a line whose visibility is changed by setting
it
to False for the same date and True for a different date
Phil
"RussCRM" <srusskin...@gm ail.comwrote in message
news:f7******* *************** ************@f6 3g2000hsf.googl egroups.com...
>I have a subform in datasheet form with the fields Date, Type and Note
(sorted by Date). There are 4-5 records generally per date. Is there
a way to group them visually somehow by date such as alternating
colors/shading per date or a bold line between groups of records of a
particular date.
Any ideas?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bill Elgie |
last post by:
In accessXP is it possible to have single cells a different colour
depending upon their data content. In Ac97 and 2000 you can only
change the whole datasheet(lying on a form) to a different colour
which is pretty useless and a bit 1900's There are various grip type
libraries in VB but just wondering if this feature is now built into
AcXP
Regards Bill
|
by: deko |
last post by:
I have a subform datasheet that contains a full year of records sorted by a
date field. I'm trying to programmatically move the record selector on the
datasheet to the first record that matches a particular date. For example,
the user clicks a button and the record selector moves to the first record
that matches today's date.
I was thinking something like this, but I'm not having any luck:
Dim rst As DAO.Recordset
Set rst =...
|
by: danit58 |
last post by:
Is it possible format the backcolor of rows, depending the value in a field
of the the rekords, in datasheet mode??
Can you help me???
|
by: AgentX |
last post by:
Is it possible, In a datasheet view subform, to change the backgound
color based on the value in a particular field? For example if the
field is Yes/No, have the background color red for No and Green for
Yes?
Any help is greatly appreciated
|
by: sasan3 |
last post by:
when I set visible=false, then entry is not visible in form view, but
still shows up in datasheet view. How do I make a field not to show
based on some condition in datasheet view?
Tx.
| | |
by: jerry.ranch |
last post by:
In sheet view (like a query), is the a way to add color to specific
columns (like some red and some green?) or cells? Not in a form, but
in a sheet view? So say I had a query and I wanted to perform some
conditional formatting (say format all the blanks cells red so the
user could find them and add data to them)
Jerry
|
by: Tom van Stiphout |
last post by:
Hi All,
Access 2003.
I would like to indicate required fields with a special background
color. Easy for parent forms, but I also have several subforms in
datasheet view. For those, I would like to color the vertical column
in the special background color. The Infragistics grid control can do
that for my VB6 applications.
Am I correct in assuming Access can't do this?
|
by: Newbie |
last post by:
I would like to display certain columns from a table on a form.
One of my columns that I want to show is a Yes/No field so that my
users can pick their players for a fantasy football week.
If they could use the table directly, the datasheet view allows them a
check box to set yes and no for the player in that row. However, I
don't want them to access the table directly.
I can't find a contol that will let me use the datasheet view...
|
by: nsbecker |
last post by:
Hi - I've got an interesting one here:
I've got an mdb file that some users run in Access 2003 and some in 2007.
I have a Localize function that is called on the open of each form to set the captions and formatting to match the user's locale. One thing that I commonly do is set the Format property of text boxes that display date/time values to match the user's date/time preferences (i.e. m/d/yy or d/m/yy). It is not always an option for me...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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,...
|
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: 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
| |
