Getting appts to print on one page
I am using calendar assistant to print multiple overlaid calendars at once on
letter size paper.
All the appointments show up on the first page, except for one. This one
pushes to a second monthly page duplicating the first.
ie - I get two November 2009s - one with all appts except one and the other
page with only the one rogue appointment
...Tab control question about updates
Searched but couldn't see this discussed.
I have a form with 5 tabs.
Data can be loaded three ways, manually entered, imported from a text file,
and imported from a Word template.
On one of the tabs (the second) when the user enters information such as a
social sec. number (SSN) that matches a file already in the system, a flag
goes off and alerts the user. Works fine.
On the import functions, the data is loaded and appears correctly, but when
the user moves to the second tab where the SSN number appears, it does not
set off the flag when the page opens.
I can make it happen with a c...combining tabs through drop downs
I'm not even sure if this is possible, or how
easy/difficult it would be, but if someone could at least
tell me where to look or what I need to start researching
to be able to do this it would be great.
Basically, I want to take a workbook that has 10 tabs -
each of the tabs has similar formatting, but different
info. What I want to do is combine it all onto a single
tab and use a drop down to select what info is viewable.
ie - rather than having tabs for june, july, and august,
those would be drop down choices.
Keeping in mind that the info for each is similar in
formatting, but not e...Powerpoint 2007 Excel import change tab
The situation is as follows:
Powerpoint template needs to import data from specific fields from
within a tab in excel.
This tab name changes depending on the client.
Using the "paste Special" i can get the info imported fine. The part i
have a problem with is changing the name of the tab to import
different data.Powerpoint doesn't have an option under "Prepare>Edit
Links To file"
If anyone can suggest a solution even a macro to prompt the user to
enter the name of the new sheet they want to pull the data from.
The Execl file does not change
...Printing odd pages in booklet format
I used to be able to do this easily in PageMaker, but I can't figure it out
for the life of me in Publisher...
I am creating a booklet. Each page is 8.5 w and 5.5 tall (ie, half-letter,
landscape orientation). I'd like to print this booklet two pages to one
peice of paper, so I can cut in the middle and punch for a ring binder. I'd
like the target paper to be letter (8.5 x 11).
However, when I try to set it up as a book, I get a weird page that's
17x5.5. How can I change how the page is set up, so I can get both 8.5 x 5.5
pages to print in the correct orientation on the...Hyperlinks into VISIO page
While it is possible to link from one visio document shape to another visio
file, specific page, I am unable to find or determine (based on testing) the
html syntax for connecting from a hyperlink in a different kind of document
(like a word or excel file) to a specific page. The default seems to be open
to whatever page was last saved. Does anyone know the proper tag for creating
this link? #bookmark works for all other microsoft products, but doesn't seem
to work for VISIO? Thank you.
(and yes, I have already read all the topics in all groups and find no
answer - this is the third...Publisher 2007: How do I change dates on calendar page in newslet
I'm creating a newsletter. I added a calendar page. In previous versions of
Publisher, I was able to get to Calendar Options to change the month. In
Publisher 2007 when I insert a calendar page into a newsletter, I can no
longer access the Calendar Options task pane. Please describe how to change
The calendar wizard is broken. Hopefully it will be fixed in a future service
pack. Meanwhile you will have to manually change the calendar dates.
Mary Sauer MSFT MVP
"Stephanie" &...Front Page 2003
I have just had my old laptop data transferred to anew laptop and on
attemptiing to load Frontpage 2003 i am told they found that the disc was
cracked and unusable.
I have 2002 Version which is now loaded but wish to upgrade to get back to
2003. i cannot appear to find a copy of Frontpage 2003 which I can download
anywhere (I have my product key is it is all legal) - has anyone any bright
ideas how I can get aroud this problem and where I can get a copy of 2003
You might find a copy on E-Bay or Amazon.
FrontPage is no longer supported ...SFO CRM folders won't display page
SFO appeared to install correctly. The CRM toolbar buttons work fine in SFO.
But when I click on a CRM folder such as accounts, I get the following Action
Canceled error. I am running CRM 1.2 and this is on a Windows XP client. I
have installed the SP2 and SFO enhancement patches and cleared forms cache in
Outlook. I also uninstalled and reinstalled SFO. SFO works fine on all other
laptops within our organization.
Here is the error which occurs when I select any folder within SFO/CRM.
Internet Explorer was unable to link to the Web page you requested. The page
might ...Hide Picklist based on value of other picklist.
On the accounts form i have made a new picklist named Partner.
In the picklist Customertype i have made a new entry called partner.
When someone opens the form i want the picklist named partner to be hidden.
When someone selects Partner in the Customertype picklist i want the
picklist partner to be visible. If an other value is selected the fields
needs to stay hidden.
I know i have to make some code on the onchange of the field customertype
and i need to make code on the onload of the page.
I have tried multiple codes but i cant get it to work.
Can someone please help me out please.
Hi,...Hide Quck Parts in Word 2007
Is it possible to hide empty quick parts in word 2007?
I am populating quick parts from a sharepoint list (wss 3.0) and some of the
fields in this list are not rquired and the field names are showing when the
metadata is empty.
.... again ... but none of the answers I can find is useful ...
The documentation for CPropertyPage::OnWizardNext says you can insert a page
// Since CPropertySheet() always adds new pages to the end of
// its propertypage list, we have to remove all pages starting
// at index 1 (original location for the second page). Then,
// add them back one at a time.
for (int i = 1; i < count; i++)
for (i = 1; i < arr_size; i++)
However this doesn't work. The reason it doesn'...P2002 S-L-O-W on Page Change
Recently "upgraded" to Publisher 2002 from Publisher
2000. A three-page document now requires about 45 seconds
to switch from one page to another. One of the pages has
about 12 text frames and 3 photos. I copied the file and
removed all frames. Same delay. (And this file, that now
has no visible content, has a size of 2.2MB.)
This behavior is identical on two machines (removed 2002
from one machine and installed on another.) First machine
is W2K, 600MHz, 256MB. Second is XP, 2.3GHz, 512MHz.
Is this video related? Both machines have 64MB display
cards. All Office, OS,...Rotating page numbers
I have a document with both page layouts (landscape and portrait)
however the page numbers obviously will be pointing in the direction of the
does anyone know how to be consistent in this?
...Hide a field in a report
I am building a report using fields that are in tables. One of the
fields in the report is "Do Not Use". I want to build an expression
that says if "Do Not Use" is marked "1" in the table, then remove that
line from the report. If "Do Not Use" is marked "0", keep that line
in the report. Please help! Thanks!
In your query use a calculated field like this --
Hide_Field: IIF([Do Not Use] = 1, Null, [Do Not Use])
Then in the report set the textbox Can Grow property to Yes and drag the
size of the textbox to a hairline. If the output is...Set print width to page width in VBA
IF I set the width, e.g.
ActiveWorksheet.PageSetup..FitToPagesWide = 1
It automatically makes it 1 page tall, not good on long sheets, how do
I set it to scale 1 page wide and however many pages tall?
A)bort, R)etry, I)nfluence with large hammer.
I recorded a macro when I did it manually. These are the lines that I'd keep:
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
Trevor Best wrote:
> IF I set the width, e.g.
> ActiveWorksheet.PageSetup..FitToPagesWide = 1
> It automat...Publisher does not recognize tab-delimited text files in a mail m.
I am a student who is learning MS Publisher 2003. In mail merges, publisher
does not recognize tab-delimited text files. If you try to mail merge with a
tdt file, the data appears as one column entry, making it impossible to sort
by separate fields or insert separte fields as a formally formatted address
block. Converting the file to a comma-delimited text file (comma separated
values) solves the problem. The fields appear separately as they should in
the Mail Merge Recipients dialog box, so that you can sort by separate fields
and then set up a properly formatted address block. Pl...How to assign value to controls on a Report
I am trying to assign value on a txtbox control from a form to a txtbox
control on a report.
Form txtbox control:txtBeginDateRange
Report txtbox control:txtStartDate
reportName = "Report by DR and Vendor"
I am have a problem with this line of code
Reports![reportName]!txtStartDate = Me.txtBeginDateRange
DoCmd.OpenReport reportName, acViewPreview
Any help will be appreciated. Thank you.
Answered in another post where you asked the same question.
...move page from one document to another
I need some "fast" help! I have never worked in Publisher before, but need
to get a project done for an organization I work for.
I need to take several pages from one document and paste them into another
document. Both documents are already set up in Publisher. I want to
basically "copy" from one document to another.
kdramirez <firstname.lastname@example.org> wrote:
>I need to take several pages from one document and paste them into another
>document. Both documents are already set up in Publisher. I want to
>basically "copy&qu...Chart Legend Items: hide/show
How do I hide/show a series on a chart legend (scatter plot.)
I tried a null string (""), but the trace still shows. I also tried #N/A.
But it then shows "#N/A"; the same with function: NA(). What I am trying to
do is to have a control button to show or hide a series from the chart. I
can set all the series values to #N/A which hides it, but I am having
trouble trying to hide the legend for the series. I also tried an "if"
function in the chart->series dialog, but It evidently will only accept a
"Jon Peltier" <jonREMOVExlmvp@p...How do I get the printer to start at a spicific page.
Sometimes when printing pages for a 100 page book a page may jam. I try to
start printing from that page to the end. It always wants to start from the
first page instead of the 20th page. How do I get the printer to start
printing from that page that was jammed and continue?
> Sometimes when printing pages for a 100 page book a page may jam. I
> try to start printing from that page to the end. It always wants to
> start from the first page instead of the 20th page. How do I get
> the printer to start printing from that page that was jammed and...Emailing a multi-page newsletter as the message
This is an advance notice of something I need to put into writing. I found a
terrific way to send a multipage newsletter as the body of an email. It is
not completely free tho. You need some sort of pdf creating software (free
will work), and a $40 software program. Believe me, this will be the best
$40 program you've ever purchased.
Look for something later this week. Right now I have to prepare a mailing
list with 1700 people for a mail merge. I'm a bit busy right now. ;-)
MVP Microsoft [Publisher]
JoAnn Paules [MVP] <email@example.com> was ve...How do I get the pages into the bottom toolbar in publisher 2007
In the older version of Publisher the pages of a document appeared in the
toolbar at the bottom of the screen. In the 2007 version I don't know how to
turn that on. How do you navigate between pages?
Not too long ago another poster offered the following solution. Please note
that I haven't had this issue and haven't tried this solution but it seems
to have worked for him.
To fix the Publisher page sorter issue, simply follow the steps below. But
beware, because this fix takes you into the Registry window to edit a
specific part of the P...Office System 2010: List of Controls IDs
Does anyone know when or where Microsoft will publish a list of control IDs
for the Office System 2010?
Does anyone know the idMso for the "Print" command located on the new "File"
See my web site http://gregmaxey.mvps.org
for an eclectic collection of Word Tips.
Arrogance is a weed that grows mostly on a dunghill (Arabic proverb)
This is a multi-part message in MIME format.
Content-Transfer-Encoding: quoted-printable...Member Server to Domain Controller
How do I promote a member server running Windows 2003 Server SP2 and
Certificate Services to a domain controller.
Use the system command dcpromo
Check out the link below
MVP - Directory Services
MCITP - Enterprise Administrator
MCTS, MCT, MCSE, MCSA, MCP, Security +, BS CSci
2008, Vista, 2003, 2000 (Early Achiever), NT4
Microsoft's Thrive IT Pro of the Month - June 2009
Please no e-mails, any questions should be posted in the NewGroups. ...