Join the Microsoft Office Suite discussion
This is page 2 of the discussion. Read the opening post
Software
This is page 2 of the discussion. Read the opening post
by qaman10
by long sam
Thanks, TxMischief, for pointing out the printer drivers. In our shop it also appears to be a printer driver issue. Glad to hear HP is stepping up.
This occurs to us most often in documents which move between portrait and landscape modes. Headers and footers are not handled correctly. Check to be sure there is a section break for every switch, and be sure, in headers/footers, to turn off the "same as previous setting."
However, we've noticed sometimes it is purely the printer driver -- the problem disappears if the document is queued to another type of printer.
by lschrim
As a shortcut, you don't have to type in Sheet 1 and cell A1. In the cell you want that nifty answer to show up in, just type = then move to Sheet 1 and click in cell A1. Hit Enter and you're done!
Linda
by ligurza
by lgoodman
I know that, in some instances, you have to give the entire DFSroot path. Like this;
\\domain name\dfsroot\share name.
the words "dfsroot" are fixed, not a variable.
by jlblack
Kevin - -If what you want to do is to enable someone already in Access to search the contents of the database, that is pretty easy to do. You would just use the toolbox to add a button which provides the same "find" functionality that is in the top toolbar.
If you want to be able to search Access database contents from another application that is something quite different. I am hoping that the new desktop search engine from MSN will be able to do that, but I can't anything that says it does. If you find a solution to that, please let me know.
I believe the old AltaVista desktop search engine did that, but I may be mistaken.
by atcollege
This seems to be more of a problem in Word 2002 and Word 2003. Our users here had no problems until they were upgraded to Win XP and Office 2002.
The fix is in Word. Tools menu, Options, General tab.
Check Confirm conversion on open. You will only have to do this once, as it sets the Word default.
Then when you use an Excel SS as a data source, you will receive a list of ways to connect to the data source. Choose the DDE option.
The rest of the prompts are the same as in the past.
Dates and number formats come across as they should.
by willfromsf
by wayne
by wayne
Will,
It appears that my problem was caused by a mapped drive that the user/s didn't have access permissions to. When I entered the mapped drive through Explorer I was prompted for a username/password so I disconnected from the drive in Explorer then tried File/open/look in (dropdown); Problem solved. I changed the permissions on the drive previously mapped, then remapped and all is well.
by aj1000
I just upgraded from Word 2000 to Word 2003. I haven't changed printers or made any other changes, but when I open up a very long document that I created in 2000, there's a problem in 2003 that didn't exist before.
The margins seem to have shrunk and when I print the document all pages print out smaller than they should leaving large gaps of white space along the bottom and right hand margins. I can't change the margins manually without distorting the content of every page. I don't know how to fix this to make it print out as it did before with normal margins and normal sized font.
I'm not sure if this could be a source of problems, but this document has a "table of contents" that was created in Word 2000.
I'd appreciate any help.
by atcollege
At our college we have the same problems. They started when we upgraded users to Windows XP. It seems that the HP drivers didn't work exactly right with the new operating system. The giveaway is that when you let Word "fix" the margins, either the bottom or left margin is changed to 2.67. All our printers were capable of much smaller margins which they happily accomodated before WinXP.
By trial and error, we came up with several solutions, none of which are a permanent fix.
In the offending document, select a printer that doesn't give you these problems. Make all your editing changes. Save the document and then close it. Reopen the document, immediately print, (don't do anything else), using the printer that chops off margins. It's a pain, but it works.
The real fix is to get corrected HP drivers if they are available.
I had a similar problem which turned out to be the result of a comment box way at the bottom of the document.
Word 2003 conveniently adjusts the margins to show comments and tracked changes.
In the print dialog box where it says "print what" select "document" or in the "display for review" toolbar section, select "Final"
by aj1000
by mpd
by gwk
by gwk
This is probably too late to help the writer of this problem may help others.W
When I upgraded to 2003 I experienced the same problem. It happened to me on a class outline that I repeatedly have to hand out.
When I went to Print, there is a section in that window titled Scale. I opted for Scale to paper size and chose 8 1/2 X 11. That seemed to solve the problem. I still have to repeat it when printing the same outline sheets.
by mrafrohead
Use OpenOffice!!!
It's free and it's not a crappy bug filled Microsoft product ;p
by dlfitz
by nickrusso
Access use Expr1: as a default to precede an expression in a query. You can replace it with your own text (leave the colon) to act as a "field name."
To see your expression, widen the column in the design grid, or press Shift+F2 while in the expression to zoom.
This discussion is closed to new replies.
Sort by Trending