Fill Color a Range
I want to fill a range with a color. I know how to do that but I don't
know how to keep the grid lines visible in that range. It seems I would
need a transparent color or something like that.
How can I fill a range with a color that will allow the grid lines to
The only way is to give the gridlines an alternative colour of their own.
(remove nothere from the email address if mailing direct)
"Jack Gillis" <XXXXXXXX@widomaker.com> wrote in message
> I want to fill a range with a ...How to select multi-user ???
For example, peter & john's email account are installed in the same post
office or identity(I don't know how to say in outlook), when I compose new
email, I can select the sender is peter or john in outlook express, but in
outlook, no selection can be provided.
HOW TO DO IT ???
Appreciate for any advice !!!
jj <firstname.lastname@example.org> wrote:
> For example, peter & john's email account are installed in the same
> post office or identity(I don't know how to say in outlook), when I
> compose new email, I can select the sender is peter or john in...Creating Chart from Userform ListBox selections
This is a multi-part message in MIME format.
I have created a Userform with 2 Listboxes on it
Listbox1, is populated with ALL values in Sheet3 Column B
Listbox2, is populated with ALL values in Sheet3.Column A
Column B values are Names
Column A are Dates
Both Listboxes have Multi-Select enabled.
I am trying to set up a chart in Sheet6 with the data from Sheet3, but =
am up to the stage of how to create it.
Sheet3 data is stored in rows, and eac...Formula to count number of days that match, when comparing one date range to another
I am trying to count any matching days when comparing one date range
to another. Any formula suggestions would be appreciated.
Start Date1 Thru Date1 Start Date 2 Thru Date 2 Count Match
3/4/08 4/9/09 3/5/08 3/7/09
formula to show "3"
5/1/08 5/15/08 4/8/08 5/5/08 formula
to show "5"
Not sure how you arrive at a result of 3 for the first group. There are 368
days that overlap.
This formula returns 5 for the second group:
I have 2 printers tied to the RMS computer. One is the Epson T88iii and the
other is an HP Officejet.
When I back order, create a workorder, lay-a-way, etc, I want the print out
full page on the HP.
How do I set this up?
This is a multi-part message in MIME format.
SO Manager | Database | Registers | Receipt Format | select the format =
you're using for your Epson | delete the formats for workorder, layaway, =
etc with the red X
SO Ma...Questions on format of Select statement
SELECT tblCalls.ColTime, tblCalls.colProblem,
tblCalls.colResolution from tblCalls, in dbCallLogs
WHERE tblCalls.colResolution from tblCalls,
in dbCallLogs where tblCalls.ColTime >= #12/1/2006# <= #3/2/2007#
ORDER BY tblCalls.ColTime DESC;
I want to know if this is right? I notice in some queries the table name
before the column name is missing? Also when do you have to put in the
database name? Is it the same in Access as SQL Server? I want the most
recent first. I want those records betweeb 12.1.06 and 3.01.07.
On Wed, 21 Mar 2007 13:30:07 -0700, Janis <Janis...Change 3rd cell colour based on cell 1 >= cell2 in range
Hi all - I have looked through the group for a solution to this
particular problem but i think my inexperience is possibly stopping me
from seeing the solution .. so apologies if it has already been
answered many times previously.
My problem is this :
I have two columns Col1 = Cumulative Sales and Col2 = Cumulative
Target and a range of 1 - 31(signifies the days of the month).
I have applied conditional formatting to all the cells in Col1 so that
as a value is entered into a cell in Col1 the cell turns green if the
value is >= to the corresponding cell in Col2, and red if < than the
c...selecting email account when sending a new email
I have 3 email accounts in Outlook 2003 that I send and receive emails from.
I used to be able to change the email account in which to Send a new email
from; but that feature disappeared at some point. I checked the support page
and tried to find instructions on how to set up Outlook 2003 to allow you to
be able to select a different email address to send an email from rather than
always sending emails from the main, default email address. The instructions
said to click on "Accounts" in a new email. I do not have that option
anywhere in a new email message and I do not ...Checking ALL values in a range
I'm trying to create a formula which checks that a range of cells e.g. A2:F2
contain all the values 1,2,3,4,5,6 irrespective of which cell each number is
Unfortunately, everything I've tried has failed so any help would be
One way, though not scaleable:
"nospaminlich" <email@example.com> wrote in message
news:F971FD92-38F...Return cell content in a matched range
I need help with the following formula:
This formula works well for Sum total for all matches however I need to use
it to return a word instead of a SUM .
Example: Column D contains the folowing payment methods. ATM, Check, Draft
I want to use the formula to find the match of A1 in the range F8-F100 and
return what payment method was used located in Column D on the matched row.
As you can tell it i...Returning a named range source reference
I am using the code below, trying to create a list of named ranges and their
source references. I'm having two problems.
(1) There are some other names (named objects) in the workbook, and I don't
want to return those; I just want to return named ranges, and
(2) The code below returns the resulting range referred to, but not the
source reference. For example, if the named range is "=offset(A1,1,1)" then I
need to see that offset statement, not the resulting range of "B2". I tried
everything that made sense from the help object model und...Named-range source-data for pie charts on copied worksheets
I have to finally concede that I'm stuck and have to ask for advice. I
am using Excel 2000 and have been able to use Andy Pope's help on
"Automatic removal of zero values in pie chart". That works fine. But
if I copy the worksheet, the pie chart on the copied (new) worksheet
references the named range as defined on the original worksheet.
My named ranges, which the pie chart references, are:
So, one solution might be to define the same named range on dif...How do you implement selectable alternative DLLs?
I've got a need to allow my application to use a differrent version of a data
access DLL based on a user's selection, or automatically discovered
difference. In particular, I have an application that I want the user to be
able to select the type of data source (Oraqcle, MSSQL, XML, Web Service,
etc) and the application will use the applicable DLL from among the multiple
DLLs provided with minimal coding.
Ideally, I would have a DLL for each of the data sources supported and would
just select one at startup and the code would remain the same for all calls
regardless of...Update Status field by record selection
Table 1 Name: Bank
Table 2 Name: Ledger
1 Main form with 4 subforms (only having problem with 2 subforms)
1st Subform: UnMatch1 (query based on Ledger)
2nd Subform: UnMatch2 (query based on Bank)
Once my users verfied information from both subforms, they will decide if
those items match (by record) on the Status field.
I need to have a CmdMatch which can allow users to select particular record
and make update the Status to Match or UnMatch.
I did some research all day but only one that's close enough to what I wanted
is the following code:
Private Sub CmdMatch_Click()
Dim rs As...Require value
Using a tabbed subform - the code below works perfect to validate one field
and force a required value for a second field IF the users tabs through the
fields. However, I'm not sure how to compile the code that gives the user
the option of tabbing or manually selecting each field.
Private Sub ALARM_Q2_REM_Exit(Cancel As Integer)
'if the alarm rate <3 and the rem doesn't have a value then pop a message
'and force the user to stay in the control until it has a value
If (Me.ALARM_Q2_RATE.Value) > 0 And (Me.ALARM_Q2_RATE.Value) < 3 And _
Nz(Me.ALARM_Q2_REM.Va...access compare values and select higher of two
In Access database I want to compare the values in two fields in a form and
then select the higher value, insert it into another field and then use in a
E.g. Value 1 = 500 Value 2 = 600, 600 to be inserted into another field
and then be multiplied.
On 11 apr, 21:26, Captain Turtle <Captain
> In Access database I want to compare the values in two fields in a form a=
> then select the higher value, insert it into another field and then use i=
> E.g. Value 1 =3D 500 =A0 Value 2 =3D 60...changing CRichEditView color without changing the selection?
I'm trying to change the color of a portion of text inside a CRichEditView
control. The only way that i know of to do this is to highlight the text and
then set the character formatting to change the color.
Just wondering if there is a way to avoid highlighting the text and yet be
able to colorize it?
"MrPolite" <kderakhshanAtMSN@msn.com> wrote in message
> I'm trying to change the color of a portion of text inside a CRichEditView
> control. T...Code to look at range and extract data.
If the column of data has the text "Back On" I want to copy the adjacent
columns to another sheet for each instance. This will be a loop since this
text occurs more than once.
If I understand you correct ?
Regards Ron de Bruin
"JDJacobs" <JDJacobs@discussions.microsoft.com> wrote in message news:5B3B0D6A-CE19-426B-BBB6-F68B9AD6C2DB@microsoft.com...
> If the column of data has the text "Back On" I want to copy the adjacent
> columns to a...Counting time ranges
I have a spreadsheet that looks like this...
I need to be able to count how many times each hour shows up, I tried using count if but the range isnt working?
maybe something like
to count the numer of 9 hour occurences
>I have a spreadsheet that looks like this....
>09:...How To Select Multiple Transactions At One Time
I would like to delete a block of transactions from an account in Money 2007
Plus Deluxe. Is there away to select multiple transactions and then delete
all of them or must I do each one, "one-at-a-time" ?
In microsoft.public.money, Snoopy328 wrote:
>I would like to delete a block of transactions from an account in Money 2007
>Plus Deluxe. Is there away to select multiple transactions and then delete
>all of them or must I do each one, "one-at-a-time" ?
You could get some kind of keyboard macro if you are doing really a
lot of these. Otherwise, c...Refer to a named range
I am having trouble using a named range in a macro, even after refering the
The named range lives in the active workbook on another sheet.
My code is this:
Private Sub Worksheet_Activate()
Set c = .Find(Range("A1"))
If Not c Is Nothing Then A = Sheets("Names").Cells(c.Row, 3)
If ActiveSheet.Name <> A Then ActiveSheet.Name = A
You will see that I have had to resort to using [ ] around the named range,
which is the only way I could get the code to run.
I tried Range("...Totalling records in a date range
I have a report that shows sums of various fields, grouped by date. If i run
my report based on specific dates for example between 1/1/2008 and 1/5/2008,
each date is displayed as a page in the report. i am looking to run my
report so all my fields are totalled based on the dates selected, without
displaying each individual day. I was able to add a field that totals all my
fields in the date range, but it doesn't give me the specific totals of each
field I am looking for. As always any help is greatly appreciated.
Do not include the dates in the query but the date r...Multi-Select List Box Does Not Retain Selected Items
I created an Outlook Form in 2003. But when I select
items in the list box they do not remain select when I
select another control on the form.
Did you bind the list box to a keywords field?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"kaykay" <firstname.lastname@example.org> wrote in message
> I created an Outlook Form in 2003. But when I select
> items i...Auto populate form field based on selection
I have a form which is linked to a table(tblAntibody) for data entry.
I have another table(tblCatalogPartNumbers) with no relationship to
the first which contains all of our codes and has four coulmns
CatalogNumber, UnqualifiedNumber,NIPartNumber, and PIPartNumber. All
of these columns store thier data in tblAntibody.
On the form CatalogNumber is a combo box that has it's selection
criterial set to tblListCatalogPartNumbers. What I need to happen is
when a user selects a catalog number from the combo box, I need the
other 3 fields to auto populate from tblCatalogPartNumbers.
Catalo...paste over a filtered range
I have a spreadsheet with 40000 records, I have filtered down to 1000 records
that have one coloumn of incorrect information that needs replacing, how do I
paste the new data over the old?? What keeps happening is the new data
pastes over the first 1000 records, not only the filtered recorsds
When you have your filter in place and the 1000 records are showing, hit
F5>Special>Visible cell only and OK.
Now paste your replacement data.
Gord Dibben Excel MVP
On Tue, 26 Apr 2005 15:36:02 -0700, "freddie2711"