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...change horizontal header position in excel
Anyone know how to change the horizontal position of the HEADER or FOOTER in
EXCEL???? I would greatly appreciate any help. Thank you for your time.
> Anyone know how to change the horizontal position of the HEADER o
> FOOTER in
> EXCEL???? I would greatly appreciate any help. Thank you for your time.
Can't you go into View/Header-Footer and use the "Left-Center-Right"
catagories? You could use spaces in front of your data to move back an
Piranha's Profi...auto number index snafu
I have a 2003 DB I've been adding to for 2 years. It's at 423 records =
I export to a PDF for simpler searching and viewing.
Using the search the other day, I went to grab DVD 186, on carousel tower=
And what came up didn't match the record.
The index was totally screwed.
I went thru all 423 records and created a numeric index by hand. The auto
number field is useless.
But I would still prefer an auto number field.
Trouble is when I create the auto number field, it's still off the actual
numbers of the records..
ie: 99-100 is actually 99-186,187, 188, 189 100-385,...Sequential ticket numbers and printing 4 to a page
i have mail merged my numbers from excel into my publisher ticket. Thanks
that worked well, now i want to print 4 tickets to an A4 page and in print
preview, i get 4 tickets all with the same number on one page. how do i get
Print preview showing all the same is a bug. Print a test page.
Mary Sauer MSFT MVP
"Neyol" <Neyol@discussions.microsoft.com> wrote in message
news:90034D4C-9951-4550-9DAC...Dates in fomula showing as whole number
I have a fomula in a cell that takes the name of a person (from cell 2B),
their License number (from another cell 2C)and the Date that License Expires
(From cell 2D). The expire date in "2D" is either the word "none" or a date
that that persons license needs to be renewed.
Those instructors with "None" come out in the calculated field fine, however
the ones with dates come back as whole numbers, Example 8/6/10 shows 40396.
any help will be appreciated
You need to change the format of that cell or column, highlight the cell or
the column, right click o...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...Is it possible to set a slide transition that mimics turning page
I've been asked for help in setting up a PPT presentation to have slide
transitions that mimic turning pages. I have seen this done using Keynote on
a Mac but the software being used for this presentation is PowerPoint.
Any ideas on if this is available or where I may find a download to add to
The setting I use to achieve that is:-
Animations tab / Transitions to This Slide group / Wipes / Strips Left-Up
If my comments have helped please hit Yes.
> I've been ask...Why is Excel changing the last 2 digits of a 17 digit num to 00.
When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to
00 when I leave the cell. Format - Cell does not have a setting to stop this
'feature'. How do I make Excel recongize the large number?
On Thu, 28 Jul 2005 19:09:01 -0700, "Allie" <Allie@discussions.microsoft.com>
>When I enter a 17 digit number in a cell in Excel, the last 2 digits turn to
>00 when I leave the cell. Format - Cell does not have a setting to stop this
Excel Specifications and Limits:
Feature Maximu...Detect page change in PropertySheet?
Hi, I have a property sheet that is the parent of several property pages. If
the user clicks a tab to change to another page, is there a way I can detect
this (and possibly prevent the change) in the PropertySheet dialog? Does
windows/MFC send any kind of message to the PropertySheet dialog?
I looked at all of the over-rides and WM_ message, but cannot see anything.
Not directly. You can catch that in the CPropertyPage and relay the message
to the CPropertySheet. (I know you are asking, why doesn't the
CPropertySheet get the notificatio first? who knows!)
"...Changing e-mail address
dI´m trying to change mail-address in AD-Users and computer.
From "firstname.lastname@example.org" to "email@example.com", but it won't work.
On the tab "e-mail Addresses" i try to set "firstname.lastname@example.org" as Primary, but it
don't stay that way. If I open directly and check it seems right, but close
and do one more client, the first has change back to "email@example.com".
What am I doing wrong ????????
You will need to uncheck the checkbox "Automatically update e-mail addresses based on recipient policy" for the change to stay.
Also make sure that you ...... I want to change a chart type ...
I have a "Line - Column" chart in my spreadsheet.
My Bars represent the month which is in a Linked Cell.
The Value of the Bars is a Dollar amount from a Linked Cell.
The Line represents a Target Dollar Value.
I would like to add a second line that would represent a count from a linked
range of cells.
Can I edit my existing chart, or do I have to create a new one? Could you
give me a few pointers?
Select and drag the new column onto the chart. In the resulting dialog
box, ensure you specify 'new series'. Once XL finishes adding the
series, if it is not the...Changing fonts in msgbox
If i create a msgbox with a prompt, can i change or modify the font of
the text in the msgbox ?? Ditto Inputbox....
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You can't change the font used in a MsgBox. This limitation is one of the
prices you pay for the simplicity of a MsgBox. If you need to change the
font, you need to create a UserForm and display that form instead of using a
Microsoft MVP - Excel
www.cpears...Change of field separator
When I open CSV files in Excel all data is put in one column. Can anyone tell
me, where I change my set up, so I get another field separator? Please be
specific, because my Excel is a Danish version, and sometimes I have a hard
time following the English instructions. Thanks!
you specify this in the Windows regional settings. Another idea:
- rename your *.csv file to a *.txt file
- now open it with excel. The Import wizard should appear and should allow
you to specify a different delimiter
> When I open CSV files in Excel all data is put in one co...Color not working
I am operating Windows 2000, using Office Pro 2003. I am
no longer able to format my cells with colors, either
shading or text coloring. I have run the repair feature,
but it didn't work. Bold, Underline, and similar
functions still work.
Have a look at this:
Changes to Fill Color and Fill Pattern Are Not Displayed
>I am operating Windows 2000, using Office Pro 2003. I am
>no longer able to format my cells with colors, either
>shading or text coloring....Paper settings change for specific printer
I just installed access 2007 and my application uses reports to print labels.
Specifically a Dymo turbo 400 and 30252 address labels. when i was using
acess 2003 i specified to use a specific printer and everything was great.
and when i copied updated FrontEnds to my networked computers every thing
transfered and the labels printed fine however with 07 the "Specifc printer"
has a different page size.. i fixed all the reports on my master FE but the
changes didnt stay when i copied FE to other computers and im not sure where
to go. i installed all the printers from the s...matching columns of numbers
In EXCEL 2000 for Windows, I have two columns of numbers. Column A has
500 numbers, Column B has 1000 numbers. I need to know which cells in
Column A have a match in Column B, and if so, what is the Cell (or row
number) in B that matches to that particular cell in A. How can I do
Thank you for your help.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
try the following:
- insert a new column between A and B (so make B the new C column)
enter the following in B1
=IF(ISNA(MATCH...Ordering by number and text
I use a report to print out checklists that in the detail section have item
number to delineate each checklist item. The item numbers as an example are
1-1, 1-2, 1-2a, 1-2b, or 2-1, 2-2, 2-3, 2-3a, 2-3b and so on. The report is
grouped by checklist section and the grouping works perfectly but when the
report is printed the item numbers are ordered in this order 1-1, 1-10, 1-11,
1-2, 1-3, 1-3a, 1-3b, 1-4, 1-5, 1-6, 1-7, 1-9.
Obviously I want the the order to be in proper numerical sequence where 1-10
comes after 1-9. but even replacing the '-' with a decimal point doesn't
...Zero filling a number field
I have an auto number field that I want to zero fill to six digits but
can't figure out how. Any ideas?
You don''t say where you're trying to do this, but basically
>I have an auto number field that I want to zero fill to six digits but
>can't figure out how. Any ideas?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
You can't do that wi...How do I change numbers to negative without re-typing?
I have a large range of data that needs to be changed to negative numbers,
Can I do this in Excel?
...Determine number of rows with data
I am using the macro below to pull some data from an external workbook.
The 2 issues I need to sort are:
1. The number of rows in the external workbook can vary. How do I amend this
code to pull all of the rows with data?
2. The number of rows in the autofill also may vary. How do I autofill only
the number of rows required? i.e the number of rows in column A that contain
'Lookup Previous Month Sales
Selection.NumberFormat = "General"
Selection.FormulaArray = _
"=S...How to Change Outgoing port in Exchange 2003
I am running Exchange 2003 on a SBS 2003 server and using the POP3 connector
to get the e-mail from my account and also send the email out throught the
SMTP server. Starting last Friday the outgoing mail is not being sent.
Earthlink tells me that they are now using port 587 for the outgoing mail.
How do I change the outgoing mail SMTP port? Thanks
On Mon, 26 Jun 2006 09:07:02 -0700, Don Holden
>I am running Exchange 2003 on a SBS 2003 server and using the POP3 connector
>to get the e-mail from my...grayscale autoshape changes to color when converting to PDF
When converting from Microsoft Publisher 2007 to Adobe Acrobat 8.0 PDF, the
autoshape picture that we changed to grayscale changes back to color when
reviewing the created PDF.
Are you setting Acrobat to print in black and white? Select the PDF printer,
properties, paper/quality tab.
Mary Sauer MSFT MVP
"CDJ" <CDJ@discussions.microsoft.com> wrote in message
> When converting from Microsoft Publisher 2007 to Adobe Acrobat 8.0 P...Highlight color for selected items
How can I find out what color is used for highlighting
selected items (for example in Windows Explorer)on a users
Normally it is a blue color, but a user can change that.
"Urban Olars" <firstname.lastname@example.org> wrote in message
> How can I find out what color is used for highlighting
> selected items (for example in Windows Explorer)on a users
> Normally it is a blue color, but a user can change that.
See if it's GetSysColor/COLOR_HIGHLIGHT.
Jeff Partch [VC++ MVP]
Take a ...Converting number to text
Is it possible to convert, say 1234 to one thousand two hundred and thirty
There is no direct functions to convert this. For a VBA solution check out
the below links
Jacob (MVP - Excel)
> Is it possible to convert, say 1234 to one thousand two hundred and thirty
...Outlook changing PDF extention to PDF=
I have a client that uses Outlook 2000 for e-mail. About a week ago,
she started complaining that everyone that she sent PDFs (Ex.
Document.pdf) that they were receiving PDF= (Ex. Docuement.pdf=). This
is only happening with PDF files, not word documents or anything else.
I have tried to change the outgoing mail server, but that made no
difference. Is there something in Outlook that can be causing this?
is she using RTF formatted messages? Antivirus or antispam scanners on
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2...