[AccessD] Urgenet need re new printer (2007)

Kathryn At Gwen's kathrynatgwens at socal.rr.com
Thu May 5 13:05:26 CDT 2011


I work for Gwen, primarily doing genealogy. When there are computer issues
while I'm here, she has me troubleshoot them too. Last week, day after her
husband was burned over 27% of her body, one of her two printers broke and I
had to run to store and get another. Old one HP OfficeJet Pro 8500, new one
the next newer model, HP OfficeJet Pro 8500A. Even though mostly identical,
the default name of old one in list of printers has a 909 in it and the new
one has a 910 in it. Can't give you exact as I'm upstairs in my office and
that computer/printer combo is downstairs in living room. I don't believe
it's pertinent anyway. Point is they are almost identical. Now, on to the
problem.

Old database, I think originally Access 2000. Not a very professionally done
one, but it works. Tons of names/addresses. More than a dozen reports for
envelopes alone as there are different font, return address, and envelope
size combinations for different purposes. Trying to print one gives a
message to the effect of this was formatted for abc printer which isn't
available do you want to print to default printer. After doing a bunch of
Googling, I successfully opened one of the reports in design view, which
along the way asked about the printer and I chose the new printer. Then
saved the report. I can now print - HOWEVER.

#10 envelope, it used to be:
-----------------------|
Return                 |
            Addressee  |
-----------------------|

But now it's printing 3 envelopes like this
-------------|
Printing     |
             |
             |
             |
             |
             |
             |
             |
-------------|
Then Addressee on next envelope and then a blank one.

All I did was change the printer, so why did it change the orientation? How
do I fix the whole db without having to change each report separately? I
found a bunch of pages that talk about changing printers programmatically
and other terms but they were all beyond my kindergarten skills of access.
I'm fairly decent except when it comes to the visual basic stuff. Tables,
queries using drag/drop, reports, I'm ok with, but not code. So remember
that when you help. I can send a copy of the database if that would help,
but of course you don't have our printers.

It's 11am my time, I leave for home at 3pm (not back until Monday). Gwen's
desperate as she has lots of envelopes to print to mail updates on husband's
condition to those without email (he's in first skin graft surgery as I
write). Handwriting them not an option as she's got post-polio and writing
that many envelopes is problematic. 

Here's hoping one of you has a quick solution I can understand and act on.


--
Kathryn Bassett 
kathrynatgwens at socal.rr.com (work)
kathryn at bassett.net (home)





More information about the AccessD mailing list