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...cannot create profiles in win 7 mail 32 bit
I upgraded to WIndows 7 professional 64 bit and still cannot get my MS Office
2003 to work properly. All the programs except Outlook seems to work fine.
I am totally unable to open outlook without mail profiles. I click on mail
in control panel and I get low memoery or resources too low. That's
impossible. I have 4GB RAM and 1GB VRAM.
In addition, I noticed to night that while I created a profile for myself as
Admin, I do ot have admin permissions EVEN IF I say 'run as admin" If I open
my profile, it syas Admin under my name yet shows up as standard user. I...Event ID 1016 logged for sending an email
I recently emailed a co-worker (at 11:42am). I was then later shown a
security log that showed Event ID 1016 was logged at 11:42am saying that I
accessed her mailbox. I did no such thing! I've researched the
knowledgebase and found some info on this topic, but can anyone tell me how I
can definitively clear my name? Has this happened to anyone else - simply
sending an email caused 1016 to log? I realize that checking the other
person's calendar could also do this, but I don't think I did that either.
My job could be on the line. Thanks for any help you can provide. (...Creating a table
There's probably an easier way to do it but...
I have a series of numbers in column A (150 in all) and a series of letters
in column B (22 in all). In total there are 4800 rows.
What I am trying to do is create a table with the number down the left hand
side and the letters across the top. In each cell within the table I need
to count how many times the combination of number/letter appears. Eg:
A B C
201 0 2 2
202 3 0 1
203 3 6 4
I tried combining the number/letter into a single text field using the
CONCATENATE function then filtering ...Creating a letter from template
Is it possible in CRM?
So far the only way i figured out to use templated is in an email and
/KB-article. (And order offcourse)
The thing i'm looking for is when selecting a contact, somehow i can make a
letter activity and call a template that puts name & adress data etc. After
that i should be able to print the letter, to put it in an enveloppe and send
So far it seems to me this cannot be done, but then again, i'm certainly not
a CRM expert...
Is it possible?
If so, can anyone provide me the actions to be taken step by step ?
"_Kas_&...Simple Question-How to create more than one transaction on the Acc
If there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...Creating a print-macro that'll only print page 1?
I have a spreadsheet that contains multiple sheets. I want to add a
button that runs a macro, which only prints page 1 on the first sheet
The "Scorekort" sheet contains 13 pages in total, but I only want to
print the first page.
Any ideas for this macro?
Sheets("Scorekort").PrintOut From:=1, To:=1, Copies:=1, Preview:=True, Collate:=True
if you don't want a print preview, Preview:=False
Le 2011-05-21 04:16, Anders M a �crit :
> I have a spreadsheet that contains multiple ...Email accounts are not created for new user
I had a severe system crash several days ago because of bad memory in my
domain controller (Server 2003 R2)/Exchange server 2003 (small site - no
extra systems). I had to reinstall Exchange 2003 and reload the exchange
store from backup. For existing users everything works great. Everybody can
send and receive email, the calender works correctly, etc. OWA works.
However, when I create a new user account in Active Directory Computers and
Users, the account is created and the new user can log onto a system.
However, Outlook 2003 cannot be configured to use the exchange server. In
t...Somehow I created a Macro in a worksheet.
I created a macro in an Excel worksheet somehow.
I didn't try to, it just happened. Now everytime I open that workbook, it
asks me if I want to run the macro, disable it, etc.
How the hell do I get rid of the macro? It doesn't show up under tools,
macros. And it apparently doesn't do anything either because I can disable
it and nothing different happens.
Who invented this system anyway?
When you record a macro, a module is created to store the macro code.
There are instructions here for removing the module that is causing the
prompt to appear:
http://www.c...Close Event for the Database (?)
Is there a close event for the database?
I have forms referencing other forms, and if the user closes
Access without backing out of the forms, an error message
pops up. It would be hand to just trap that error in an "On
close" event for the entire db. Of course that might be a
horrible thing when other errors are happening on close....
...we do not create seperate http virtual server anymore?
Just want to confirm that we do not need to create the seperate http virtual
server for FE/BE (backend two node A/P Exchange 2003 cluster), right? I
remember I need to create it in Exchange 2000 FE/BE clustering envir.
Thanks in advance.
On Wed, 2 Aug 2006 11:44:26 -0700, John
>Just want to confirm that we do not need to create the seperate http virtual
>server for FE/BE (backend two node A/P Exchange 2003 cluster), right? I
>remember I need to create it in Exchange 2000 FE/BE clustering envir.
>...Error creating new task
"Could not complete operation. One or more parameter
values are not vaild"
...clear up for Event/Mutex etc.
I am using: CreateMutex() / CreateEvent() to create Event / Mutex.
After program done. How should I clear up? Using CloseHandle()? Is it
required? or it just is close automatically when handle is out of the
Handle will be out of scope when your program terminates :)
So close them with CloseHandle(...) when you are done with them.
Microsoft - MVP
"kathy" <firstname.lastname@example.org> wrote in message
>I am using: CreateMutex() / CreateEvent() to create Event / Mutex.
> After program done. How...create main configuration file for solution.
How can I create main configuration file for my solution (Win-Form : VS
2008. VB.NET), like a general ini-file.
"Mr. X." wrote:
> How can I create main configuration file for my solution (Win-Form : VS
> 2008. VB.NET), like a general ini-file.
It's called an app.config. There is a name space you can use to mainulupate
the app.config from a program.
I see it on the project source directory (not for solution).
I cannot see it on the release directory.
Is there any convention to read / write from app.config...Creating Contacts For Accounts Using...
Hopefully as Microsoft CRM matures, many small time saving features will be
added. One that should be a priority is the ability to add a new contact for
an existing account using the common account information, i.e. address, phone
number, web address, etc. Retyping the same company address in each time is
not very productive. Thank you, Ed Podowski
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, f...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.
...Create individual files from a row
I have an excel file with several thousand entries, which contain data
in several columns. I would like to be able to create an individual
xml or html file for each row, but with predifined formatting around
Mr A bloggs, A street, A town, AA1 1AA
Could become Abloggs.html
<name>Mr A bloggs</name>
Any other info here as well
etc. Is this possible and any suggestions how?
GrahamN's Profile: ...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
...Viewing shared 2003 outlook calendar in 2007 Outlook
Shared calendars with colleagues who have 2003. I can see the calendar but
not the info in the calendar. Nothing is provate marked from their side and
is able to be seen by other 2003 users.
is there a quick fix?
...Saving MY Calendar into "Publication-Calendar"
My problem is that I have to make a certain type of calendar in every month. It would save lots of time forme if I could find a way that I could save my "calendar setting" and also be able to apply the new month's settings. There is any way that I could save my "home-made" calendar into "Publications-Calendar" and call it up just like the other calendars? Thanks.
If you have repeating items you just use the Merge for those items every
"If you don't know where you are going,
any road will take you there!"
I do not understand ho...Cannot create mailbox for new user accounts
I am running Exchange 2003 on Server 2003. I was able to move all existing
mailboxes from my old Exchange 2000 server to my new 2003 server. Whenever I
try to create a new user it creates the user normally and asks if I want to
create a mailbox for the user. I check yes, and it says account created
successfully. However, the mailbox never appears in Exchange, no email
address is assigned to the new user, and I cannot send mail to the user
account either. If I try to access any Exchange properties from ADUC it
shows everyhting as if a mailbox exists, but there is no mailbox. I am
...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <firstname.lastname@example.org>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...How do I create custom postcards in Word 2007?
I want to create my own postcards using the right size and type of paper for
This depends entirely on your printer. Can it handle the heavy weight
of card used in postcards, and can it handle the unusual size of a
On Apr 18, 2:54=A0pm, Create Custom Postcards <Create Custom
> I want to create my own postcards using the right size and type of paper =
Perhaps the easiest way to start is to get some Avery (or similar) postcard
stock, which will have two postcards per sheet. Then find the a...Scroll horizontaly with mouse, create same system used to scroll .
I think it would be great if mouses adopted a second scroll button, for
horizontal scrolling, just like the vertical one .... Indeed, when you work
with wide Excel spreadsheets, you can easily scroll down but to scroll from
left to right or vice-versa, you have to use the scroll bar or arrows and
So, am I a millionnaire yet???
> I think it would be great if mouses adopted a second scroll button, for
> horizontal scrolling, just like the vertical one .... Indeed, when you work
> with wide Excel spreadsheets, you can easily scroll down b...