Can I change the calendar year beginning date?
Our fiscal year runs July 1 thru June 30 of each year. I need to track
attendance, gas cards, etc for monthly reports. I have a HUGE table with a
gazillion queries and reports for each one. I need one report to reflect
quarterly output for our fiscal year as stated above. Can I make this report
Create a query to use as the source for your report.
In query design, type this into the Field row:
FinYear: DateAdd("m", -6, [InvoiceDate])
replacing InvoiceDate with the name of your date field.
This yields 2007 for all dates in the 2007/2008 financial year...Can't install windows updates on SBS 2003
I have a SBS 2003 server that has not been updated in a couple years. It has
SP2 installed but when I run Microsoft Update it needs to download and
install 96 updates. When I try to get them installed it comes back with an
error saying not enough disk space. I have tried to just install 1 update at
a time and get the same error. The C:\ drive has over 14GB of free space and
the other drives have plenty of space as well. I restarted the server and
also ran Disk Cleanup, as the error message reccomends, but am still having
the same problem. Anyone run across this problem befo...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...How can I clear the last Data->Text to columns to formatting
I've noticed in Excel 2000 that if I paste text into various worksheets
within a workbook each paste will assume the Text->Column formatting that I
applied in the previous. How can I prevent it from happening ?
Just run another data|Text to columns against a dummy cell.
Specify delimited, but remove all the check marks from all the possible
(alternatively, you can close excel and reopen it.)
> I've noticed in Excel 2000 that if I paste text into various worksheets
> within a workbook each paste will assume the Text->Col...Can't open Money 2002
Been using Money 2002 for 2 years no problem until now.
When I tried to open it, a window popped up (maybe showing
a registry or something) for about 1 second, then...
nothing. I even did a reinstall and at the end of the
installation when Money is supposed to open, the same
weird window popped up and then again... nothing. I have
Norton antivirus with automatic updates. All other
programs seem to be working fine. Any suggestions from all
you experts out there? Thanks.
In microsoft.public.money, Byron wrote:
>Been using Money 2002 for 2 years no problem until now.
>When ...Can't send from OWA
I have an 03 Exchange environment and am using the forms based
authentication through an ISA 04 server for my OWA.
I have a number of employees that work around the world and use OWA in order
to access their e-mail. I have received reports of problems from a few of
these individuals when trying to send an e-mail. They are able to
successfully login to OWA but when they generate a new mail message, they
receive the following error.
'Check Names.. Web Page Dialog
Microsoft Outlook Web Access does not recognize "firstname.lastname@example.org"
Do you want to
Delete this recipi...how can i set up my pop and smtp account using proxy server in ou.
"Abhishek" <Abhishek@discussions.microsoft.com> wrote in message
You'll need instructions from your ISP.
Ben M. Schorr, OneNote-MVP
Stockholm Consulting Group/KSG
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
...Visio 2003--Can't drag objects from templates into flow charts.
Utilizing Visio 2003 in an Microsoft XP environment, I have not been able to
drag objects from templates onto flow charts. I do not understand why.
...Can Outlook 2003 use MSN Messenger INSTEAD of Windows Messenger?
I didn't get an answer to this question last week so I'm re-posting...
I recently purchased a new computer (Windows XP Home Edition w/SP2) and
loaded up all of the available updates to the OS, Internet Explorer, etc.
Next, I installed Office 2003 Professional. I disabled Messenger
integration with Outlook 2003 as discussed in other posts here.
Next I installed MSN Messenger 6.2 and it seemed to run properly as
a stand-alone application. So I re-enabled Messenger integration on Outlook
2003. The next time I booted up and ran Outlook, the Messenger icon appeared
in the taskbar...Relaying denied / Can't send to aol.com & cisco.com domains
We have 1 internal Exchange 2000 server for our only domain, dortfcu.org.
When we try to send an email to anyone at the aol.com or cisco.com domain,
their email server says 550 5.7.1 <email address>... Relaying denied. I
think the issue is a dns issue and is due to the fact that I upgraded one of
our 2 dns servers from windows 2000 server to windows 2003 server last
NSLOOKUP of dortfcu.org with type=mx says that mail exchanger =
smtp.dortfcu.org. The servers real name is dort2.dortfcu.org. So I guess
this means my mx record is wrong? I don't have access to my ...Categories deleted converting from Quicken
I just converted from Q2003 Premier to the Money 2005 Trial 2 days ago.
I noticed today that a number of categories have been removed from the
transactions in my checking account and credit card accounts. What I've
noticed so far:
1. All sub-accounts for Utilities were gone. This wasn't too bad
because I could use find replace since the payee name has been the same
on these for all years I have in Quicken/Money.
2. All sub-accounts under Insurance were gone.
3. The category Groceries came over, but there were no transactions in
it. Quicken had several hundred...Convert Double Space To Single Space
How do you convert double spaced text to single spaced? I
don't see an option for this in Outlook. I can paste into
Notepad, copy and then paste into Outlook, but I would
prefer a way to do it within Outlook.
...Converting Money 2000 Canadian to Money 2006 Canadian
Can anyone confirm that such a conversion is possible? I was hoping to
convert to Money 2007 but was unsuccessful. I'll live with Money 2006
Canadian but I want to ensure the conversion is possible first. I don't want
to drop the money on it to find out it doesn't work.
Thanks in advance,
In microsoft.public.money, smurfgun wrote:
>Can anyone confirm that such a conversion is possible? I was hoping to
>convert to Money 2007 but was unsuccessful. I'll live with Money 2006
>Canadian but I want to ensure the conversion is possible first. I don'...Outlook 2007 - Exchange 2003
I just upgraded my desktop to Office 2007 - Removing the older Office2000.
Our Network is all 2003 Servers & Exchange. My Destop is XP SP3
In OL2007 I cannot see/find any of the exisitng public shared calendars that
I could see/access in OL2000. I can see them when I'm in Webmail and
desktops still running Office 2000 can see the public calendars.
Any help is appreciated.
Which navigation pane are you in? Press Ctrl+6 to see the folder list.
BTW, Did you keep the old Outlook 2000 profile? We recommend new profiles
when upgrading from older versions.
...Windows Update Office 2007 Converter confusion
On my desktop I have Office 2003 (laptop has Office 2007). I recently
received an attachment in .docx format (2007). I downloaded the converter to
my desktop and opened the document. Now on my desktop (which has Office 2003)
I receive update notices for Office 2007. Should I ignore these? Hide them?
Install them? Will I still be notified re updates needed for Office 2003?
Thank you for whatever insight you can provide. If you can give me some of
the background explanation as to why this is happening (I presume related to
the 2007 converter viewer install), I can understand bett...how can I add a signature to my calendar appt requests?
See subject question
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Real World Answers
"tnowak" <email@example.com> wrote in message
> See subject question
...Can I set SQL mirroring across WAN?
We have a 100 Mb dedicated DR link to another data center. Want to set up a
SQL 2008 database to use mirroring from primary to a standby server at the
remote data center. I did a ping test and here is the result.
ping -n 100 -l 5120 <target IP>
Ping statistics for <target IP>
Packets: Sent = 100, Received = 99, Lost = 1 (1% loss),
Approximate round trip times in milli-seconds:
Minimum = 8ms, Maximum = 19ms, Average = 11ms
is the network latency good enough for database mirroring? Does anyone know
the min. requirement? Field experience will be fine too....Can I show server name instead of drive letter?
When using the =Cell("filename") function, I would like to show the actual
server instead of a drive letter because the letter is dependent on where the
server is mapped and not all users have the same mapping. Is this possible?
where ServerName is the name of the server and drive is the appropriate
drive, and then find the file on the drive from that point.
> When using the =Cell("filename") function, I would like to show the actual
> server instead of a drive letter because the letter is dependent on...protect a document so it cannot be amended by others but it can b.
Hi is there a way in Excel that I can password protect a document so only I
can make changes but others can read it and filter it when they require
information. I have tried to put a password on but it wont let anyone else
use the filters in the spreadsheet. Please help!
"S_H" <S_H@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi is there a way in Excel that I can password protect a document so
only ...can I use 11 x 14 paper in office documents?
Is it possible to use a larger sheet of paper when using publisher?
Yes. First select the paper size in the Printer Setup.
"Prairie Inn" <Prairie Inn@discussions.microsoft.com> wrote in message
> Is it possible to use a larger sheet of paper when using publisher?
If your printer can handle it, yes.
MVP Microsoft [Publisher]
How to ask a question
"Prairie Inn" <Prairie Inn@discussions.microsoft.com> w...Can I have spell check ignore errors and alert me to real words?
Instead of stopping on misspellings and skipping real words, is there a way
to stop on correct spellings to find actual words in a bunch of gibberish?
Sort of an "UNspell check". For example, pass over "JJKSXO" but show me
No, there is no way of doing that
> Instead of stopping on misspellings and skipping real words, is there a way
> to stop on correct spellings to find actual words in a bunch of gibberish?
> Sort of an "UNspell check". For example, pass over "JJKSX...Bulk sending of emails in Outlook being rejected if one address is wrong.
I am sending bulk emails in BCC and they are all being
returned to me because one or more of the email addresses
is incorrect. Is there a way to setup Outlook so that the
emails go to the correct addresses and the incorrect
addresses are bounced back to me?
I use the Mail Merge feature and send out a newsletter
with over 1000 e-mail addresses (who signed up for the
newsletter so it is not spam). My service provider,
Comcast, just put a limit of 10 at a time. It's real fun
sending these out monthly!!
>I am sending bulk emails in BCC and they a...Can you link 2 worksheets together?
Say i have one worksheet and on my second one I want to reference cells from
the first one? is there a formula for that>?
To create a simple link:
Select a cell in the second worksheet
Type an equal sign
Select the first sheet
Click on the cell that you want to link
Press the Enter key.
> Say i have one worksheet and on my second one I want to reference cells from
> the first one? is there a formula for that>?
Excel FAQ, Tips & Book List
...how can I asign printscreen to a function key or key combination?
My key board has no printscreen key. What can I do?
That seems unlikely, but it is hardly a Word issue. The PrtScn button is
usually a dual function button somewhere on the top row of your keyboard. If
it is not then you need to ask the keyboard manufacturer.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< ...Can't connect to Exchange server after VPN access
I can connect to my office Exchange server when in the office (LAN) but I
cannot connect outside with Outlook.
I can only use the webmail after entering a web VPN access:
- First portal for VPN : https://xxx.yyy.com --> I enter my
- On the next web page, I have the choice for the webmail and it's a link as
https://xxx.yyy.com/go/webmail.yyy.com~ssl where I can enter my
So I can't enter the url in RPC as every slash is forbidden
In my Outlook, the Exchange server (EXC.yyy.com) is not reachable by ping
(or tracert) and I can't ...