report new page for each alpha
I have a report that produces an alphabetic directory, with the entries for
each new letter (A, B, C,) starting on a new page. I have one letter, U,
which has only one entry, and for some reason it is coming out on the last T
page (it is the only single-entry letter which happens to fall behind a
"full" page, where there isn't room on the previous page - but there are
plenty of other "short" pages where it correctly does a page break before a
letter. Any reason a particular letter (and it's not the only single-entry
letter) might not break pages proper...Page not found error when opening business portal
We're trying to install Invoice Approvals and Accruals 8.0, sharepoint
services sp2 and Business Portal 2.5 Feature Pack to work with Great Plains
We can install Sharepoint services and Invoice Approvals and Accruals ok and
they work fine
However, when we install Business Portal and browse to
We receive a "page not found" error screen
We've tried several things but nothing seems to work
Sharepoint services is installed in server farm mode and has been configured
correctly (as far as I can tell)
Any help would be great...How can I prioritize tasks by number in Outlook 2007?
I am trying to create a custom priority for my tasks in Outlook 2007, but I'm
not able to edit the field that was created when I changed the settings to
include a custom priority. I'm trying to put a number into it, so that I can
sort my tasks in a certain category by number, but I'm not able to.
We aren't watching you and your explanation is missing details.
Where in Outlook are you trying to view the Tasks? There are 3 places to see
If in the Task Folder, what View are you in? If in Tasks folder you
probably need to turn on in-line editing.
Judy Gle...Headers to remian visible
Have set up a master "Job's Completed List" listing all my different
jobs with various headers for various bits of information for those jobs.
The page is set up with 8 headers going across the top of the page and
the invoice numbers go down the right side of the page.
I would like to have these headers to remain visible on my work sheet at
all times. Right now I have scrolled down of the sheet and thus the
headers disappear. Makes for guess work and possible mistakes when
entering information into the proper column.
Select the leftmost cell below the header row, i.e. if r...Calculate number of months
I have a field where I am trying to implement a calculation. I want it to
take the date in a cell and subtract it from today's date to show me the
total number of months between those two dates. So right now, it looks like
=(TODAY())-D3 and it returns 167 - the total number of days. How do I make
it show me months?
THANK YOU IN ADVANCE
"TxWebDesigner" <email@example.com> schreef in bericht
> I have a field where I am trying to implement a calculation...I have a problem with getting a total Sum of numbers (URGENT)
I'd really appreciate if someone could help me here.
I am using Microsoft Excel 2002 on a Microsoft Office XP system. I a
trying to develop a minor league baseball schedule, but am having som
I have attached a copy of my spreadsheet to give everyone some idea o
what I'm doing here.
I have where the fans list the "RUNS, HITS & ERRORS) of both teams an
for each game of the series. I then have it set up in the TOTA
WON/LOST column where if the T-Bones RUNS are more than the SALTDOG
runs, a "1" appears in the WON column. If the SALTDOGS have a highe
numbe...Page Setup #4
I set up a document for dimensions to be 8x11, save it and close it. The
next day I open that same document and find that it has gone back to the
default settings of 8.5x11? Would anyone know how I can avoid this risky
Chips and Charlie
Is your stock actually 8 inches? If it is you must setup your printer for 8 X 11
as well as your page setup.
Mary Sauer MSFT MVP
"Chips and Charlie" <ChipsandCharlie@discussions.microsoft.com> wrote in message
news:E619DDBA-9FF3-4E26-8D3...How do I enter the character '&' in a custom header?
Can anyone help me with this?
Use two of them:
> Can anyone help me with this?
> Can anyone help me with this?
That works! Thanks for your help!
"Mike R" wrote:
> Try &&
> Mike R.
> "toolman" wrote:
> > Can anyone help me with this?
...Load Last Page
I know you can "load first page" In CRM. Is there a way to Load LAST page
instead of having to load each page?
The easiest way is changing the sort order (click on the appropriate column
header). This then displays the "last" page. It's not exactly the same
Michael H�hne, Microsoft Dynamics CRM MVP
CRM Blog on http://www.stunnware.com
"Bernardina" <firstname.lastname@example.org> schrieb im Newsbeitrag
>I ...Saving one page -- as Template?
Therre are several pages in a 40-page booklet I want to save to use in future
Is there a method to save these pages for re-us?
Or must I save the entire publication as a Template?
Can I copy single pages and paste in another .pub file?
Save the entire document and delete out the pages you don't want.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"cuig" <email@example.com> wrote in message
> Therre are several pages in...4 page publication onto a website
I am trying to put a 4 page publication on to the website so that it can be
opened by people who don't have publisher. I managed to do it last month but
for can't remember how I did it. When I convert it to a web page it only
shows the first page of the publication.
Last months issue, when I checked back is a mht.doc but I don't know how I
converted the publisher document to this.
Can anyone help please?
How about converting the Publisher file to a PDF. This way more visitors
will have the capability to view it.
Many folks here recommend the free primopdf which can be ...number in system using arrivals and departures
Is there and easy way to figure out the total number of persons in a system if have access to the arrival and departure times. I have tried to use counts with if statements, but I keep getting the number 1. I know this is not correct. Is there any special macros or functions
you may provide some more details about your data. Could you post some
example rows (plain text - no attachments please) and describe your
> Is there and easy way to figure out the total number of persons in a
> system if have access...how would you calculate the number of hits to your website
can some one tell to me the answer of this question
On a website, how would you calculate the number of hits to your
...how to have my titles move down as i scroll down the page
hi what i want to do is have the top line of the exel sheet move down the
page and stay in veiw so i can easily see which field i am currently woorking
on. can anyone tell me how to do this?
Click on the last row of heading (or row 1 if there is just one row)
Use Windows Freeze
Bernard V Liengme
remove caps from email
"DAVIDPEOVER" <DAVIDPEOVER@discussions.microsoft.com> wrote in message
> hi what i want to do is have the top line of the exel sheet move...columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and
forumlas now look like =RC[-1]*R[-3]C
I was trying to make the R[-3]C static (using the $) but it errors.
In Excel Options uncheck "R1C1 Reference Style"
Gord Dibben MS Excel MVP
On Thu, 28 Oct 2010 20:25:30 -0400, Mike <firstname.lastname@example.org> wrote:
>I noticed my excel clumns have changed from letters to numbers and
>forumlas now look like =RC[-1]*R[-3]C
>I was trying to make the R[-3]C static (using the $) but it errors.
...A way to increase a number in a cell by using the + key
Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
Item 1 Item 2 Item 3
2 5 4
I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.
Any assistance would be appreciated.
That would require VBA
How far are you will...reference number #2
Where does the information in the "reference number" field in the
transaction table come from? I see tranactions with reference numbers -
the first part of which appears to be the year, month and day - but I
can't figure out the second part. It is nothing that we have
intentionally entered while ringing out the customer. Pls help.
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
microsoft.p...number changes to date ... how do I change
I am trying to do an "age" range:
Instead I get September 9, 2004
or October 19
I can't figure out how to change it.
Please help! Thank you!
Change the type to Text, and it should keep everything the way you want
it. If you don't specify a type, Excel takes a guess based on what you
Hope that helps.
Message posted from http://www.ExcelForum.com/
...Add numbers accross columns after stripping away text
I have the following data in a spreadsheet:
A1 B1 C1 D1 E1 F1
4.5f 6f 3.5f 3f 7.25f
I need to be able to add the numbers together to give me 24.25, i.e. strip
the fs away. The numbers will always be less than 10 and the there will only
ever be .25 or.5 or .75 after the number (I don't know whether that is
If anyone can show me how to do this I would be very grateful. I have been
messing around with MID and FIND to no avail and then started thinking that
SUMPRODUCT might have to get involved but it all got a bit m...Random numbers, Canadian Zip Code style #2
Honestly, I don't even know where to begin
Shocked's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1489
View this thread: http://www.excelforum.com/showthread.php?threadid=26523
Is it possible to have a two page form and only print the first page or
second page when needed.?
Depending on your design, you should be able to use the File/Print dialog
selection to print 1 of 2, or 2 of 2 pages.
But, forms are made for data entry, and viewing... not printing. Better
that you develop a rptPageOne and a rptPageTwo and select either for
printing from your form.
Microsoft Access MVP
"Find a job that you love... and you'll never work a day in your life."
&quo...Add Spell Icon to tool bar.
I cannot find the Spell Checker Icon in any of my pull down menus or add
buttons list. Where is it and how do I instal it on my tool bars in Outlook?
It is only available using Word as the editor in Outlook.
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 without
After furious head scratching, Tazz asked:
| I cannot find the Spell Checker Icon in any of my pull down menus or
| add buttons list. Where is it and how do I instal it on my tool bars
| in Outlook?
...Print multiple tabs on one page
How to print multiple tabs in excel onto one page in one print job? Tab1 and
tab2 have different format and cannot be combined into one tab. Need to
print the two worksheets one on top of each other is the same direction.
Tried Report Manager but printed on two pieces of paper. Any suggestions?
One way to accomplish something like this is to play around with "pictures".
I'm on an XL97 machine now so,
When you hold down <Shift> and hit <Edit>, you get a different dialog box
.... one that contains "picture " options.
So, select an entire sheet, or p...Can VISIO 2007 work on multiple pages of an org chart simultaneous
I created an org chart with over 100 pages using the Org Chart Wizard and
Excel, I’m assigning colors to various shapes using the Data Graphic feature.
To apply the colors I choose “Edit” then “select all” which selects all the
shapes on the current sheet, then I select “Apply To Selected Shapes” from
the Data Graphics pane, this works fine for the current sheet but is there a
way to apply this to all the sheets at once. Thanks
I've written a macro for you to try in my blog...
See Applying Selected DataGraphic to the Whole Document -
http://bvisual.spaces.live.com/...How do I do a Print Preview of the "Current / Active" page on a fo
I have attached a command button to a form and when I press the button it
brings up a print preview of the report attached to the form. The problem is
that it always shows Page 1 of the report as the default page. I can then
only navigate to theother pages in the report by clicking the page arrow at
the bottom of the report. How do I code the button so that when I click the
button it shows a preview of the "current" record rather than always showing
the first page of the report as the default page? I want to use this so that
once people have completed filling inform...