I currently have categories going from 1st of may to 11th may. How do I get
it to just have labels for the even numbers (2nd/4th/6th/8th/10th)?
Also, how do I have 10,20, 30, 40 amd 50 on the value axis. How do I remove
the bottom one (10) but keep the rest?
Generally you have little control over non-uniform display of axis tick
labels. But you can sometimes get what you want with custom number formats.
For the Y axis, you could use a format like
For the horizontal axis, you have to start the axis at 0 March (i.e., 29
Feb) and suppress the fir...How2 set Defaults for Paragraphs in Pub2003
I have just upgraded to Pub2003. My old Pub2000 had no such feature. My
problem is when I cut and paste into the new Pub2003 it automaticly uses a
Line Spacing default "After Paragraphs: 9pt" - this whacks out all my old
logos and forms when they are copy/pasted in to a new Pub2003 .pub
If I open an old (2k) .pub file with Pub2003 the spacing is fine - if
figures out the Line Spacing is "After Paragraphs: 0pt"
...Outlook 0x800ccc0d error when Norton e-mail protect enabled: see hosts
This post is made to help others solve this issue, based on my
- Outlook works perfectly well when Norton Anti-Virus e-mail
protection is disabled
- Outlook cannot retrieve incoming messages when NAV e-mail protection
is enabled, message being: pop3 server not found, error 0x800ccc0d
This symptom, and possible solutions, are exactly the object of
Symantec support note:
Please read this note first ! The object of this post is to add
another possible solution to this problem.
NAV email protection sets up...Reporting from Project Server
I dont know if i need to ask this question here or in the Access section. I
have an ODBC connection to the Project Server database so I can make reports
through Access. Access' limit of 255 fields per table is causing me some
trouble. for example, the MSP_VIEW_PROJ_PROJECTS_ENT table has well over 255
fields. Access only shows me the first 255 fields. how can I change that so I
can see all the fields in that table?
I have not tried this yet it may be a viable option. Have your DBA create a
view that pulls the key fields to this table and the specifi...projecting the notes pages in PPT 2007
I want to project my notes pages to an on stage monitor in while my presentation (sans my notes) are projected behind me...I will run my notes from a second computer... How can I do it?
Submitted via EggHeadCafe - Software Developer Portal of Choice
C# : Image operations performer
See if Presenter View will do what you want with your set up:
PowerPoint...Changing Cells and entering data in them
Thanks for the help again.
Big thanks to Steve you've got me this far.
I went out and bought a book, but it's like reading a
I was informed today that I can't have message boxes come
I need to have the code point at the cells and if they are
blank turn which ever one is blank red or if both are then
both turn red then pause for each cell to be filled in.
Cell F14 "Last Name" then automatically go to Cell
F16 "First Name" on tab or enter.
Basically if Cell F22 or F23 has an X in it, Cells F14 an
F16 turn red and cell F14 has the focus...Moving incoming mail automatically to specific folders.
I have three separate E-Mail Accounts (1,2, and 3)
I have created three subfolders under Inbox (Mail1, Mail2, Mail3)
How can I automatically get the mail sent to the correct Mail in location
(Mail1,Mail2 or Mail3).
I am sure the answer like everything is easy when you know how but I have
just spent an hour trying!
On Mon, 2 Jan 2006 00:24:44 -0000, "EddyStone" <firstname.lastname@example.org>
>I have three separate E-Mail Accounts (1,2, and 3)
>I have created three subfolders under Inbox (Mail1, Mail2, Mail3)
>How can I automatically get the mail sent to ...Change position ID in HR
We would like to change the position ID in human resources. Does anyone have
a suggestion on this.
You would need to do it behind the scenes using a tool like Query Analyzer.
Charles Allen, MVP
> We would like to change the position ID in human resources. Does anyone have
> a suggestion on this.
careful though when you change it on the background as you need to know all
the tables that use this position ID or Position Code and change it there too
otherwise all the link would be gone and you end up with orphan records that
its just the same as creatin...print multiple pages on one sheet of paper
I am using mailmerge in Publisher to create placecards for a party we are
hosting. The final size of the placecards is 1.5" by 1.5" and we have to
print 100 final cards.
Publisher gives me the option of printing multiple copies of the same page
on one sheet of letter sized paper or one page on one sheet of letter sized
paper. What I would like to do, however, is print multiple different pages on
one sheet of paper. If I cannot find a solution for this, I will need to
print 100 separate pages with a 1.5" square box of copy in the center of each
In page setup, sel...default values in a cell
Hello, can you help me please
Cell B1 contains a complex mathematical formula which requires (in several
places) a number from cell A1.
Cell A1 can contain any integer number, but it is usually the same (30).
I would like to be able to leave cell A1 empty, and only enter a number when
it is not 30 ,
ie the default value of A1 is 30, unless specified.
How do I go about this ?
Should I look at conditional formatting, or put lots of IF functions into an
already complex formula?
Thank as always
Use 2 cells
Modify the complex formula to use B1 rather than A1 ( or any other un-u...setup Windows Mail as Word 2003 default emailer
All I can do is setup Outlook. I do not use Outlook.
I would like to email Word docs using MS Windows Mail (new version of Express)
In the Windows Start area, type Regedit into the search bar and then start
the Registry Editor and go to
Right Click on the (Default) item and then on Modify and in the Value data:
field enter Windows Mail so that after you click OK, you have
(Default) REG_SZ WIndows Mail
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a pa...microsoft.public.access.conversion
...Business Portal Development
I know how to use Rational XDE, VS and the BP SDK to create new entities in
BP, but how does one go about chaning labels?
For example, if I wanted to change two labels on a requisition mgt screen:
Can I just crack open the ASPX page and change the caption property?
To edit the lables you can use front page server extensions 2003.
"Dwight Specht" wrote:
> I know how to use Rational XDE, VS and the BP SDK to create new entities in
> BP, but how does one go about chaning labels?
> For example, if I wanted to ch...Default scene is solid blue but only on one account
I have 2 accounts with WLM, on one the default scene is as it should be, a
mix of blue and white. But on the other account it is solid blue. If i
change the scene in the program it changes to that but any contact windows i
open continue to be solid blue by the persons name but above that is the new
scene. I've done a repair job on 2 computers but does not fix the problem.
...outlook 2007 e-mail
how do you stop e-mails from automatically downloading when you open outlook
2007. i would like to be able to open outlook 2007 and have it wait for me
to select 'receive' before downloading e-mails to my system.
i know there is a way to do it in outlook 2003 but i do not remember how to
do it there and i cannot find how to do it in outlook 2007.
Uncheck the option to send/receive at a specific interval.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted w...How do you change the APR?
How do you change the APR in a Credit Card account? Like if you have to
change it from 13.250% to 14.240%
Depends on the version but (in M2007) go to the CC Account and click on
Change Account Settings. Scroll down to Credit Information and click on
Change Credit Details. If you want to change the Minimum payment rate/amount
as well, click on the Minimum payment amount and a side window opens.
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically ...After editing example1.xls and click SAVE, the filename changes to AABBEE.xls
After editing example1.xls and click SAVE, the filename
changes to AABBEE.xls. The original file still exist and
has been updated but the 'funny' filename also have the
same content, and editable. The example1.xls is stored in
a server and accessed by many people within the company.
Everyone accessing to the file will change the filename
unknowingly after saving it.
...Access to User Calendar
I have a user called small conference room that is used to schedule meetings
on its calendar. I would like to link the calendar from our intranet site to
the calendar with a UNC path. I am calling outlook: and I can get to my local
mailbox and public folders but I am unable to connect to another users
I am running Exchange 2003 and Outlook 2003. Is there some security
modifications that need to be done?
Any help is appreciated.
I believe that you will need full mailbox rights.
MVP - Exchange
"Protecting the world from PSTs and brick backups!&...OE autodelete OLD mail
How do I have Outlook Express automatically delete 90-Day
old messages from the deleted items folder?
This is a group to support Outlook from the Office group of programs.
Outlook Express is a part of Internet Explorer and is a quite different
program, despite its similar name..
You will probably get a faster and more expert answer if you post this to an
Outlook Express news group.
Try posting in one of these newsgroups:
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
microsoft.public.windows.inetexplorer.ie55.outlookexpress for OE 5.5x
microsoft.public...mail queues for long on Exchange 2000 server time before being sent
I have a situation where all outgoing mail sits in a queues on the Exchange
2000 server (one per domain) for about 45 minutes before being sent. The
queues in question have a status of ready. There are also other queues of
that are retries (mostly NDRs from junk mail). We are only a small company
and the amount of mail is not great. What might Exchange be waiting for
before sending this mail? Is there something I can tweak to make it send
Thanks for any help,
Where does the mail go after it leaves your Exchange server, does it go to a
smarthost/isp or d...How to set "licence" for Access 2007 database?
I developed an Access 2007 db to a client. Now I want to make a year
based licence for that database that the client must pay if they want
to continue using the database after year. It must be so that database
cannot be used after this date. How I can accomplish this? Thanks!
On Mon, 12 Apr 2010 13:14:17 -0700 (PDT), Sandroid
>I developed an Access 2007 db to a client. Now I want to make a year
>based licence for that database that the client must pay if they want
>to continue using the database after year. It mu...Missing Mail Folder
I am using outlook 2003
A subfolder within my main mail folder disappeared from
view. Although I can not see the folder, I did an
advanced search for mail messages in the missing folder
(I know the name and typed it into the search crieteria,
it was not available on the dropdown) and Outlook found
all of the messages. From the search results window I
moved them to a new folder but still have not been able
to see the old folder. I am not positive I have all of
the mail from this folder.
Any suggestions about recoveering the folder? I am
interested in the root cause so I can preve...How can I change text to proper text in multiple cells.
I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Insert a helper column to the right of the column with the names.
Then use a formula like:
and drag down that column
Then select that column
select the original range
And then delete the helper column.
> I...Changing Domain Name through Internet Address Management Wizard
I know its weekend. but i need to post for peace of mind. I have a
client using SBS 2008 STD.He isusing remote.mydomain.com address through
Internet address management wizard. Now he wants to change to
remote.mynewdomain.com as old domain is too long. Is there any way so we
can change through IAMW.
run the wiz, job done.
"Atul Sood" <email@example.com> wrote in message
> Hi Guys
> I know its weekend. but i need to post for peace of mind. I have a client
> using SBS 2008 STD.He isusing rem...Problem with different versions of Access
I am working on a VBA Access pplication which connects to a SQL Server
I have a continuous form displayed with data, ad it is linked to a
database table, so when I enter a value from my form the data in
instantaneously updated in the database.
The problem I have is that this form works perfectly when I am
developping, and using my developpement environement (with Access
allowing me to set breakpoints, go step by step in the code and so on),
but it does not work when I use it in the PC of the ending user : in
this case, when I enter a value in the form, and click in a...