SRS Report not displaying timesheet in correct format
Hope someone can help on this issue:
This report creates a matrix of timesheet information for all
resources under a single Timesheet Manager. The number of columns is
determined by the number of open timesheet periods, and the order of
periods is intended to be descending by start date, but that's the
problem. Although the query returns data in the correct order, the
SRS report matrix does not.
Our open periods are 2/15/10 to 3/22/10, and the query returns them in
Period Name Work Start Date End Date Project Name Resource Name
2010 Week 12 39.25 3/22/2010 3/28...Conditional formating of Charts
I have a scatter chart and need to conditionally format points and
associated labels for each point. The condition is not related to the data
series to which the chart is linked.
Let me know if there is any specific VBA code for doing the same. You can
reach me at firstname.lastname@example.org
There are some non-VBA suggestions here:
To change some points of a series or some series in a chart based on a known
criterion, you can adapt one of the macros in this post:
http://www.google.com/groups?selm=3F4B8D49.3080508%40yah...How to replicate Excels' numeric "Accounting" format in Access Rep
How to replicate Excels' numeric "Accounting" format in Access Report
client want's Access report to output values in format identical to Excel's
numeric "Accounting" format
if I try to difine it as such it converts the 'Format' definition to >>
and strangely dosen't give the desired result
I'm using Office 2003 on Windows 2000
Have you tried Currency with 2 decimal places?
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom...my file in Word '03 was converted. need 2 convert from mswrd632
my file in Word '03 was converted. need 2 convert from mswrd632. Need help?
I cannot get my original file because of mswrd632, whatever that means.
Go to http://support.microsoft.com/kb/973904/en-us and press the FixIt
Terry Farrell - MSWord MVP
"A problem with mswrd632" <A problem with
email@example.com> wrote in message
> my file in Word '03 was converted. need 2 convert from mswrd632. Need
> I cannot get my original file because of mswrd632...Subsequent pages having top/center formatting.
Hi, I have a simple question. I have a large listing of information across
cells that takes up multiple pages. However, whenever I want to print, I
find on the last page that I have the last cells on my project centered
directly in the middle of a page. Is there any way for me to change it so
that it will be positioned towards the top of the page ala my first couple
pages? Thank you very much for any and all help.
> Hi, I have a simple question. I have a large listing of information across
> cells that takes up multiple pages. However, whenever I want to print, ...Conditional formatting: adding extra conditions
The Conditional Format in Excel only allows you to enter 3
conditions, therefore ending in 3 different formats
Is there a way to increase this to 6 or more conditions?
Thanks a lot
Apart from conditional formats you do have ability to control formats
for negatives, positives, zero and text.
But generally you'd go for VBA to apply more than three formats.
Norman Harker MVP (Excel)
Holidays and Observances Friday 18th July: Mexico (Day of Mourning
death of Benito Juarez), Spain (Labor Day), Uruguay (Constitution Day...Ranges within Conditional Formatting
Within a cell, thisis basically what I want to do but am having trouble:
if the value is between 95-100 background = green
else if value is between (90-95) or between (100-105) background = yellow
else if value is <90 OR >105) background = red
> Within a cell, thisis basically what I want to do but am having
> trouble: if the value is between 95-100 background = green
> else if value is between (90-95) or between (100-105) background
> = yellow else if value is <90 OR >105) background = red
> Any ideas?
If you...Ex07 Hell
2 HT servers in different AD sites, both. When they try to send to
each other, the queue manager gives this message. Both EX07, I can
ping and telnet on 25 to each from each and create messages from with
SMTP commands. Delivery to each other is not working.
SMTP Relay to Remote Active Directory Site
Primary Target IP address responded with "451 5.7.3 Cannot achieve
Exchange Server authentication."
On Mar 30, 3:37 pm, ryanlsand...@gmail.com wrote:
> 2 HT servers in different AD sites, both. When they try to send to
> each other, the queue manager gives thi...Incoming email formats
I've got a small problem. I have several rules in my outlook to process
incoming emails. My incoming emails are in HTML format.
I've noticed when I get the emails, the outlook rule doesn't work. The email
sits in Inbox. Since in my rules I am looking for
certain words, it seems like Outlook is not smart enough to scan the body of
If I send myself a test email in ASCII from my gmail account and place those
certain words in the body of the message,
outlook process that incoming emails.
Also if I edit the incoming email messages and save them and re-run m...Format for text field
Hi- I have a text field, the format of this field is ##.## (ex: 09.10)
How can I check this field if it have a value then it must be in a format
like above? (null is OK)
Thank for any replpy.
>>How can I check this field if it have a value then it must be in a format
like above? (null is OK)
Null is not a value.
Are you wanting to check for a numerical value or that the text is formated?
Build a little, test a little.
> Hi- I have a text field, the format of this field is ##.## (ex: 09.10)
> How can I check this field if it have a va...excel help 03-08-10
I need help to write this function. In my table I have one column A1:A100,
in each row it could have one text, could be "B" or "P", I want to compare
from A1 down to A100 if "B" is more than "P" by one then stop the comparation
and display a "W" in next column at the row.
Is this what you want:
"Hung" <Hung@discussions.microsoft.com> wrote in message
news:2F1921A4-4729-4D4A-8521-4...Deleting conditional formatting
I am unable to delete the conditional formatting on a
range of cells probably due to some cutting/pasteing.
The conditional format in greyed out in format menu. Any
help is greatly appreciated.
You probably have sheet protection turned on.
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"okiebound" <firstname.lastname@example.org> wrote in message news:008601c47a23$a...e-mail 03-03-08
I'm having trouble sending slides in my e-mail. where can I get instructions?
On Mon, 3 Mar 2008 15:45:21 -0500, "vera" <email@example.com> wrote:
>I'm having trouble sending slides in my e-mail. where can I get instructions?
Well, not in a Microsoft Access(TM) database forum, which is where you're
Please scroll down the list of subject areas and post in a newsgroup
supporting your EMail software.
John W. Vinson [MVP]
hi am lost here i want to format my pie chart data series but i can't seem to
get it how is it done on excel 2003
Try right-clicking* on the pie chart > Format data series
*point your cursor anywhere inside the pie
Then tinker with the settings say in, the Data Labels tab
Downloads:20,500 Files:363 Subscribers:64
> hi am lost here i want to format my pie chart data series but i can't seem to
> get it how is it done on excel 2003
Everything worked except I did not get my
email accounts, and that is ok with me but I am having problems with:
1) How do I rid of one of the Outlook Today
2) I cannot get my contacts to show when I click to TO when emailing. I see
it in my address book.
This is the same thing that happened in my Outlook 02 and I cannot remember
what stuff you guys told me to do, please help.
Did I hurt my Outlook 2003 by copying those files if I did what should I do
to make it work the correct way.
Thank you so much in helping me if you can
I did a clean install of Outlook 03
I copied from Outlook 02 em...Prep for Ex07 to join Ex03 in Child Domain
AD Root domain is place holder only, All Ex03 is in a child domain.
Are these the correct steps to prepare AD for Ex07?
/PrepareLegacyExchangePermissions: ExchangeDomain (FQDN)
/PrepareSchema has to be run from root domain
/PrepareAD run this from the child Exchange Domain
/PrepareDomain: Exchange Domain (FQDN)
Enterprise Admins + Schema Admins
Same site and same domain as the Schema Master DC
Enterprise Admi...How do I apply Conditional Formatting to a range?
I can apply Conditional Formatting to a single cell, e.g. E13, but how
do I apply the same CF to a range of cells, e.g. B13:E15, i.e. the CF
of all cells in the range is dependent on the condition being met in a
single specified cell in the range?
Select the whole range and apply the Conditional Formatting formula all at once.
If you always want to use A1 somewhere in your formula, make sure you enter that
address using $a$1. Just like a regular formula that's copied elsewhere, cells
with absolute addresses won't change.
> I can apply Conditional Formatting t...Missing Tools Menu Item
Home Use Program installed Office Pro 2003 and is missing
the Tools menu item to restore deleted items. Anyone
experience this or know what to do?
This option only exists when you are connected to an Exchange server
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Pam B." <firstname.lastname@example.org> wrote in message
> Home Use Program installed Office Pro 2003 and is missing
> the To...Conditional Formatting
I want to color a cell based on the value of that cell being greater than
zero and another cell not being equal to "x".
I've used conditional formatting with "formula is" and formula -
This does not seem to work - what am I doing wrong??????
Use AND for multiple criteria to be satisfied, like this ..
Assume you want to apply CF to col A
Select col A, apply CF using Formula is: =AND(A1>0,B1<>"X")
Format as desired>OK out
Success? hit the YES below
"Pat999"...displaying international format phone numbers
OL 2002 SP3
Win XP HE
Follow-up to: microsoft.public.outlook.contacts
I have a folder with hundreds of contacts.
All telephone numbers display as +12129999999
I would like to have them all display as +1 (212) 999-9999
It does automatically change to that if I manually open the contact and
click on the little pencil icon to the right of the phone number field.
However, I can't really do this manually for hundred's of contacts.
How can I automate this?
Thanks a lot.
...windows update error message 03-03-10
For the last week or so I've been getting the message
"The website has encountered a problem and cannot display the page you are
trying to view. The options provided below might help you solve the problem. "
I have 4 computers on a router using the firewall in the router, no other
firewalls running and using AVG version 9.0 for all 4 PCs, which are all
running XP SP3.
The message is displayed from all the computers.
Nothing was changed-- no settings on the firewall or on the PCs.
You receive a "Windows Update has encountered an error and ca...Formatting
I am working in Microcsoft Publisher.I have typed in text and then inserted a picture. How do I get the text to wrap around the picture. When working in Word I could just insert a picture and the text could be wrapped around it. In publisher the text is confined to a text box. Whatever I seem to do the picture remains the same only the size of the text box alters and text will not wrap aound the picture.I have tried using edit points but have got in a real mudle
I am desperate now. Any help please?
What version Publisher?
Are you sending the image to the front? Click the dog icon, (picture t...Outlook '03 start error
I am getting a "fatal execution engine error (0x7927baca)
cordbg.exe 1a0xc68 AND cannot find JIT denugger when
trying to repair. Thank you in advance for your help.
Remove 'goduke', if not spam
"sean" <email@example.com> wrote in message
> Please help
> I am getting a "fatal execution engine error (0x7927baca)
> cordbg.exe 1a0xc68 AND cannot find JIT denugger when
> tryi...love 03-03-08
I love you
"eugene lin" <firstname.lastname@example.org> wrote
> Dear eugene
> I love you
> from eugene
And now thousands and thousands of people around the world know that you
love yourself, Eugene. Sorry to see that the caps key on your computer is
not working too well.
Microsoft Office Access MVP
...cell format, custom type: mmm-yy; working with
A cell is referenced in an equation. That cells format contains a
custom type: mmm-yy. How does a vba function work with that
generally? Is it a string to be chopped up and worked with, or can
you use some object property to get at the value or month and year?
If you want to use the formatted value of the cell, you need to use the
..Text property of the range object
Dim myC As Range
Set myC = ActiveCell
.Value = Now
MsgBox CDbl(.Value) & " is the cell's underlying number value"
.NumberFormat = "mmm-yy"