Conditional Formatting through VBA works in print preview but nowhere else!
I'm trying to put together a report in Access 2007 where the detail record is
displayed as a different background color depending on the value of a field.
There are more than 3 conditions, so I've opted to attempt this via VBA. It
works- but only in print preview.... Why? I can't figure out what I'm doing
wrong. I'm sure it's something simple, but I'd really appreciate some help
on this one.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Select Case Me![Status]
Me![Text43].BackColor = RGB(165, 165,...Peoplesoft add-in doesn't work with Excel 2003 (in IE)
I'm currently trying to resolve a function problem with the nVision Drill Down option available from Peoplesoft.
We have a peoplesoft website that displays the reports (Excel spreadsheets) within the IE web-browser.
Once the report is displayed they highlight an amount and press the menu option listed as nVsionDrill. However this action does nothing. If they save the Excel spreadsheet to the hard-drive and open it externally from IE they are able to select the nVisionDrill option, however the links are broken if it is not opened from within the IE page and they can't progress ...Visio Pan & Zoom Widget -- Has anyone found a way to make this feature work with Netscape of Firefox Browsers ?
This might be hard to believe, but some of my clients use browsers other
2nd Post in two weeks
Still looking for an answer
...Sending to Hotmail not working
Exchange 2003 SP1
Windows Server 2003
AD 2003 Domain (not installed on MX server)
I'm able to send and receive mail from/to any domain just fine, except
hotmail.. I'm able to receive email from hotmail, but when I try to send to
hotmail I see it sitting in the queue on the exchange server as active, but
they just sit there.. It was working yesterday.. I confirmed that reverse
DNS is properly set up.. I did the EDNS registry entry (EnableEDNSProbes)..
any other ideas what the problem could be?
On Thu, 22 Jun 2006 10:19:38 -0700, "Michael Miazga"
<email@example.com...Intelligent Message Filter not working
I am having a battle to get intelligent message filtering working. I
have installed SP2, changed the reg to download updates, configured the
default SMTP server to use IMF, set my thresholds, but nothing is being
When I check the events log, there are no logs for any filter events.
I have re-started the SMTP service and the server, but still nothing.
Is there anything I can check to see what is happening or not
Many thanks in advance.
Download Microsoft Exchange Server Intelligent Message Filter v2 Operations
Guide. You find a few ways to monitor using even...can someone tell me why this isnt working? #3
no, that still didnt work... this is SO aggravating, i've been like half
a step away from finishing this whole project for 4 days now.
samccune's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14597
View this thread: http://www.excelforum.com/showthread.php?threadid=263653
On Mon, 27 Sep 2004 14:52:29 -0500, samccune
>no, that still didnt work... this is SO aggravating, i've been like half
>a step away f...Problems getting EPSON TM-T88III Printer to work
We have 4 cashiers each with EPSON TM-T88III Printers. Two of the cashiers
work properly and 2 don't.
When we run the health check on the ones that don't work we get an error
window with the text:
Error occured in calling the health check method
Claim(5000) = 16 (0x0000006A)
The stations that are working are configured the same as the stations that
are not working. We have checked with our partner but everything that they
tried has not worked.
We have even tried exporting the registry entries form one of the working
stations to one of t...Powerpoint 2007 03-12-10
I have tried to change the theme or template to an existing presentation but
Powerpoint will not apply the change?
How are you going about changing the theme/template? What is happening -- or
not happening, as the case may be?
Which version of PPT?
Assuming PPT 2007, you might try hitting the Reset button on Home tab |
Slides group (next to the New Slide button). Sometimes if there are a lot of
customizations to the slide in question, you have to reset its layout.
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2010? http://www.echosvoic...Fields used Standard Cost Rollup Work
We need to better-understand how the SC Rollup works. Specifically, what
field(s) does GP use to calculate proposed standard cost for PURCHASED items?
We're getting funky data and need to drill down on it.
Thanks, in advance, for your help.
...Outlook 2003 Add-In buttons stop working after remote desktop connection
All current XP and Office patches installed (not XP SP2 yet).
I'm not certain of exactly how to reproduce this because it is kind of
random. I have a custom addin and after accessing outlook through a remote
desktop connection the addin button stops working sometimes (keeps working
at other times). At first I was thinking it was something with my addin,
but I noticed that the same thing happens with Import New Assignments from
the Project addin for outlook. When you click on the addin button on the
toolbar nothing happens - it doesn't cause an error or anything, it's just
like ...Just make them work correctly!!!!!!!!!!!
When windows that have a scroll bar do not maximize, what's that all about?
Have you ever tried to build a P&L with the layout window when it is only
1/4 the size it should be! These features all worked with GP 9.0. Why are
they gone now?
Even Peachtree and Quikbooks have that feature. By the way, I am not
speaking of windows that do not have a scroll bar.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do ...RequiredFieldValidator not working for dependent dropdown
I have two dropdowns: I've added a first item like "Please Select" to each
and each has it own RequiredFieldValidator control which fires if the user
does not select something. The code for the second one looks like this
<asp:DropDownList ID="ddl2" runat="server" AutoPostBack="true"
<asp:ListItem Text="Please select" Value="0" />
...CButton::SetImageList Not Working
I have tried to make CButton::SetImageList work but it doesn't. I am
using the following piece of code
lst = new BUTTON_IMAGELIST;
When this executes , i Don't get any images on the button. All I get
is a change in the text alignment.
What am i doing wrong.
&quo...Does Money for Pocket PC working with WM 5??
I try to sync the data with my desktop but never success, please help.
...trim and clean not working!
I have pasted text from another app.
It looks like it has a space at the beginning.
When typing text in a cell a space must be put in
at the beginning to make it align with the text pasted in.
I have used both CLEAN and TRIM to no avail it just trims the text that was
typed and leaves the pasted text with the space at beginning.
I have also tried pasting it into wordpad and notepad and pasting it back to
excel and the space is still there. Any Ideas?
If you want to get rid of only the first space, and assuming that your
text is in Column A, then try something like this,
en...Outlook 2000 password doesn't work... :-(
In Outlook 2000, I set a password for my personal folder
..pst file. But... this password is never asked for - I can
start Outlook and go to the personal folder without
having to enter this password.
However, if I want to change the password, I DO HAVE TO
enter the password, so Outlook somehow seems to know about
this password. Strange...
Is there some option or registry entry I have to change
to "activate" password protection?
Thanks for any hints!
...Why does Money 2005 work like molasses?
"Ara" <firstname.lastname@example.org> wrote in message
Because it's winter?
"Ara" <email@example.com> wrote in message
It's a feature!
...IMAP4SVC doe not work
I have MS Exchange 2003 on Windows Server 2003.
After last power outage IMAP4SVC does not work.
Microsoft IMAP4 service sown as STARTED in services, but Virtual IMAP4
server in System Manager is down. When I'm trying to start it I see the
message, that IMAP server shows specific error and can not be started.
There is a Warning in Event Log with Source: IMAP4SVC and Event ID: 1036
"An error occured while starting the Microsoft Exchange IMAP4 Service:
server instance number 1 failed to start with error 0x36b7"
thank you, Gary Uber
...Outlook Rules that don't work
I have a similar problem to the one below. Rules do not work unless
run with the 'Run Now' option.
Has a solution/workaround to this been discovered yet?
>I discovered something I think might be the problem: My rules do not
>execute when they come in even though the rule wizard says to "apply
>rules after the message comes in". If I click on the box at the
>now" and then check off the boxes for the rules I want to run, they
>on the messages in my Inbox.
>Any idea why it behaves this way?
...How do I create a rule for a mailbox with no single user, which works all the time
I work for a small UK charity. We are running Exchange 2003 and we
have separate email addresses for each member of staff and for several
areas of work which small groups of staff work on together.
Our main email address for the organisation begins info@..., but Yahoo
does not allow us to use that email address for our subscription to
email discussion groups (an anti-spam measure).
I wanted to use one of the other 'area of work' email addresses
(library@...) for sending messages to a Yahoo group we are a member of,
and to set up a rule in Outlook to forward messages from the Yahoo
g...Why does Excel 2000 stop working after installing Crystal Reports.
I installed Seagate Crystal Reports 9.0 to a user's laptop. The Crystal
Reports works fine, as well as all other MS Office applications, except Excel
2000. A memory address error pops up when attempting to start Excel? Can
...import all outlook express 5 data from Mac to PC
I have the following setup:
mac, os 9,2 with outook express 5,0,4.
PC with win2000, outlook 2002.
I want to import all emails, contacts etc from outlook mac to outlook
PC. All folder structures should be imported.
my question: is there a easey way to do this? the datasize of the
outlook mac-data is 1.5 gb, so just sending over the emails doesn=B4t
really work, unfortunately. I have a 2gb memorystick which I can use to
As far as I=B4ve seen the outlook mac-data seems to be in the folder
"identities" under "microsoft user data" - but how do I import a...How to capture powerpoint events in applescript
I want to create an applescript which open's a saved PPT in
powerpoint, let the user edit it and as soon as the user closes the
PowerPoint OR saves it, the script should get notified.
Does PowerPoint send an Apple Event (applicaiton close event) which
the apple script can capture. Is there any way to capture events sent
by other applications in applescript.
Thanks in advance
PS: Sorry for multiposting. I had posted the question on
mac.office.powerpoint but have not received any reply yet, So am
posting it here again.
Again: Please do not post the same question in multiple groups....How does the email router work?
As I understand it you set a rule on the user's inbox that forwards the email
to the CRMMail account. What I am not clear on is whether
1) The emails forwarded will be viewable by all users
2) You can set it so that emails are forwarded to the relevant user only.
What i am trying to do is to allow users to view their exchange inbox from
If option 2 is possible, could someone explain to me how to accomplish this?
What is seen in CRM is NOT the exchange inbox. They are seperate records
and are only loosely linked. Deleting one does not delete the other, so...Is there a stability issue when working with graphs?
Every time I copy a graph from Excel into PowerPoint 2007 then try to format
the graph, PowerPoint freezes up. For kicks I waited over an hour to no
avail. This problem also occurs when I choose to build the graph within
Does anyone know why this is happening and if there is a solution?
Start by making sure you have SP2 installed...and then install this hotfix:
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36g...