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 9 20310
The answer is pretty much no. But--you can get a form to look exactly
like a Datasheet, and THAT you can color-code.
Hehehe... or, worse comes to wors,e you can always export it to excel
and make it pretty :D
But you can't make editing changes on forms, and have those changes
propagate back to the tables were built on, can you??
Jerry
On 3 Jan 2006 11:19:37 -0800, "KitKat" <ki***********@gmail.com>
wrote: The answer is pretty much no. But--you can get a form to look exactly like a Datasheet, and THAT you can color-code.
o.O
Yeah, forms will update your records in your tables....
If you need help on creating your special form, just ask :D
<je*********@pioneer.com> wrote in message
news:dm********************************@4ax.com... But you can't make editing changes on forms, and have those changes propagate back to the tables were built on, can you?? Jerry
Course you can.
Whole idea in Access is that tables and queries are not seen directly.
The form is the visible bit you see on the screen
David B
If you edit colors or other visual aspects of the data on a form, no,
the changes will not propagate back to the table...if that's what you
were asking. As David B. said, forms usually provide a user interface
for queries and tables. As long as the form is bound to a table, or if
you have VBA code to update a table with the form's values, any changes
you make to the data will go directly to the table.
I will give it a try
I think I now know what to do
Build a form, put conditional formatting on the object(s), then
display in datasheet view.
I took Datapig's course and now I'm an Access jock :) ...I know
enough to be dangerous.
Thanks People
Jerry
On Tue, 3 Jan 2006 19:31:17 -0000, "David B"
<da***@marleycote.nospamfsnet.co.uk> wrote: <je*********@pioneer.com> wrote in message news:dm********************************@4ax.com.. . But you can't make editing changes on forms, and have those changes propagate back to the tables were built on, can you?? Jerry Course you can. Whole idea in Access is that tables and queries are not seen directly. The form is the visible bit you see on the screen David B
Yep I got the form to work..
Now I've got a conditional formatting question..I want all cells of a
data field (onthe form) that are null (no date entered) to be PINK in
the form so the user knows that I need DATA there. Ther eis no "is
null" option in the conditional formatting dialog.I'vebeen able to sue
conditional formatting to do other things in the data sheet, but not
this so far
Jerry If you edit colors or other visual aspects of the data on a form, no, the changes will not propagate back to the table...if that's what you were asking. As David B. said, forms usually provide a user interface for queries and tables. As long as the form is bound to a table, or if you have VBA code to update a table with the form's values, any changes you make to the data will go directly to the table.
Using VBA in the OnLoad event of the form, you could check to see if
the textboxes are null. Keep in mind this is only one way to do it and
I'm sure the other folks here have easier methods.
VBA code:
(for each textbox you wish to check)
If IsNull(txtBox1) Then
txtBox1.BackColor= 'Whatever the color is for your shade of pink. This
is aircode.
Else
txtBox1.BackColor= 'Whatever you want the color to be when data is
there.
End If
If you want to test each textbox on your form, you can use the
Form.Controls collection to iterate through and check them all. The
usefulness of the code above varies with the number of textboxes you're
testing. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Fred Ferreira |
last post by:
Hi there
Does anybody know how I can lock the column widths at Datasheet form view?
|
by: dhowell |
last post by:
Can I have a datasheet form automatically "fit" the column widths when
the form opens?
|
by: Thomas Zimmermann |
last post by:
I have a form with a subform in datasheet view. Now, I want to trigger a
procedure (P1) each time the user selects an entire column (by clicking in
the heading) in the subform. The procedure (P1) I...
|
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...
|
by: MLH |
last post by:
I have a report and on it, a subreport control
Main Report Name: rptInvoiceMain
Sub Report Name: rptInvoiceSubReport
SubReport Control Name: rptInvoiceSubReportCtl
The...
|
by: rfdjr1 |
last post by:
I'm using MS Office 2000. I have a small database using Access which consists of
only two columns. I'd like to add a third column to the right. It would be the
third column. All I can seem to...
|
by: deekay |
last post by:
I want to allow users to resize and reposition columns of a datasheet
but for a prompt to be brought up and only the layout only to be saved
if they select "save changes". This is the way it works...
|
by: ApexData |
last post by:
I have created a SearchForm which is basically a PopUp Continuous Form
that displays 15 Fields. Each field is displayed as a column and when
the user clicks on any record or row, the form closes...
|
by: Deano |
last post by:
I have five subforms each living in a page on a tab control. Each form is
in datasheet view.
The time has come to resize both the forms and the subforms.
I am able to change the column widths...
|
by: scottbouley |
last post by:
I have two columns containing checkboxes in datasheet view on a subform. The check boxes don't require much space but they have to be huge to fit the column heading without abbreviating beyond...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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...
|
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...
|
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,...
| |