Coding a Command Button to open specific reports
I have two controls, among others, on a particular form. One control
‘ContractNumber’ represents the specific customer (their phone number) and
the ‘ContractType’ which represents the specific report. I have 5 reports,
none of the reports are the same. Based on the ‘ContractNumber’ I would like
to have a command button open the ‘ContractType’ for the particular customer.
I realize I can have command buttons, one for each report and have a
parameter query use the ‘ContractNumber’ to call up the specific report. I
want one button to open different reports, say ‘Click to view customers
C...changing a line to a bar in "line-bar graph"
I have 4 qtrs of data and a benchmark set up in a line-bar
graph. when the graph comes up, 3 of the quarters are
reflected as bars; the 4th qtr appears as a line, along
with the benchmark. I want to be able to change the 4th
qtr to a bar.
I need this for a board report - ASAP please
Right click on the series, choose Chart Type from the pop up menu, and
select the chart type you want for that series.
Jon Peltier, Microsoft Excel MVP
Laurie M wrote:
> I have 4 qtrs of data and a benchmark set up in a...Outlook using MSN 6.0 and slows down system
Evener since I have installed MSN 6.0 outlook pauses several seconds
everytime I click on a new mail in outlook. I noticed during this time that
there was network activity whenever I clicked on a different mail in
outlook. Using my firewall SW, I determined that MSN was being run(I had
exited MSN) and was accessing the network everytime I clicked on a different
So the question is, How do I stop Outlook from calling MSN everytime I click
on a new mail????
What version of Outlook? Check Tools | Options | Other and disable IM
PATRICK REED [Outlook - MVP]~~~~~~
...Account Format change
I need to add a new segment to my account framework and also increase a
segment length for my existing accounts.
For example: from 10-999, I need my account to read as 30-10-00999 where the
first segment is the new segment and the last segment of 999 becomes 00999.
Will Reformatter or the product from Microsoft do both of these things?
Anyone has experience with this.
I believe you need Reformatter from CRG.
Charles Allen, MVP
> I need to add a new segment to my account framework and also increase a
> segment length for my existing accounts.
> ...Wordmail in Outlook 2000
When I choose the "Use Microsoft Word to edit e-mail
messages", the Outlook use the "username" as the default
style name in start writing a new e-mail, it DOES NOT use
normal style at all, how can I force Outlook to use
normal style when start writing a new message?
I am using Outlook 2000 and Word 2000
Thank you in advance.
Tools > Options... > General > Email Options... > Personal stationery
"Sam" <firstname.lastname@example.org> wrote in message
news:18d4c01c41bb2$ef0494c0$a401280a@..."Today's Total Change" doesn't calculate in Portfolio Manager
I've had a problem with Money 2005 and 2006 Deluxe where the Portfolio
Manager does not show "Today's Total Change" for stocks & mutual funds. It
shows it for some, but not others...this is not only an annoyance, but
prevents me from seeing how my investments are doing on a daily basis.
What's interesting is that it shows today's change in the price of the stock
or the NAV of the mutual fund, but Money seems to have issues with
multiplying that by my number of shares to get "today's total change".
I saw a patch for this in Money 2001, but it w...Publisher2003 wont open a Publisher2000 .php file
I have a bunch of files created in Publisher 2000. Now
that I upgraded to Publisher 2003, it wont open the .php
files created by Publisher2000. Any ideas?
..php files are not Publisher files. I believe those are MS's Home Publishing
files. Publisher files have a .pub extension.
MVP Microsoft [Publisher]
"eddie" <email@example.com> wrote in message
> I have a bunch of files created in Publisher 2000. Now
> that I upgraded to Publisher 2003, it wont open the .php
> files create...Outlook 2003
Reply to all does not function when the Exchange server is
not available (working offline).
Also, you cannot add a meeting appointment to your
Outlook responds with "The Microsoft Exchange server is
unavailable. Oulook must be online or connected to
complete this action."
This happens whether cached Exchage mode is selected or
Is this a bug or have you found a solution to it?
...Use Internet mail when offline
I am using Outlook 2000 Sr1 with Exchange server 2000
When away with my laptop I am working offline, I dial to the Internet using
a modem but when sending an e-mail it trys to connect to the Exchange server
remotely to send it ... and stays in outbox folder.
Is any way to get use only internet mail to delivery e-mails even when
Is any way to send e-mails using internet e-mail on dialup connection when I
am away ?
It sounds like you have your Exchange mail and Internet Mail in the same
profile. Try separating them into 2 separate profiles, wit...version changes
i created a business card on Publisher (xp) but when i try to load it onto a
computer w/ a color printer that has publisher ('97) it says i can't load
stuff from another version.
is there any way i can "downgrade" the project to make it compatible with
the older version?
didn't mean to post that twice. see above. ^^^
No there isn't. Copy the file to a disk and hie thee to a print shop.
MVP Microsoft [Publisher]
"Pringles." <Pringles.@discussions.microsoft.com> wrote in message
news:285A2C89-D032-4123-87C0-0ABFF5B652A5@mic...change cell change picture
I'm using cell to display picture, for that, i saw a topic here with this
but the problem is that i'm not getting the pictures displayed, it appears
like example only without picture.
I'm making the connection between picture and cells with INSERT -> NAME ->
someone can tell me how can i do to work it out?
...Re: Outlook leaving toolbar artifact after closing
"Bill" <Bill_NOSPAM@comcast.net> wrote in message news:...
> "Diane Poremsky [MVP]" <firstname.lastname@example.org> wrote in message
>> Which toolbar is left? Does it also happen if you close and restart
>> outlook using the /safe switch?
>> See http://www.outlook-tips.net/beginner/switches.htm if you need help
>> using switches.
Hi! Good news, I think. The problem does NOT occur when I open Outlook
using the /safe switch (sorry accidentally sent the last message).
Bas...Prompt for user to change passowrd...
Is there anywhere in setup where we can prompt a user to change their password?
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 not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=38427276-d6c5-4b43-8f63-1f1b6e6f836c&dg=m...Change insidewidth property
i need to change the insidewidth property in plot area what size i want. for
ex. if i am giving chatarea.plotare.insidewidth = 200 then it shows error
because insidewidth is read only double. so how to change that value
You can not change the value directly because as the error says it is a
Read-Only property. You would need to change the 2 things that effect
the value, plotarea width and axis labels. But it would be a case of
trial and error.
M Selvaraj wrote:
> i need to change the insidewidth property in plot area what size i want. for
> ex. if i a...Appts not visible Outlook 2003
New Outlook user. I don't use the email, just
appts/contacts/tasks/notes. I switched to Outlook from a PIM I used for
years and synced with my iPaq (2003SE). My migration was simply to
change ActiveSync settings to include the uses listed above, as all my
data was on the PDA. It worked just fine, everything transferred and
new updates are flawless.
Here's the problem. In ANY Calendar View, my PAST appts are all
"visible" (the dates are bolded in the sidebar calendar and they show up
in day/week/month views), and the NEW appts I schedule using Outlook are
visible, ...Windows 7 installed Word documents won't open
I installed Windows 7 this past weekend.
I received an email with a word document attached. The attachment will not
open. I get a "An error occurred sending the command to the application".
I did not have this problem with Vista.
I have uninstalled and reinstalled Microsoft Office and that did nothing.
...changing page layout
I did a document in publisher in portrait layout, with a picture and would
like to make it a side fold document/
Setup a new publication as a booklet, copy/paste your objects from the older
Mary Sauer MSFT MVP
"chinadoll" <email@example.com> wrote in message
>I did a document in publisher in portrait layout, with a picture and would
> like to make it a side fold document/
...Can't click through on links in e-mail (repeat)
Ever since one of those "critical Windows upgrades" we have been unable to
through to a web page from links in e-mail. This is a real pain for links
that say "click here" rather than the URL.
A blank, white Explorer session opens along with an error window that says
"Locate Browser Link" with a cursor blinking in the "file name" field.
We are running XP Home edition V5.1 and Outlook
2002 (not Outlook Express) SP-2. No pop-up killers or anything like that.
When the message pops up to locate link browser, follow its direct...Server Log on changes
When I try to send outgoing email my login iformation changes and I get the
Your message did not reach some or all of the intended recipients.
Sent: 5/22/2006 11:52 PM
The following recipient(s) could not be reached:
firstname.lastname@example.org on 5/22/2006 11:54 PM
You do not have permission to send to this recipient. For
assistance, contact your system administrator.
<mycompany.domain.local #5.7.1 smtp;550 5.7.1 Authentication is
required to send mail as <email@example.com>>
Any Ideas...how to change the icon text
What event to I do to handle when my app get iconified? I Need to set the
window text for my icon differently than my app title bar text.
When I run my app, the window text for the app title bar is "foo", when the
user iconifies the app, I want the icon text to be "bar".
How do I do that?
Thanks for the help,
Take a look at CWnd::OnSysCommand. SC_RESTORE and SC_MINIMIZE is what you
want to look for in this method.
Ajay Kalra [MVP - VC++]
"reza razavipour" <firstname.lastname@example.org> wrote in message
news:uK18XkXH...Outlook Profile Missing
We have Outlook XP on Exchange server at work. Recently we
have had three users outlook profiles disappear. All the
data is still on the server, but it basicly looks like a
fresh install of Outlook. No mail, contacts, etc. Any
ideas on what is causing this? Thanks for the help.
...How to change Pivot when SQL data source fieled name changed
Q: How to change Pivot when SQL data source field name changed
I have a Pivot table that accesses a SQL data source.
When one of the Fields Names in SQL is changed there is an error when trying
to refresh Pivot Table.
I cant find a way to edit the Pivot Table MS Query for the new SQL Columns
Name like I can when just using MS Query to import data into excel vs into
Is this possible?
Resolution: Call up the "Pivot Table Wizard" and hit Back Button to retrace
steps and change data source
> Q: How to change Pivot when SQL data source field...How do I move files that are linked with template wizard?
I would like to move the location of an entry form and database that was
created with the template wizard. Unfortunately, when I do this the entry
form cannot find the new location of the database. How can I correct this?
...Run-Time Error 438 Outlook
I'm trying to run a function out of MS Outlook VBA and having difficulty. On
my main PC it works just fine. On my remote desktop I seem to get the error:
"Run-Time Error: 438. Object doesn't support this property or method".
Again, this is only on my second computer, and I have put the script in both
computer's version of Outlook.
Here is the script:
Public Function SendEmail(strTo As String, _
strSubject As String, _
strMessageBody As String, _
Optional strAttachmentPaths As String, _
...Outlook will quit sending/recieving unless i reboot PC???
Outlook will fail on all send/recieves after a while until the PC is
rebooted. Network connection is fine and working correctly. However
Outlook errors out like it can't connect to the server. It's just a regular
PoP 3 account setup.
The PC has to be restarted and Outlook continues to work just fine. Any
how frequently are you checking for new mail? set it to check every 10 min
and see if it works correctly.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/