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...Auto assign Lot Numbers in PO receiving
Has anyone made a customization to auto assign Lot numbers upon item
receipt? My client's lot number is numeric, they want the system to auto
assign this. Any ideas? Thanks!
Yes indeed, I created one for a client. You probably will not be able to
use it as-is because of some client specific functionality but
I'm sure you could use this as a stepping stone.
The key features were that it would allow for rapid lot number entry by
a. Auto-incrementing the lot number - we had Alphanumeric lot numbers so we
added a suffix and
b. copy the previous lo...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 "email@example.com"
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 ...Need to import EDI file
Hello. I have an EDI TS-130 file (academic transcript) that I would like to
import into Access 2003. Is this possible to do for free? If so, how?
...Importing Messages From Another Mail Program
I just set up outlook express 6.00.2900.2180 for XP SP2 and wish to import my
messages and folders from Netscape 7.0 mail and when I follow the
instructions and click on the netscape Local Folder inbox file, I get a
message from outlook that says there aren't any messages in the file. I tried
to mail the files as attachments but that didn't work. Is there some other
way to export these messages .to outlook express.
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
I want to upgrade from Microsoft Money Financial Suite OEM Edition Version
11.0 to latest version but on trying to open the money file in Microsoft
Money 2007 I get the following error message:
File was created by an incompatible version
Question 1: As the old version was pre-loaded into the Computer when I
bought it in India, I don't know which country US/Canada/UK/Australia this
software belongs to. So how can I confirm which country is it for?
Question 2: And, how can I upgrade it to a version of Money from US or UK.
...Most important file won't open
The only file I can't get into is my most important one.
Each time I try to open it I get a "This program has
performed an illegal operation and will be shut down."
In the details it says, "Excel caused an invalid page
fault in module MS097.dll at 0167:306eef2e." How do I fix
Jim, "The only file I can't get into is my most important one" why is it
always this file!
Just a couple of things to try, have you rebooted the computer? this will
sometime solve a world of problems, try opening it on another computer, was
anything added to the file...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.
If I have a nice schema, created with xml spy.
Can I import to visio. creating a nice visio diagram?
visio (and the other office products) each has their own schemas. However,
that does not preclude your creating an xslt transform to map to what is
appropriate to what visio requires. Chris Roth one of the MVPs has a nice
presentation on some of the basics.
"greg" <firstname.lastname@example.org> wrote in message
> If I have a nice schem...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...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
<>>< ><<> ><<> <>>< ><<> <>>< ...