my printer won't print page 2 of my brochure in publisher.
I am making a brouchure in publisher and it includes 6 scanned pictures on
the 2nd page. whenever i try to print it out the printer will only print page
1 but not page 2 How can i get this page printed.
What printer? What version Publisher? How large is the file? Have you tried updating
your printer driver from the manufacturer's web site?
Are you using a HP printer?
PUB2000: Cannot Print Photos to HP DeskJet Printers from Publisher
Mary Sauer MS MVP
http://www.msauer.mvps.or...Mystery price changes-anybody experienced????
When I have been updating items in Manager, sometimes the price from the
previous item automatically populates and changes on the next item. Has
anybody experienced this? Very frustrating. Any suggestions?
Apply the latest hotfix for RMS.
This will resolve the issue.
"knightsbridge" <email@example.com> wrote in message
> When I have been updating items in Manager, sometimes the price from the
> previous item automatically populates and changes o...duplex printing question, change record order to line up with other side?
i have a report that i need to make the opposite side match up with the correct record. it is setup to print 4 records, 2 across then 2 below. like 4 post cards on a landscape page. records for each customer need to match up with the mailing address on the reverse side. so the records are switched if i were to make the report right now. basicly records start 1 and 2 on the top of the landscaped page then 3 and 4 under. so on the reverse side records need to be 2 and 1 then 4 and 3 under. i havent made the opposite side for mailing address yet. i need some info on how i need to do this....filter form on value from linked table
Is it possible to filter a form (based on table A) on a value in a table B
where the tables are linked?
I would like to filter the form records (Table A) by using as input the
company name (or part of it) from a textbox.
Message posted via AccessMonster.com
Sorry for this but I forgot
I would like to use like
as I already use it to filter the form based on values from another txtbox on
Message poste...Change date format on report
My date displays as mddyy in the table but on the report I'd like it to
display as mm/dd/yyyy, how would I code that to have that field always
display in mm/dd/yyyy format. I'm thinking this is very simple but I just
can't get it to work for me.
Thank so much for your help.
On May 2, 1:50 pm, SITCFanTN <SITCFa...@discussions.microsoft.com>
> My date displays as mddyy in the table but on the report I'd like it to
> display as mm/dd/yyyy, how would I code that to have that field always
> display in mm/dd/yyyy format. I'm thinking this is very simple...Why does spell check change to English(US) on replies/forwards?
My default language is set to English(UK) spell checker reverts to
English (US) when replying or forwarding messages. How can I change this so
it is always English(UK)?Cheers,Tom
...Reset field based on the the results in another field
I have a picklist field on a form and a field that is using the radio button.
When the user changes the selection on the picklist field to "completed",
the value of the radio button field. If the field is set to no,an alert pops
up to the user.
The picklist field should then reset back to the previous value. I have only
been able to get
the code to set the field to 'blank' (not acceptable).
doesn't something like this do the trick:
in the onload you capture the value of the picklist when the form is loaded.
and yo...Query: Link data between worksheets?
I'm trying to find a shortcut to save me some time.
This is the problem:
I'm setting up a master worksheet, and 30 to 40 "slave" worksheets tha
need to run off it (all within the same workbook). The slave worksheet
all retrieve data from the master. The data is setup to run across i
rows (i.e. Row 1 contains 1 record). Each record has an individua
identification number entered in column A.
Is there a way that I can tell the slave sheets to copy an entire row
based purely on the identification number entered in column A?
Thanks in advance if anyone can help, as this could ...Sumproduct
I am using Sumproduct with three variables (Person, Product and Month).
I am using data validation lists for the end user to select the person,
product and month. I would like to be able to add a "Total" to the person
list so that when the end user chooses "Total" and a product and month that
the Sumproduct would only use the two other criteria (Product and Month) and
be able to see the totals of those criteria for all Persons.
I know I could nest IF THEN statements with the Sumproduct, but is there a
Appreciate the help!
No, an IF/THEN m...Combo Box changes after Microsoft Upgrade.
I have WindowsXP and Access2003.
I have a Combo Box on a form used for finding
a particular record.
After downloading and installing the
(Office 2003 Service Pack 3 (SP3)), one of
the columns (a text) Combo Box is blank.
This remains blank even if I create a new
Also, going back to a application backup I
made in January2007, this column has become
The Office 2003 Service Pack 3 (SP3) is the
only event which has occurred.
Please help, Frank
And, you've hit the nail on the head. It is SP3 which is causing this issue.
From what I u...Filtering data on subforms
How can I filter data in a subform?
The subform is a datasheet linked to a parent form (field)
On Fri, 8 Jun 2007 22:37:14 -0500, "Alberto Rios" <firstname.lastname@example.org>
>How can I filter data in a subform?
>The subform is a datasheet linked to a parent form (field)
Base the subform on a Query selecting the records you want to see.
John W. Vinson [MVP]
I want to set data validation on a cell so that it will accept the following
(and only the following) text strings:
(1) "BR" (literally)
(2) "NT" (literally)
(3) "nA" where n is any positive integral numerical value including zero and
A may take any of the values "L", "P", "T", "V" or "Y"
(4) "An" where n is any positive integral numerical value including zero and
A may take either of the values "K" or "D".
Is this possible, please, and if so how? thanks
Return e...Importing Data into Existing Pivot Tables ?
Can anyone tell me if it is possible to *import data into an existin
pivot table *(possibly from a excel spreadsheet(refresh) or with
query to a Access database table) **I need to do this daily with
pivot table if possible ! Thanks in advance !
jman559's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2945
View this thread: http://www.excelforum.com/showthread.php?threadid=49157
...Combo Box on Forms
I am using a combo box on a form that has several items w/ one being
Other. If the user selects other I want them to be able to input what
they want so that it will go into the table instead of just the
"Other". I just am not really sure on how to do that. Can you help?
In design view click on VIEW - Properties and the the combo. Then change
Limit To List to No.
Build a little - Test a little
> I am using a combo box on a form that has several items w/ one being
> Other. If the use...Forms: can a cell itself be clickable?
Hi! I'm trying to create a form for my boss. I'm using the forms toolbar,
but what it does is throw in a check box for instance, but if I change the
cell in any way, the "picture" of the click box stays where it's at. Any way
to change this?
In other words, I don't want to the click box to be a picture, I want it to
be an integral part of the cell, so I can modify it as needed (ie. place it
centrered horizontally or vertically etc.
Am I dreaming in colour?
I've seen a macro that will insert a checkmark when you select the cell, but
I...Can't Use Outlook after changing Servers
Moved users from one server to another. Users map USER folder to U:\ drive,
no chnage there. After move when trying to open Outlook it stops with an
error that there is a security problem with the .pst file. There is none I
can find. Tried deleting Outlook profile for user and installing a new one,
came up with same pst file. tried adding a second pst file and get the same
security violation, No other files have problems, WORD or Excel.
...How to change the year?
I have a date column in my work sheet where I have enterred the year as
2005, but actually should be 2001. The cell format is date-month-year. My
date range is B5:B55. How can I change the year on only for the dates in
this range. Thanks.
The difference between a 2001 and a 2005 date is 1461. So do this: Put
1461 in a cell. Copy. Select B5:B55. Edit - Paste Special. Click
"Values" and "Subtract." OK.
"la90292" <email@example.com> wrote in message
news:ebnzG62qFHA.3720@TK2MSFTNGP14.phx.gb...Pagination on a Continuous Form
I would like to have one continuous form hold a list of 30 records per page,
and be able to see the page numbers (and use them) at the top and/or bottom
of the form, such that a total of a couple hundred records (or more) can be
displayed in groups of 30 at the request of clicking the page number (similar
to that of a webpage, but only an MS Access Form).
On Fri, 5 Mar 2010 11:23:01 -0800, VWP1
You'll have to do all the work yourself, because such interface is not
natively supported. Would be an interesting project though.
-To...IE cannot display web page
I'm using WinXP and IE7 on one computer and WinXP and IE8 on another. Both
are fully updated--the OS and Flash and Java.
Neither computer has been able to display one website. It's for a light
fixture store; and when I phoned the store today, the people who work there
said they use WinXP and IE and the site displays just fine (although someone
else told them last week that the web page couldn't be displayed).
Any idea how I can get to this site? It's
It doesn't display for me, both on my Win7 machine ...Cannot delete extra page
I am working on a resume that was created using an earlier version of Word.
It is two pages long but the document has a third page. When looking at the
document with the paragraph information there is a paragraph on the third
page but when I try to delete it I cannot using backspace, delete or any
highlighting options I can find. Is there any way to just delete a page,
without using formatting? I really would just like to save pages 1 and 2 as a
pdf. It looks really bad to send a resume in a pdf with an extra page. I
don't want to create the impression that I can't figure...change range for multiple charts
I need to change the range for multiple charts, i.e. i have to go chart by
chart and modify, either with the mouse or by typing, the new range, is there
a quicker way to do this?
"Yossi evenzur" wrote:
> I need to change the range for multiple charts, i.e. i have to go chart by
> chart and modify, either with the mouse or by typing, the new range, is there
> a quicker way to do this?
I've written a little Excel add-in that performs mass edits of series
How to Edit Series Formulas
http://peltiertech.com/WordPress/how-to-edit...blank page prints after group (sometimes)
I have report of students with the class_id defined as a group. "Force New
Page" is defined "Before Section".
Whether I have a page and a group header defined (they can be the same anyway)
or just a page header defined, I am getting the same problem:
27 students can fit onto a page. However, if there is a class of 25 students,
the next page is blank except for the header. (I have not seen a class of
27 students so I have not tested that yet).
I can't seem to find a way out of it. Where I am I going wrong?
Message posted via AccessMonster.com
I installed a new Outlook (XP) and have my old backup PST file on a disk. I
want the default data location to be of my choosing. I assume I copy that
data where I want it but how do I import it? "bobnewman backup.pst.pst". I
am totally confused, both by the lack of documentation (that I can find) and
the backup file name. I hope someone can help.
I found it! Thanks anyway.
"Bob Newman" <firstname.lastname@example.org> wrote in message
> I installed a new Outlook (XP) and have my old backup PST file on a disk.
> want t...How do I change the elements displayed in the message list
How do I change the elements displayed in the message list. For example, to
list "To" or "From"
edit the view - to change just one folder, click on the row of field names
and choose custom. To make all folders the same see
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips...get data form cells sequentially
I have a spreadsheet i am creating which is giving me some amount o
hassle!!! I'm sure it is possible to do this but i just cant figure ou
I have one worksheet which has many copies of the same table, eac
table is consistantly ontop of the other i.e. first table uses cells A
- G10 (a rectangle of cells).
The dates i am trying to use are in a pattern of a nine row seperatio
i.e. first date is in cell G2, next one is G11, next one G20, and s
I need to find out how i can make a formula which i could copy whic
would grab the date out of these cells in sequence for pl...