trying this out
This is a test posting.
On Tue, 13 Nov 2007 16:06:51 +0800, "hmmmm" <firstname.lastname@example.org> wrote:
>This is a test posting.
Please use microsoft.public.test or microsoft.public.test.here for your
testing. This is a working newsgroup. If you have questions about an Access
database, please post them.
John W. Vinson [MVP]
...conditional formatting #69
What I want to do is
E1 = 1 C1's background is yellow (else white)
E2 = 1 C2's background is yellow (else white)
E30 =1 C30's background is yellow (else white)
I want the CONDITIONAL format to whole of C column
at the moment it looks like you have to do this Conditional format for each
unless I've missed something !!!
You should just be able to enter the formatting into one cell, copy it,
select column C, then paste special -> formats.
"Simon" <Simonx@hotmail.com> wrote in message
>...Conditional format- several conditions and updates when the content changes
Hi there all!
I'm new to vba but is in dire need of a vba macro that not only
supplies me with up to 30 conditional formats, but also "reads" the
result of a formula and changes the cell background color when the
result of the formula changes.
For example, if the simple sum formula =Sum(a1:b1) returned 2 (a1=1
and b1=1) and the conditional formatting made the cell backgrund
green, i would like a macro that can change the backgrund to red if
the sum formula returned 3 (a1=2and b1=1)
Can anyone help me?
I tried the vba code on ozgrid's page, but it only formats the cells
when...I am trying to round up to the nearest 25 cents
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP
In article <2DB8F007-1E27-4A48-923B-C7D4D0238B5E@microsoft.com>,
sypher <email@example.com> wrote:
> I am trying to round a money value to the nearsest 25 cents and it keeps
> rounding to the nearest dollar HELP
"sypher" <firstname.lastname@example.org> wrote in message
> I am trying to round a mone...Trying to clear up Received but not invoiced report
I am trying to clean up the received not invoiced items. The problem
began with entering a purchase order and then not matching the invoice
to the items received agaisnt the purchase order. SO we thought that
doing a returned transaction entery would solve the problem. The only
thing is now the return shows up on our Received/ Not invoiced report.
And the report is becoming a huge mess and difficult to use. What is
the best way to clear up items that have been received but were not
matched and already paid through the invoice entery?
There is a knowledgebase article on this very thing av...send/receive (2nd try)
New computer. Microsoft XP Home. Microsoft Office XP
Small Business 2002. Earthlink dial-up account. Two e-
mail accounts. After opening Outlook, 1st send/receive
(option 3, all accounts) usually prompts for both
passwords, downloads messages, all good. Next time,
though, no prompt for account 2, error cannot connect to
server, account 1 usually gets messages. Every five
minute send/receive option eventually degenerates to
cannot connect to server errors for both accounts.
Meanwhile internet browsing slows to a crawl. Any ideas?
...How do I cancel a msg Outlook keeps trying to send unsuccessfully?
How do I cancel an "in process" email Outlook keeps trying to send
unsuccessfully due to a huge email message I tried to send with way too many
attachments? It's stuck in "send" mode, and as a result, I can't send any
emails because Outlook cannot get past trying to send this message. How do I
cancel a pending outbox transmission while it's trying to send? I've tried
everything I can think of to no avail. Please help!
Angelczech wrote on Fri, 12 March 2010 07:32
> How do I cancel an "in process" email Outlook keeps trying to send
...Restore Internal Web Site
I've been trying for days to restore access to our remote site on port
987 works well) but had no success so far.
The solutions I found at MS describe a manual way to re-create the
internal web site using the folder "C:\Program Files\Windows Small
Business Server\Bin\webapp\InternalWebsite". But this folder does not
exist on our SBS 2008 server. I have remove and reinstalled WSS already,
but it did not solve the problem.
Looking in the IIS Manager the site I see are: SBS Web Applications,
Sharepoint - 80 and Sharepoint Central Administration. But I understand
ther...trying to insert a 0 in front of zipcode
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an sin...Conditional skipping fields
I'm trying to code a data entry form where the user selects an option from a
drop down list and depending on the value the cursor moves to the area
pertaining to this.
e.g. Choosing from animal, vegetable or mineral.
If mineral is selected then the cursor bypasses the animal or vegetable data
entry options and goes to the mineral choices area and proceeds.
I hope this explanation is adequate.
Sub forms in this instance may be a little messy for the operator.
Sounds suspicously like a Spreadsheet converted to Access
You Should split into (at least) three tables animal, vegetabl...error message when trying to install WMP 10 or 11
My operating system is Windows XP Home Edition 2002. I'm trying to download
either WMP 10 or 11 and I get a message saying it was not possible to
complete setup, see webhelp for more assistance, however there is no
additional information when I click Web help. the Error message is 8007F0DA.
Can anyone help me? Thanks.
On Tue, 30 Mar 2010 07:54:01 -0700, Nate
>My operating system is Windows XP Home Edition 2002. I'm trying to download
>either WMP 10 or 11 and I get a message saying it was not possible to
&g...Try or TRY
Will there be any opitmization or ... when we use INT or TRY macros instead
of int or try ? Which one is better to be used?
"JSmith" <email@example.com> wrote in message
> Will there be any opitmization or ... when we use INT or TRY macros
> of int or try ? Which one is better to be used?
Jeff Partch [VC++ MVP]
FYI, TRY ...Conditional Formatting
I need help on conditional Formatting.
I have a column of data with future DATE, such as 2 Jan 09, 4 Des 09, etc
I would like to assign automatically different colors to those data that
match these condition:
If (TODAY's date < Data's date) And more than 30 days, COLOUR is Orange
If (TODAY's date < Data's date) And more than 60 days, COLOUR is Yellow
If (TODAY's date < Data's date) And more than 90 days, COLOUR is Green
If (TODAY's date >= Data's date) And more than 30 days, COLOUR is Red
I would like to gave it AUTO...error message when trying to delete messages in inbox
I cannot delete messages in my email inbox. When
attempting to delete messages, Outlook says "The messaging
interface has returned an unknown error. If the problem
persists, restart Outlook. I continue to get the message
even though I restarted Outlook. My mail works fine, but I
just cannot delete anything. Does someone know a solution?
Can you delete them if you hold shift as you delete? How many items are in
the deleted items folder? Are you using any type of AV scanner on the
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coa...Exchange 5.5 restore with ntbackup
I've got a exchange.bkf file from an online ntbackup.
My priv.edb has become corrupt and IS won't load.
Can I use the .bkf to do a restore, and then start the service?
I try to catalog the .bkf in ntbackup and don't get anywhere.
It hour glasse for a few seconds then nothing.
If I can do a restore of a backup made online to an offline
exchange, what steps do I follow?
Hi, the only way I have been able to get this to work (not saying this is the
only way but for me this worked) was to uninstall or remove Exch from my
server, then reinstall Exch again, and do the restore....Problem trying to export e-mail messages
When I go into Windows Mail and export my messages, the export completes but
then I go and the folders don't match my existing e-mail folders. There are
folders showing which I had deleted months ago. Could it be a corrupt file?
How can I just transfer the e-mail messages I need to a new PC with Windows
Windows Mail uses internal mail folder names that may not correspond
exactly to the folder name in the user interface.
What are you doing with your Windows Mail messages in Windows 7?
Windows Mail was not designed to run on Windows 7.
Gary VanderMole...try/catch vs TRY/CATCH
What is in your opinion the preferred way of doing exception handling
for MFC objects (such as the CFile)... the try/catch mechanism or the
MFC based TRY/CATCH macros?
Use try/catch. I don't recall what TRY/CATCH does but, basically, that was
provided before VC++ had full support fro try/catch.
"Adeel" <dontWantSpam@All> wrote in message
> What is in your opinion the preferred way of doing exception handling for
...Conditional Formatting #14
Is the following possible?
Conditional Formatting limits you to only three conditions. Is there a
way to get more conditions or do the following.
I am trying to create several, say 10 conditions depending upon
"severity" of the result.
Value 10+ would have light yellow background and Bold black type
Value 6 thru 9.99 would have light green background and Bold black
Value 2 thru 5.99 would have light pink background and Bold black type
Value -2 thru 2 would be plain
Value -2.1 thru -5.99 would have light pink background and Bold RED
Value -6 thru -9.99 would have light gr...count occurances of values in column if condition is met
From a cell I need to look down column B and for each time there is
the value =93Ship Effort=94 I need to look in Column E and count the
occurrences of items in range =93SysListName=94 .
For example if SysListName
And Column B =3D
And Column E =3D
The formula would return =932=94
and help will be appreciated
...Run Time error when trying to use DMax on a line value
Please can someone help me with run time error I am getting when I try to use
a DMax function on a LineID control in a subform. I have a main form
frmDeliveries and a subform sfrmDeliveryDetails They are linked on master
and child by a DeliveryID control. On the sfrmDeliveryDetails BeforeUpdate I
Private Sub Form_BeforeInsert(Cancel As Integer)
Me![LineID] = Nz(DMax("[LineID]", "[sfrmDeliveryDetails]"), 0) + 1
End Sub (which I modified from a previous posting)
When I try to enter a selection from a Productscombo on the
sfrmDeliveriesDetails I get a Run Ti...Trying to finish up a worksheet function (if/or??)
Okay, here are the details and the exact data:
A12 thru A17 = Income Source (text, user defined [examples would be Social
Security, Pension, etc.])
B12 thru B17 = Amount Received (will be currency in $dddd.cc format)
C12 thru C17 = Tax Deductible? (currenty have a drop-down list option, YES
A18 = Subtotal (text)
B18 = Subtotal (calculated sum of above columns)
A20 = Choose an Investor (text)
B20 = Investor name (from drop down list)
C20 = Mark up amount (i.e., 125%, would like it to auto fill from the
A22 = Total (text)
B22 = Total (calculated su...Try that critical pack from Microsoft Corporation
Content-Type: multipart/related; boundary="ozwztwhan";
Content-Type: multipart/alternative; boundary="gmqsphxspxalotm"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which fixes
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three new vulnerabilities.
Install now to help protect your computer.
Thi...trying to email with publisher
Can someone please help me configure this thing!!! I can send a regular email
through Windows mail with no problem. I cannot configure Outlook, even though
I am using the same info as I used in windows mail. And, most importantly....
I cannot send a Publisher email in either one!!! What in the worl am I doing
wrong? They won't go directly to windows mail, even though I have it as my
default mail. They continue to go into Outlook even though I have it NOT as
my default. They won't send from Outlook, And when I import them into Windows
mail, they won't send. Arrrggghhhh!
I am...Can I use 'or' in conditional formatting?
I'd like to have 4 conditions, Red, Yellow, and Green. But I have two
conditions for green, without using two conditions for green is there
a way to use OR somehow to beat the limit?
PS Win2000 + XL2002
Sure ... just click on "Formula Is", and you can use "OR" for more then two
Will trigger the set format if "any" of the above equate to "True".
Please keep all corr...What have you tried?
Interesting read, about people who ask questions on forums.
"AliR (VC++ MVP)" <AliR@online.nospam> wrote in message
> Interesting read, about people who ask questions on forums.
Amen, brother. I think it's a syndrome brought on by "no discipline" parents
and a severely flawed public secondary educational system (to be clear, I...