General discussion

All Comments

  • Author
    Replies
    • #2741554

      MS Word bottom margin problem – help!

      by roxanne @ tr ·

      In reply to Join the Microsoft Office Suite discussion

      Sometimes, in MS Word (97 at home & 2000 at work), while in Print Preview, I receive the message that some text is outside the printable margin on a standard 8.5 x 11 page. I’m presented with 2 options:
      If I choose “Fix”, the bottom margin is changed to 2.67, and I may or may not lose the footers – but the content will be repaginated at the new, shorter page format.
      If I choose “Ignore”, any printed page cuts off at 2.67″, and the bottom text is absent.
      The cut-off is permanently embedded in any print-preview from then on. If I copy the content to a new document file, it starts out OK, then the margin cut-off happens again the next time I go to Print Preview.
      I’ve checked Page Set-up/Margins & Paper Size. I’ve checked the print drivers (it happens on both the Epson and HP printers). I’ve reinstalled MS Office 97. None of these have helped.
      Any ideas? I’m at my wit’s end. It’s so frustrating to have the bottom fall off a 15 page specification document, after 2 weeks of work!!

      • #2741538

        Try ‘OK’

        by carol.balk ·

        In reply to MS Word bottom margin problem – help!

        What happens if you choose ‘OK’ instead of ‘Fix’? I have Word documents that routinely give me this message but I always respond with ‘OK’ (or whatever the other option is) and the document prints fine on my (HP) printer, which will print to within .25″ of the edge of the paper. I always keep Word margins .3″ or greater and in spite of the warning, everything is printed as it appears on the monitor.

        • #2688850

          Try fit to page in printer properties

          by misszip100 ·

          In reply to Try ‘OK’

          Go to file. Print, Properties, Utility, and click fit to page. The printer will fit the document to the page.

      • #3390318

        Margin fix

        by rbcchck ·

        In reply to MS Word bottom margin problem – help!

        There are a couple of things to try/ do
        1.In File/Page Set up, change your margin settings on the first tab (margins)
        2. On the Page Size tab select A4 as the page size.

        I tried it leaving only .3cm as bottom margin and it printed no problems.
        You are prompted to Fix or Ignore – choose Ignore

        Regards

        • #3388320

          Word Processor Compatibility may be the cause

          by tryitagain ·

          In reply to Margin fix

          If you are looking at documents back and forth first in Word97 and then in Word2000, it may be that Word is trying to “work” as the other.

          From the Tools menu, select Options. Click on the Compatibility tab and select the proper version of Word you are working in from the drop down list.

        • #2719310

          Compatibility

          by xxdrummerxx85 ·

          In reply to Word Processor Compatibility may be the cause

          I found that changing the compatibility in the options menu of the tools tab worked the best. If you are opening the document from an email or any other data base you will run across a lot of these problems. Thanks for the help “tryitagain”

      • #2674747

        A Question

        by matmak ·

        In reply to MS Word bottom margin problem – help!

        If I may,

        I notice you mentioned that it happens on either the Epson or the HP are these both attached to the same machine and if so do you altyernate as to which is the default dependant on Job.

        My reason for asking is that when you first open your word document the default template is paginated to the page settings which are affected by device settings of your printer i.e. the limitations the driver tells your computer it has.

        Thus you open up your document create it and save it when your HP printer is the default, you change printers or take the document home to work on your home PC which has the epson, therefore when you try to open it regardless of the version of word, it will repaginate the document to the values as per the default printer settingsand vice versa.

        I noticed you also stated that your footer disappears or is cut in half check the Footer offset value in page setup then print preview and adjust until it is visible.

        I hope this helps

        Regards

        Martin Mack

      • #2676287

        Same thing here!

        by kmichael ·

        In reply to MS Word bottom margin problem – help!

        We have experienced the same problem in a few documents here. If you try to print the document (no matter whether you chose fix or ignore)the last few lines at the bottom do not show. Our margins are set to be 1″ at the bottom.

        The only thing I have noticed is that the problem does not occur unless you go into page setup to check the setup. As long as you never go into page setup everything works fine and you receive no error messages. But once you go into page setup and exit (whether or not you make any changes, and whether or not you click ok or cancel), when you try to print the document you receive the warning that some material is outside the margins even though it was well within the 1″ margin.

        We have tried recreating the documents from scratch that this occurs on, and re-installing office 2000 but nothing has fixed the problem.

        There may be some help in following the compatability fix mentioned in tryitagain’s response, as we have many documents that were created using word 95 and we are now using word 2000.

        • #2681843

          HP Printer Drivers

          by txmischief ·

          In reply to Same thing here!

          It is most likely your HP printer drivers. I work for a law firm and have seen this run rampant. Through a legal technology newsgroup, I learned that it was the printer drivers. Check HPs website for new drivers for your printer. They’ve only recently released ones that fix this problem. If you look at the specifics for the printer driver on their site, it will be listed as one of the fixes included in that particular driver.

        • #2723504

          Ditto the printer drivers

          by long sam ·

          In reply to HP Printer Drivers

          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.

        • #3324014

          Chopped Off Margins Work Around

          by atcollege ·

          In reply to Same thing here!

          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.

      • #2696144

        margin problems

        by nieders ·

        In reply to MS Word bottom margin problem – help!

        Try this: Before starting the document set all margins to 0 clik the OK button and then fix. This will set all the margins to the lowest level that the printer will allow. You can also go to the Format menu and choose Borders and shading choose the Page Border tab then the Options button click on the Measure from dropdown and choose text instead of edge of page. Hope this helps!

        • #2670008

          backspace

          by marguerite13 ·

          In reply to margin problems

          This happens often with tables. The table will invisibly stretch to the next page.
          Choose view|print layout to get a better understanding of what is going on. Click after your last word and hit delete or if a last blank page appears, click on that page and keep hitting the backspace until it disappears.

        • #3326253

          Problem with Word 2003

          by aj1000 ·

          In reply to margin problems

          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.

        • #3323977

          Revision Tracking or Comments

          by michael.umehara ·

          In reply to Problem with Word 2003

          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”

        • #3323952

          File, Markup – (de)select

          by aj1000 ·

          In reply to Revision Tracking or Comments

          Thanks for the tip. That’s a good solution for printing. I also just discovered that on the view menu, if I turn off “markup” (which turns on in 2003 by default), then the page on screen appears normal and also prints with regular margins without the comments. These sidebar comments don’t appear in Word 2000 so it took me by surprise when the margins seemed to be distorted. Now that I understand this feature, I like Word 2003 more than Word 2000.

        • #3322711

          Could be Track Changes problem

          by gwk ·

          In reply to Problem with Word 2003

          Some documents produced in earlier versions of Word come up in Word2003 with “Track Changes” set. This means that Word2003 leaves a RH margin (by default) on screen and in the printout to show the recent changes to the document. Probably worth hitting the “Accept all changes” command (usually from a menu icon) and see if this solves it.

      • #2692252

        Left Margin Issue

        by stephanie.hazen ·

        In reply to MS Word bottom margin problem – help!

        I have recently updated to Office 2003 and opened previous Word 2000 document. It is a table in landscape mode — when I open it in print preview the left half of the first column is cut off — changing the margins; converting table to text, etc do not bring back the text from the first column. Any ideas? Thanks

      • #3341807

        Scaling

        by marianhorsley ·

        In reply to MS Word bottom margin problem – help!

        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.

    • #3388590

      Using Bold in Access reports

      by eddie.limoncelli ·

      In reply to Join the Microsoft Office Suite discussion

      In producing Access reports, I’m trying to be able to highlight certain items based on the value of one of the fields. I thought I’d be able to use the IIF function in the report with HTML codes for bolding, but that didn’t work. anyone have any thoughts on what I can do?

      • #3389807

        FontBold in Visual Basic

        by borre.nilsen ·

        In reply to Using Bold in Access reports

        The IIF function is part of the Visual Basic language used in MS Office. In VB you have two properties to be used to make a font bold, the FontBold-property is a Boolean, FontBold=True; whereas the FontWeight-property is used with a number from 100 to 900 in steps of a hundred,i.e. FontWeight=400 means normal, FontWeight=700 means bold.

        • #3389741

          great – thanks, but . . .

          by eddie.limoncelli ·

          In reply to FontBold in Visual Basic

          how do I apply that in my IIF statement? I’m making a tabular report in which I need all fields to be bold in each line that contains the proper criteria in one field.

        • #3378072

          VBA code required

          by it_cowboy ·

          In reply to great – thanks, but . . .

          Consider the following example:

          txtFieldName contains the value that determines whether the row is bolded. In this example, if the field = “BOLD”, you want to bold the line.

          You need to add the following code to the “OnFormat” event for the report.

          If Me!txtFieldName = “BOLD” Then
          ‘Need to specify all fields that need to be bold
          Me!txtOtherField1.FontBold = True
          Me!txtOtherField2.FontBold = True
          Me!txtOtherField3.FontBold = True
          Else
          Me!txtOtherField1.FontBold = False
          Me!txtOtherField2.FontBold = False
          Me!txtOtherField3.FontBold = False
          End If

        • #3377904

          Thanks Greg J! but . . .

          by eddie.limoncelli ·

          In reply to VBA code required

          Thanks, Greg – I figured a VBA solution was out there, but I don’t know VBA at all, so when I tried to apply your solution, it didn’t work. I replaced the “Me” in your example with the table name, and the “txtField…” with the names of the appropriate fields, but it didn’t work. I also tried it using the Report name instead of “Me” in your example, but no go. What am i doing wrong? Also, I could only find the OnFormat function in the properties for the Detail of the report, not the whole report. Thanks again, but Help!!

      • #3364824

        can do

        by pancras ·

        In reply to Using Bold in Access reports

        as of access 2000 i believe, there is conditional formatting in the pulldown menu Format.
        Activate design mode.
        Activate the control you want to change.
        Hit Format-Conditional formatting.
        That’s it.

      • #2678218

        Conditional formating

        by 06scout ·

        In reply to Using Bold in Access reports

        Try using conditional formating feature for your text box. select the target text box, format, conditional formating

        I use it to highlight overdue suspense dates in several reports.

    • #3388540

      Problem inserting graphic in Word document

      by aktib ·

      In reply to Join the Microsoft Office Suite discussion

      Whenever I attempt to insert a picture from file into a word document, the program attempts to dial my internet connection several times before allowing the graphic to post. Is there any way to turn this off?

      • #3389529

        right-click and remove hyperlink

        by freddy2k1 ·

        In reply to Problem inserting graphic in Word document

        sounds like there could be a hyperlink somehow embedded in or associated with the graphic. once the graphic ‘posts’ as you say, right-click on it and select the Hyperlink option, then choose Remove Hyperlink.

        • #3365769

          Paste Special

          by lady eknoid ·

          In reply to right-click and remove hyperlink

          copy the picture then try Paste Special under the Edit menu. This will give you several different options on how you want it pasted. You may also access links under the edit menu to remove any links that may be included in the item being pasted. I have used both methods.

        • #3364490

          Thanks for the tip…but

          by aktib ·

          In reply to right-click and remove hyperlink

          The dial-up attempt happens before I have navigated to any particular graphic. Word attempts to dial immediately after I click on “From File” prior to opening any directory on my hard drive. It seems to want to browse the Web as its first choice.

          Weird, huh?

        • #3387149

          Maybe

          by mddm ·

          In reply to Thanks for the tip…but

          Maybe it is trying to dial because you have your pictures set to open with Internet Explorer. Insert Picture from File, when you see the “look in” dialog box (after it tries to dial)choose Tools on this dialog box, properties, click on the change button under the open with.

        • #3363344

          Try disabling auto-dial

          by msittech ·

          In reply to Thanks for the tip…but

          Open your control panel, double click “Internet Options”, select the connections tab & check “never dial a connection”. That way your modem will only dial when you log on to your ISP.

        • #2737519

          This works

          by lady eknoid ·

          In reply to Try disabling auto-dial

          This sounds like it may be your option here. This should allow you to use the sub-menus.

    • #3365738

      Limiting Explore from Office-Word Application

      by bfgregg ·

      In reply to Join the Microsoft Office Suite discussion

      I am a High School network technologist trying to prevent the students from accessing the “Explore” feature though the Word program. I run a Novell 6 network using dynamic local users in the Windows 2000 environment. The students do not have any access to the desktop except by going through this backdoor that Word provides. Any suggestions would be appreciated.

      • #3376892

        Re: Limiting Explore from Office-Word Application

        by slats ·

        In reply to Limiting Explore from Office-Word Application

        I’ve been using Word 2K for awhile, created macros, tweaked it a lot, but I’ve never seen an “explore feature”. I searched the toolbar command list, but didn’t find it.

        Do you mean the File|Open dialog or similar dialogs that are somewhat unique to Office? If so, they may see the files, but can only open files compatible with Word, within Word. No?

        • #3363571

          Explore from Word

          by bfgregg ·

          In reply to Re: Limiting Explore from Office-Word Application

          You are able to open the Windows Explore feature in Word while you are in the File>Open feature. My students go around the methods in which I have locked down the desktop to access other files. These files will open up in the appropriate program which include getting onto the Internet, accessing system files, changing the Windows splash screens etc. I have found a way to disable the contect click but do not want to limit the context right click as it is a useful feature in other programs such as copy and paste.
          Thank you for you reply,
          Bgregg

    • #3365737

      page, section breaks printing!

      by wordworker ·

      In reply to Join the Microsoft Office Suite discussion

      Okay, I posted a question in Tech Q&A a couple of days ago fully expecting to have my diagnosis confirmed – that my remote Word XP user MUST be wrong about dotted lines and “Page Break” appearing in printed copies of his Word document. Everyone who posted said, “Nah can’t be done.” Well, today I finally got my hands on faxes of the hard copies from the printouts, and sure enough, not only are hard page breaks printing, but so are section breaks, automatic page breaks… I don’t think I’ve ever seen this (except in old-fashioned printscreen prints). My user couldn’t find anywhere in the print dialog options to turn off whatever must be telling Word to print these normally unprintable characters. Anybody seen this before?

      • #3376890

        Did you search MSKB, or if app is retail, contact MS?

        by slats ·

        In reply to page, section breaks printing!

        That’s a new one on me. It might be something esoteric enough for MSKB to have an answer, although I find that option very frustrating to find just what you want. If your OfficeXP is retail & recent, have you tried the free limited time service to MS?

        • #3376814

          nothing found

          by wordworker ·

          In reply to Did you search MSKB, or if app is retail, contact MS?

          thanks for the post. I searched MSKB but didn’t find anything. I got faxes from the client that showed the page break graphics printing just like they were part of visible text! It was weird. Finally got out of the client that it was only *one* of the eight documents that was acting up. (They had all started in Word, converted to FrontPage and/or some other publishing app, then back to Word. Who knows what it picked up along the way.) We just copied all the text out to Notepad and started a new document and reformatted everything.

      • #2674745

        Check the following

        by matmak ·

        In reply to page, section breaks printing!

        Get your user to go into tools,options, and under the print tab check that Include with document options of “Field Codes” and “Hidden Text” aren’t selected, only thing I can think of

        Hope it helps

        Regards

        Martin Mack

    • #3364476

      Mail Merge with Excel file

      by zanimaniac ·

      In reply to Join the Microsoft Office Suite discussion

      Using Office 2002, I am using an Excel spreadsheet as the data source to a form letter. Two merge fields are dates and amounts.

      1). When I format the date in Excel, e.g. 05/31/2003 as May 31, 2003, I get the date in the letter as 05/31/03. Why?

      2). When I format the amounts in Excel as currency, with 2 decimal places, comma, dollar symbol with English (US) language (e.g. $1,000.00), the amount comes into the letter as follows: 1000.00. Sometimes the number comes in with more decimal places.

      Any ideas?? I would greatly appreciated any help. Thank you.

      • #3364348

        Content vs Format

        by rooks88 ·

        In reply to Mail Merge with Excel file

        Hello!

        I believe both issues are caused by the same thing – the format of the cell. During Mail Merge, the Word wizard is pulling the content of the cell (what is truly in the cell) and uses that format. It does not, however, pull the format over that you applied to the cell e.g. the Number format that adds a dollar sign and a decimal.

        Convert the cell formats to Text and then re-attempt the mail merge. It should pull the information in the format you are looking for.

        Hope this helps.

        • #3364307

          Content vs Format

          by zanimaniac ·

          In reply to Content vs Format

          Thank you Rooks88. I did go back and change all the fields to a text format within the Excel spreadsheet. But here is something strange: after changing the format back to date with the month spelled out, it worked for the first 24 records in the spreadsheet. My spreadsheet contains over a 100 records. Is this a limitation??

          The Excel spreadsheet was created from converting a text file that was downloaded from an AS400. Is there something that I should be checking there?

          Thanks again Rooks88 for your help.

        • #3387015

          Reply To: Join the Microsoft Office Suite discussion

          by rooks88 ·

          In reply to Content vs Format

          Hello!

          There is no limit to how many records the formatting will convert. I would suggest verifying the content and existing formatting of the cells past your 24th record. I wish I could offer better advice, but this is hard to troubleshoot without seeing the actual cells.

          The text file conversion shouldn?t have anything to do with formatting the date after it is placed in Excel. As long as this is the same file we have been discussing (already converted, formatted, saved in Excel, used for the Mail Merge and now the formatting is being changed again) I wouldn?t worry about checking that.

          Good luck!

      • #2675054

        Two things to look at

        by rick_from_bc ·

        In reply to Mail Merge with Excel file

        Use the “Trim” and “Clean” functions to remove extra
        spaces and non-printing characters in these cells. I have
        seen these two items foul-up an otherwise fine merge.

        We never format anything in Excel if we plan on merging.
        Use Word’s mergefield switches to set any formatting
        including capitalization, number and date formats, etc. I
        know that the documentation in the help section looks
        daunting, but it is pretty straightforward, very complete
        and really eases data entry in Excel.

        Our merged documents are quite complex, and clients are
        really pleased with the output – we haven’t been stumped
        yet with formatting using the switches.

        • #3315739

          Excel Formats in Word Mail Merge Doc

          by atcollege ·

          In reply to Two things to look at

          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.

    • #3376895

      Send E-mail window size in Word & Excel 2000

      by slats ·

      In reply to Join the Microsoft Office Suite discussion

      When sending a Word or Excel doc via e-mail [File|Send to|Mail Recipient (as Attachment)…] Does anyone know how to either (1) change the default window size to something larger than a window designed for “wee little people” OR (2) fool Office or Windows to allowing a larger size by using some script file or app that intercepts & resizes the window?

      This seems to be a bane of users that noone wants to talk much about. I’ve searched the new & MVP’s to exhaustion!

    • #3376328

      Microsoft Access Database Search Engine

      by ksantos ·

      In reply to Join the Microsoft Office Suite discussion

      Hi,
      My name is Kevin, and I created an FAQ database for my Company. The company was pleased with what I created, but they want me to add to the Access page a search engine. How can I create a search engine in an access page. I would be greatful for any sugestions.
      Thank You!

      • #3311562

        Search Engine in Access

        by jlblack ·

        In reply to Microsoft Access Database Search Engine

        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.

    • #2679022

      Word “Click and Type” Feature Enabled, Not Working?

      by lovetolearn ·

      In reply to Join the Microsoft Office Suite discussion

      As far as I can tell, I have followed the instructions – in Tools>Options>Edit, I have enabled click and type. I am in Print Layout view. Yet when I double-click in a document, blank or otherwise, the click-and-type feature does not seem to work. Instead, in a blank document, the initial cursor location gets selected; in an existing document, the nearest word or beginning of line gets selected. Any suggestions?

      • #2676163

        “Click and Type” is Working

        by txmischief ·

        In reply to Word “Click and Type” Feature Enabled, Not Working?

        Sounds like “click and type” is working just fine. The problem is that you are double-clicking. The double-click is a way of selecting text. To position your cursor in a document for typing, just do a single click.

    • #2675034

      Partial ToC in Word

      by ctcarroll ·

      In reply to Join the Microsoft Office Suite discussion

      Is there any way to generate a table of contents for a selected range of pages or named range rather than for the entire document?

      • #2670727

        Partial ToC workarounds

        by kees.valkenswaard ·

        In reply to Partial ToC in Word

        Maybe there is a possibility. In that case I should like to hear about it as well.

        In mean time there are a few alternatives, although always involving some manual work.
        The first is to generate the full ToC. Just click in the margin for each line, or group of lines, to be removed and delete. Afterwards update only page numbers.

        Another one might be to use different headings. If e.g. Heading 1 and Heading 5 would have the same format, as for 2 and 6 etc. one can choose in options which headings to be displayed in the ToC. So perhaps for one ToC, headings 1 to 4 and in another one somewhere else heading 5 to 8 etc. The headings would still look similar in the complete document. Full update of the ToC [including titles] would be possible in this case.
        Good luck.

    • #2675651

      Access Report Printing Automatically

      by allath_2000 ·

      In reply to Join the Microsoft Office Suite discussion

      I am creating an invitation in Access (2000)Reports Object. I put a clipart border around the inviation. My problem is when I go to print preview to view the invitation, a print job is immediately initiated. If I take the border out, no print job is intitiated.

      Any ideas how I can prevent the intitiation of the print job?

    • #2686298

      Need help on Prinitng form PowerPoint

      by cfizz34 ·

      In reply to Join the Microsoft Office Suite discussion

      Has anyone heard of a problem when printing a .jpg file and it comes out with a little red ‘x’ on the top left page of the print out? The inserted .jpg file is about 4MB, but the data inside the .jpg is a really long slice (80″ x 100″). It there any kind of limitation on printing these types of files? One thing to note is that the priting problem is random, we get about 1 good print to every 5 bad ones.

      • #3369194

        not sure if there’s a limit, but…

        by corrinav ·

        In reply to Need help on Prinitng form PowerPoint

        I have experienced this before. It seemed to be related to powerpoint presentations that were hosted on our network. Whenever they included a large (filesize-wise) image the red x would appear. When the files were saved to a local hard drive, the print usually worked out fine.

    • #2686137

      WORD 2000 printing fields in forms

      by hro ·

      In reply to Join the Microsoft Office Suite discussion

      I’m creating a template that a client can use both to fill-in various fields on a printed form -and use electronically. The form will be protected and print settings are to print data only for forms.

      I believe in minimizing repetition and keystrokes whenever possible! And I know that I can insert fields which perform calculations in a table and/or copy info that’s already been entered/calculated elsewhere on the form. But it won’t print! e.g. if there is one form-field that the user enters $10,000.00 and another form-field where this is to be spelled out, I can insert a word field with . Looks great on the screen, but, of course, it won’t print as form data.

      There must be a simple step/trick that I’m missing here! Any ideas? Thanks.

    • #2684729

      Glitch with Newsletter link to this forum & Communication gap at TR

      by hro ·

      In reply to Join the Microsoft Office Suite discussion

      On Dec. 5, I attempted to send an E-mail to . It was returned as not a valid address. So I persevered, and eventually found a Contact page to which I posted my original query. I received an auto-reply saying it would be forwarded to the appropriate party. Today (Dec. 9) I received a msg from Customer Support which indicates:

      The address that you sent the e-mail to is used by one of our newsletter editors. She is using the address for her alias, but it doesn’t seem to be working to receive mail to it. She requested that you please post any comments or questions you might have on the appropriate threads on the site. She monitors them regularly and responds via the threads.

      So here’s my *original* query to :

      I susbscribe to TechRepublic’s MS Office Suite Newsletter (amongst others) and on several occasions when I’ve attempted to follow the link included in:

      Jump into the Microsoft Office Suite discussion
      Visit the fourth discussion thread of our ongoing Microsoft Office Suite discussion, where you can post your Word, Excel, or Access questions, enter comments about our weekly Microsoft Office Suite e-newsletter, offer suggestions for future tips, and get links to previous Office discussions. Check it out today!

      The link above is http://ct.com.com/click?q=b8-smr2QQUVXamlHOG1RR~_B8BVEirR

      but the redirect is quite erratic and sometimes ends up at:

      http://techrepublic.com.com/5208-6335-0.html? (yielding a page not found)

      rather than at
      http://techrepublic.com.com/5208-6335-0.html?&forumID=5&threadID=137196

      One can get to the discussion forum by working back from
      http://techrepublic.com.com/5208-6335-0.html? – and even (I recently discovered by accident!) by reclicking the link in the newsletter. However, I suspect that many will not bother – as I have not bothered on previous occasions. This may be why there are so few posts to this discussion forum.

      I hope you can get this fixed, as I posted a query two days ago: “Word 2000 printing fields in forms” – and I’d love to see some answers!!


      Thanks.

      • #2673274

        Re: Glitch with Newsletter link

        by debate ·

        In reply to Glitch with Newsletter link to this forum & Communication gap at TR

        hro,

        I apologize for your problems with the discussion link in the newsletter. I’m not sure why the tracked link sometimes does not work, but I will forward your concerns to our customer service department in hopes of resolving the link issue.

        Of course, as you’ve discovered, the link to the discussion is the same each week:
        http://techrepublic.com.com/5208-6335-0.html?&forumID=5&threadID=137196

        (If copying and pasting this link into a browser, please remove any extra spaces.)

        I appreciate your patience with this issue. Please e-mail me at Enews1@cnet.com if you have any more concerns.

        Sincerely,
        Jenna Marks

        • #2684636

          where are all the posts?

          by freddy2k1 ·

          In reply to Re: Glitch with Newsletter link

          maybe this problem is bigger then ms marks thinks since there haven’t been any new posts to this form in such a long time

        • #2683528

          Reply To: Join the Microsoft Office Suite discussion

          by mddm ·

          In reply to where are all the posts?

          I have the same problem all the time… along with everyone else. I reported the problem more than once and I never received a solution, just an apology. In fact, I accessed this discussion, then accessed My Discussions and tried to get back to this discussion and got a page not found. Nice.

        • #2688707

          same deal here

          by murray6 ·

          In reply to Reply To: Join the Microsoft Office Suite discussion

          I also got here for the apology letter

        • #2677198

          Update

          by hro ·

          In reply to Re: Glitch with Newsletter link

          Jenna, I’ve received at least 4 Office Suite Newsletters since Dec. 10 – including one today. Not one of them had a link to this forum that actually works!

          In the meantime, I found the answer to my original question elsewhere – some time ago.

          Other readers seeking answers to problems they’re encountering in MS Office apps. may want to peruse the microsoft.public.* newsgroups – or set their newsreaders to: news://msnews.microsoft.com/

          I’ve just hit the microsoft.public.word.* cluster, so far and have found much useful advice and resources from the gurus who post there.

          hro

        • #2676999

          Re: Update

          by debate ·

          In reply to Update

          hro,

          I apologize for your continuing problems with the discussion link in the newsletter. I have filed a bug on the problem.

          In the meantime, I will make sure that our system does not track the discussion link in the e-newsletter, which will hopefully help the situation.

          I appreciate your patience with this issue. Please e-mail me at Enews1@cnet.com if you have any more concerns.

          Sincerely,
          Jenna Marks

        • #3369183

          Found an answer but not a solution

          by weze ·

          In reply to Re: Update

          I have also been having problems accessing the discussions. Finally I copied and saved the links to a Word pad file and tried using it from another computer which has MOZILLA as a browser. It works just fine!! In other words the problem is IE!

      • #3324069

        Severe Issue with Links and IE 6.xx

        by christiegooch ·

        In reply to Glitch with Newsletter link to this forum & Communication gap at TR

        I think the link problem is related to one of the IE hotfixes pushed down in the third quarter of 2004. I am an avid Tech newsletter reader and all of a sudden one morning, I could no longer access the discussions nor anything else on the TechRepublic site. After a couple of weeks of frustration and deprivation, I installed Mozilla FireFox and everything works fine. This morning I ran into the situation where I clicked the link for a second time and got directly to the site through my IE browser. (That second attempt had not worked prior to this.)

    • #2683536

      Access – auto-update a date

      by fdellavalle ·

      In reply to Join the Microsoft Office Suite discussion

      In my line of business we use databases to keep employee information and track them. Say we receive a new employee on 1 Jan 04 and every time we open Access the time they have served at that location could be updated automatically by months in one field and years in another field. If the employee had been working for 2 years, the month field would have 24 and the year field would report 2. I have been forced to use Excell to track the dates and I have to enter them in manually and is very time consuming. I have an example of what I use in Excell to help explain: An employee started to work for us on April 15, 1991, to calculate the years I enter =DATEDIF(“1991/4/15″,”2004/1/14″,”Y”) . I Have to enter todays date manually using Excell, but I want to convert this all into Access and have todays date automatically entered and do the conversion. Thank you for any help. You can reply to my e-mail address.

      • #2683502

        Calculate the time in a Query or on a Form

        by rw2000 ·

        In reply to Access – auto-update a date

        Create a query. Use the datefield (such as DateHired). The month calculation column would be Months: DateDiff(“m”,[DateHired],Date())
        The year calculation would be Years: Int([Months]/12)
        In a Form, use text boxes. The calculations would be =DateDiff(“m”,[DateHired],Date()) and =Int(DateDiff(“m”,[DateHired],Date())/12)
        This would not give strictly true values as it would give 1 month for someone hired on the last day of the previous month even if today is the first day of the new month — Jan 31 compared to Feb 1 = 1 month.

    • #3369252

      Access DB Templates

      by m hamil ·

      In reply to Join the Microsoft Office Suite discussion

      Is it possible to bring the Contact Management template and the Inventory template together? I want to relate the customer to an item taken out of inventory in a db. If yes, how do I accomplish this in Access?

    • #3369203

      PowerPoint to Word

      by rjfrank ·

      In reply to Join the Microsoft Office Suite discussion

      In Office 2003, is there a way to take a PowerPoint template or blank presentation into Word as a template?

      • #2669107

        Why?

        by lata ·

        In reply to PowerPoint to Word

        Why would you want to do this?

      • #2692323

        Can do

        by marygail ·

        In reply to PowerPoint to Word

        Go to INSERT, OBJECT, and under the tab CREATE NEW, choose MICROSOFT POWERPOINT PRESENTATION. You’ll see a blank PowerPoint screen with TITLE, etc. Go up to the toolbar and choose FORMAT, SLIDE DESIGN, and you’ll see all the PowerPoint templates down the right side of the screen. Choose one and there you go!!! Hope this helps.

      • #2737242

        How to go from PowerPoint to Word

        by pptmagic ·

        In reply to PowerPoint to Word

        Hi,

        From within your presentation; click on File, Send to, Word. Choose the format that you’d like and click on OK. It will send your outline from PowerPoint into a Word document that you can then save as a DOT file to create a template.

        If what you really want is the graphics, then you need to save the slide as an image:
        http://www.rdpslides.com/pptfaq/FAQ00052.htm
        Insert the resulting graphic into a Word Document, format it the way you want and save it as a DOT file to create a template.

        HTH,
        Glenna

    • #2688981

      excel numbers separation by comma

      by charuawalkar ·

      In reply to Join the Microsoft Office Suite discussion

      THERE SHOULD BE OPTION IN COMMA(,) SEPARATION OTHER THAB BY MILLION BILLION, BY LAKHS,CORES,THOUSANS AS USED IN SOUTHERN ASIA

    • #2689645

      Excel Track Changes Is Blue?

      by bpledger ·

      In reply to Join the Microsoft Office Suite discussion

      What changes do I need to make to have Track Changes in Excel come out in Red and not Blue or Black? I have Excel 97 and Excel XP. In 97 the changes come out in Blue and in XP they come out in Black.

      • #2689536

        VB

        by mddm ·

        In reply to Excel Track Changes Is Blue?

        You can apply your own highlight to changed cells. Paste the following sub in the code pane of the worksheet. To access the code pane, right-click the sheet tab. Paste the code there, and enjoy a green highlight on any changed cells. For other colors, just change the color index (on-line help has a guide)

        Private Sub Worksheet_Change(ByVal Target As Range)
        Target.Interior.ColorIndex = 4
        End Sub

        It is not really advisable to change the color coding automatically assigned by Excel to track changes, since it assigns a different color to each person who makes changes to the workbook (assuming it is a shared file). You can either change the font color, or fill the cell with your chosen color etc, all is possible with VB.

    • #2696550

      Automatic fill-in of numerical values

      by jarodbee ·

      In reply to Join the Microsoft Office Suite discussion

      When I enter numbers in an Access-table (Access 2002, running under XP) in adjacent records, Access automatically fills a number in the next (empty) record when there is some kind of sequence in the previously entered values. F.i. Record1, field Age : 21; Record2, Age 22. When I go to the Age field in Record3 (down arrow in datasheet view) automatically the number 23 appears and stays in the record when I go one record down again. I like to turn this feature (Auto-completion?) off, but don’t know how. Anyone ?? THANKS IN ADVANCE

    • #2696689

      Outlook 2003 not compatible with Business Contact Manager

      by mcs1 ·

      In reply to Join the Microsoft Office Suite discussion

      Since installing Office Suite 2003 SBE I have had problems with the new Business Contact Manager (BCM). Drag Contacts from Outlook into the BCM, no problem. Try to look at that record and Outlook canot display it so Outlook opens a native page for the data. This is not automatic, it takes two more mouse clicks to acknowledge the action. All my client and supplier records are stored in Outlook.

    • #2696041

      Access 2002 and Publisher 2003

      by newfie49 ·

      In reply to Join the Microsoft Office Suite discussion

      Hi all,

      I’m having a problem running a simple Publisher 2003 catalog wizard that ties into an Access database to populate fields in the Publisher document.

      I’ve read the article “Creating Catalogs with Microsoft Office Publisher 2003” (on MS’s site) and inserting a graphic into a catalog from a database appears to be straightforward.

      However, I keep getting the error “Publisher cannot complete the operation” when I use the catalog wizard and use an Access 2002 or Excel 2002 file as the source for text and images.

      I followed all the directions in the article, especially those that explained how Publisher approaches image info in imported file.

      Does anybody have any ideas …

      ——————-

      Someone suggested the following:

      Forget about using MS Access, it is one dog of a program that should be
      removed from the store shelves.
      With your Excel file, do a SAVE AS in CSV (Comma Separated Values) and use
      that as your merge file and you will not have any problems.
      I would also suggest you go to http://www.microsoft.com/data and download and
      install the latest version of the MDAC Components which cover all versions
      of Windows.

      ———————-

      I tried both suggestions, but it doesn’t work.

      Anyone here have any suggestions?
      Thanks in advance,
      Craig

    • #2696009

      MS Word Text Boxes

      by graham_gerry ·

      In reply to Join the Microsoft Office Suite discussion

      I have pre-printed documents from a stationer, in which I have to fill in the blanks. I have aligned text boxes to fill these blanks however i dont want to print the outline or background of the boxes but if neither of these are visible then it is difficult to find then on the blank screen can anyone tell me a way to print the text in the text boxes but not the bground color or the outline ?

      • #2695910

        Suggestions

        by wordworker ·

        In reply to MS Word Text Boxes

        First, set up your fill-in-the-blanks as a table. Then you can see the table cell borders onscreen but they won’t print unless you format them with a line style.

        The other trick is to place an asterisk (*) in the document at each place where the data is supposed to be typed. (I use this all the time to fill in HCFA forms. I use a macro that searches for the next asterisk, then deletes it, and stops, leaving the cursor where it needs to be.)

        If you have any TechPoints accumulated, you may want to consider posting questions like this in the Technical Q&A section.

      • #2692218

        Thinking outside the box – really outside!

        by rick_from_bc ·

        In reply to MS Word Text Boxes

        1. Set up an Excel spreadsheet with columns to hold the
        fields requied on the form, using the first row to hold the
        field names. If there are less than 32 columns, use the
        DataForm to spped fill-in and Validation to restrict values,
        if necessary.

        2. Set up a Word merge document with the Excel
        spreadsheet selected as the data source. Use the
        positioning ability of Word to set the fields to print on the
        right places of an otherwise blank document.

        3. Use the Word field codes to format for BOLD, shading,
        leading spaces, etc.

        4. Use the Word merge manager to select the forms to be
        printed, and print onto the pre-printed forms.

        5. Add details to the Excel spreadsheet to calculate new
        values as needed, and to print reports of what has been
        printed, when, etc.

    • #2729702

      Use “TEST YOUR EMPLOYEE’S ACCESS SKILLS” with extreme caution!

      by boulderridge ·

      In reply to Join the Microsoft Office Suite discussion

      My MS Office Suite e-newsletter dated 3/24/04 included an article on the crosstab query wizard followed by a “Related Download” link titled “TEST YOUR EMPLOYEE’S ACCESS SKILLS.” This test was touted as a way to rate employee skill levels to determine what level of training they would benefit from most, but it is not hard to imagine a manager including it in a pre-hire evaluation.

      I’m an IT consultant with a CS degree and 13 years of professional experience, the majority of it using MS Access in reporting applications from version 2.0 to XP. I downloaded and tried the test just for fun. Section One (Beginners) had 15 multiple choice questions; four wrong answers and you were supposed to start in a Beginner class. I had 2+ answers wrong (I chose two answers for Q10). I missed four more answers out of the ten Intermediate and Advanced questions.

      I have two concerns that prompted me to post here:
      1) Some of the answers to the questions are in my opinion at least debatable.
      2) The download does not specify what version(s) of Access the test applies to. (However, the download is dated 9/19/00 and lists OS versions 95/98 if you are paying attention.)

      For example, Beginner Q7 states:
      7) End users should use which of the following for entering and editing data:
      a. Reports
      b. Forms
      c. Tables
      d. None of the above

      The “correct” answer is “c. Tables.” I don’t know about you, but I try very hard to avoid letting users enter data directly into tables, since this method does not give you any type of “Are you sure?” or “Save changes?” prompts; it just saves your edits invisibly. Not to mention data validation. At the very least, “b. Forms” would be a reasonable answer even if you assume the beginner doesn’t know how to create one.

      One more example; Advanced Q4 states:
      4) SQL statements are:
      a. Used to query unrelated tables
      b. Never used in Access
      c. Used to query only related tables
      d. None of the above

      The “correct” answer is “a. Used to query unrelated tables.” This would only be the clear answer if you assumed that “SQL statements” referred not to the commonly used query grid that builds SQL for you, but only to the more advanced “SQL” window where you can type in special things like Union queries. Again “c. Used to query only related tables” would be a debatable response.

      This test would certainly be useful in a discussion type of format where the answers could be discussed and clarified, but in my opinion should not be used as the sole means of determining someone’s level of competence in Microsoft Access (any version). So please use with care!

      • #2695426

        Totally Agree

        by rkuhn040172 ·

        In reply to Use “TEST YOUR EMPLOYEE’S ACCESS SKILLS” with extreme caution!

        While I don’t share your extensive background and history, I do work with Access everyday from the simple and mundane to the sometimes complex.

        That test made me look like a moron…but don’t most standardized tests anyways. I have created no less than 20 databases that were eventually incorporated into our own in-house software once the programmers learned what I was creating for my end users.

        That test made me look like I was a beginner.

        • #2695358

          not written by an access person

          by freddy2k1 ·

          In reply to Totally Agree

          I remember taking that ‘test’ when it came out originally and that question about “SQL statements” is the most offensive of many obvious signs that the person or people who created that download had no zero hands-on experience using Access.

    • #2693703

      Business day formatting in Excel?

      by ssctechman ·

      In reply to Join the Microsoft Office Suite discussion

      I need an easy way to create business/workday columns for an entire year. I track trouble calls a number of ways, but I don’t have anyone doing calls except on business days. Does anyone know how to create monthly worksheets with only workdays (or even weekdays- it should be easy enough to delete holidays) included?

      • #2668827

        Filter Out Weekends

        by wolfie x ·

        In reply to Business day formatting in Excel?

        The easiest way I’ve found to do this is to create a row for days of the week. You can fill in the first day and then click and drag to autofill the other columns, since weekdays are an enumerated type in Excel. Then you can use auto filter to select and delete all columns including Saturday or Sunday. You can then delete holiday columns and the weekday row manually.

      • #2668824

        Business day formatting in Excel?

        by dlfitz ·

        In reply to Business day formatting in Excel?

        Check out the WORKDAY function in Excel. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in.

        On the Tools menu, click Add-Ins.
        In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
        If necessary, follow the instructions in the setup program.

        The workday function allows you to specify only workdays at the top of each column and even eliminate a list of holidays if you wish.

        • #2669421

          AutoFill

          by ray.adkins ·

          In reply to Business day formatting in Excel?

          Type Monday in A1 Grab the fill handle and right click and drag right. When you release you will see a menu selct the weekday option

        • #2692361

          AutoFill (2)

          by dblayney ·

          In reply to AutoFill

          If you want dates as well as day names, try the following:
          Enter a Monday date in a cell. Use the fill handle to create 12 consecutive dates (ending on a Friday). Delete the columns/rows containing the 2 weekend dates. Highlight all 10 dates and the use the fill handle again to create however many weekday dates you want.

    • #2669437

      Invisible query expressions

      by gsawyer ·

      In reply to Join the Microsoft Office Suite discussion

      I built and ran a make table query with several involved expression fields. Now I want to modify some of the expressions and run the query again but can’t see the body of the expressions – just a name like Expr1. Do I have to recreate everything again?

      • #3077511

        Expr1:

        by nickrusso ·

        In reply to Invisible query expressions

        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.

    • #2669105

      Word or Outlook won’t connect to DFS

      by lata ·

      In reply to Join the Microsoft Office Suite discussion

      Whenever I type \\dfsroot\share\share into the file name box or into a templates location, I get the following message:

      You do not have access to the folder …. See your admin for access to this folder.

      Needless to say, I can access the folder from anywhere else..

      • #3295825

        DFS can be glitchy

        by administrator ·

        In reply to Word or Outlook won’t connect to DFS

        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.

    • #2733258

      Outlook 2003: fixing errors in reminders

      by gwk ·

      In reply to Join the Microsoft Office Suite discussion

      Outlook 2003 – on loading states there are errors in reminders so it may not be able to display reminders. I have used the /clearreminders switch, which at least permits reminders to work for that session, but cannot get the internal errors sorted. I have also used scanpst.exe, without success. I actually use XP-compliant format for the PST file, and sync with a Palm through Intellisync. Any ideas?

      • #3322708

        Problem probably from old Palm/Intellisync

        by gwk ·

        In reply to Outlook 2003: fixing errors in reminders

        Since posting the original problem, I have upgraded my ancient PalmII (using Intellisync software to sync Contacts, Tasks and Notes but not email) to a MS Mobile2003-based PDA. The problems have gone away – I can only assume they originated from the dated setup I was using. Not really acceptable, but perhaps inevitable.

    • #2733233

      Excel — determine the amount of data imported

      by george_mathis ·

      In reply to Join the Microsoft Office Suite discussion

      I import data from a database into Excel. The # of columns are fixed, but the # of rows will vary based on the # of records. Sometimes there will be only 1 row, other times there may be 5,000. I have a macro that will adjust column size and do other tasks, but I’d like a means to determine the last row containing data so that I may add a sort of the data to the macro.

      Any ideas as to how this may be easily done?

      Thanks
      George

      • #2732010

        Copy to End of Excel List

        by crookedquilter ·

        In reply to Excel — determine the amount of data imported

        Copy Data from a Collection Range to end of an Excel List (must have at least one data record in the list)
        Do these actions in your recorded macro:
        – Get data into the clipboard
        – Select worksheet, then select cell in left-most column of the List
        – Hit End-Down buttons
        – Hit Down Arrow once to go to the first empty row (you will change the recorded macro later)
        – Paste

        This is what your macro looks like:
        Sub AddToExcelList()
        Selection.Cut ‘cut contents of selected range
        Sheets(“ToursData”).Select ‘select sheet
        Range(“A6”).Select ‘Top cell of that list
        Selection.End(xlDown).Select ‘go to last item with data
        ActiveCell.Offset(1,0).Select ‘one row down to blank row
        ActiveSheet.Paste ‘selected data pasted
        End Sub

        This is the example I used to use when teaching Excel 97 classes. Had students do this in a class project. I am semi-retired now, bu still using this myself in my Checkbook Spreadsheet in ExcelXP.
        This should solve your problem.

      • #2723986

        Excel – need to know last row of data?

        by david.hanshumaker ·

        In reply to Excel — determine the amount of data imported

        Assuming you want to sort the entire list of records you’ve imported, wouldn’t the ‘Select current region’ function be the easiest way to do your sort? You wouldn’t have to specify how many records in the macro that way.

    • #2734082

      Word – Printing multiple pages on one sheet of paper

      by skurve95 ·

      In reply to Join the Microsoft Office Suite discussion

      The tip on multiple page printing helps, however, I have encountered a situation that I cannot seem to resolve. I was laying out a publication that is 5.5 x 8.5 and wanted to print two pages per sheet so that it would be easy to cut them for the commerical printer to use. When I used the ZOOM feature in the print dialogue, it did resize the pages so that they were not actual size anymore. This has worked previously, so what could have changed and how can it be done the way I want?

    • #2732045

      Access: “Search for fields with no data” tip

      by majortom ·

      In reply to Join the Microsoft Office Suite discussion

      Concerning the Access tip below* from today’s MS Office Suite newsletter, an important clarification should be mentioned. As is the case for the Phone field in the Customers table of the Northwind sample database, one must ensure that the table property “Allow Zero Length” (strings) for the text field is set to “No”.

      When a new table is created in design view, the default setting for a text field is to allow zero length strings (“”) as a value. Null basically means, “I don’t know what the value is.” Confusingly, null fields and zero length strings look the same to the “naked eye”: just like an “empty” field. However, if some fields contain a zero length string and you query for “Is Null”, those records will not appear in your query results. The query will still return records that do contain null values, and, in a large database, you might not realize that, say, customers without phone numbers were missing from the list.

      Similarly, in a number field’s table properties, one should replace the Default Value of “0” with “Null” to utilize this search strategy effectively. Otherwise, number fields skipped by the user will contain a value of zero by default, which is not the same as null (“I don’t know the value.”) and will not return a result for “Is Null”.

      Hope this is helpful,
      Russ

      *Search for fields with no data

      >It’s not uncommon for a field to have no data. >A user may have skipped the field or left it >blank because there was no value for the field >at the record’s time of entry. For example, >phone numbers may be missing for some customers >in your Customer table.

      >To find all customers whose phone number field >contains no data, follow these steps:

      >Create a query using the Customer table.
      >Select the Name and Phone Number fields from >the Customer table for the query.
      >Enter Null in the Criteria cell of the Phone >Number field. (Access automatically replaces >the entry with Is Null.)

      >When you run the query, the results will list >all customers whose phone numbers are missing.

      >But suppose your salespeople need a list of all >customers they can call for a special >promotion. To create a list of all customers >with phone numbers, follow the same steps.

      >But this time, enter Not Null in the Criteria >cell. Access automatically replaces the entry >with Is Not Null, and the query results will >list all customers whose phone number fields >are not blank.

      • #2731945

        Russ you’re wrong

        by wordworker ·

        In reply to Access: “Search for fields with no data” tip

        Sorry to burst your expert’s bubble, but you’re way off base on this. Just to be sure, I created a new database and one table in design view. Your first error: In Access 2000, the default for “allow zero length fields” is set to No, not Yes.

        Next I entered several records, some with entries, some without. Querying with Is Null returned the records that were blank in that field (blank, null, zero-length, whatever – nothing to the naked eye).

        So…before you go spouting off technical advice, perhaps you should check your facts.

        • #2732485

          Access: “Search for fields with no data” tip

          by majortom ·

          In reply to Russ you’re wrong

          Jeff: Using Access 2002, everything that I have suggested is absolutely correct, verified on several different occasions both in Northwind and in production databases. So, I suggest you get *your* facts straight before flaming someone else’s post that has been graciously submitted in the hope of preventing someone from receiving unintended results, as I did in the past.

        • #2692239

          version specific

          by wordworker ·

          In reply to Access: “Search for fields with no data” tip

          Sorry I flamed – I guess I was having a bad day. Still the thing works as published in A2K. That’s really all I wanted to point out. My clients all use either Access 2000 or Access 2003, and the tip works perfectly in those versions.

    • #2692344

      Excel question

      by debyteky ·

      In reply to Join the Microsoft Office Suite discussion

      I would like to copy the contents of a cell from one worksheet to a cell in another worksheet dynamically. I know how to copy and paste it but that’s not what I want to do. I know there should be a formula that will do this but I don’t know what it is. Could anyone please help me with the formula?
      Thanks so much! 🙂

      • #2692273

        Formula

        by wolfie x ·

        In reply to Excel question

        Just set the value of the cell in the other worksheet to equal the value of the cell in the first worksheet, such as “=Sheet1!A1”

        • #2692261

          Thanks :)

          by debyteky ·

          In reply to Formula

          Thanks so much Wolfie X, it works great!

        • #2726382

          Shortcut to linking

          by lschrim ·

          In reply to Formula

          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

    • #2692233

      Excell Question

      by khop2305 ·

      In reply to Join the Microsoft Office Suite discussion

      I have numerous duplicate entries listed in a column that I would like to query and remove the duplicates. How can I do this in Excel?

      • #2692224

        Easy

        by wordworker ·

        In reply to Excell Question

        click in the column that contains the dupes.
        Go to Data | Filter | Advanced Filter.
        Click the checkbox for Unique Records only.
        Click the radio button for copy to another location.
        Click in the Copy To field and then click in a new, empty column.
        Click OK and Excel will copy only the unique items out to the other range.

    • #2691965

      Excel Database – size limit?

      by kbo ·

      In reply to Join the Microsoft Office Suite discussion

      We have a user who keeps having trouble with an Excel database used for equipment inventory, which contains about 6,000 records. She says her computer often “hangs” when she saves new records. The file has become corrupted several times and needed to be repaired. Operating system is Windows 2000 Pro, Office Suite XP. Any suggestions on how to troubleshoot? Is the size of the database a problem?

    • #2737161

      Outlook thread ??

      by soilsavers ·

      In reply to Join the Microsoft Office Suite discussion

      is there a discussion thread on Outlook 2003?

      • #2737060

        Looks like you’ve started one…Net Folders

        by puntim ·

        In reply to Outlook thread ??

        With previous versions of OL I have been able to share using Net Folders. This is no longer a part of OL. Does anyone know of a simple zero cost option with OL2003?

        regards

    • #2737142

      Mysterious Margin Marks

      by rmartin ·

      In reply to Join the Microsoft Office Suite discussion

      I have a user who all of a sudden has brackets appearing in the corners of her Word documents that obviously mark the margins. She says that this just started appearing one day. They do not print, and if she sends me a doucment that has these, they do not display on my copy of Word. I can’t find option/command to either turn these on or off, and I have never seen these on any other Word installation. Anyone know what these are and how to turn them off and on?

      • #2737139

        Text Boundaries

        by wolfie x ·

        In reply to Mysterious Margin Marks

        Unchecking the Text boundaries option on the View tab under Options (in the Print and Web Layout options section) should make the markings go away.

      • #3367286

        Mysterious margin marks

        by qaman10 ·

        In reply to Mysterious Margin Marks

        Your user has at some time opened a document with an East Asian language active. When it happened to me, I found Korean to be one of the options. Go to Programs-Microsoft Office Tools-Microsoft Office Language settings and remove any language from Asia – that is unless your user really needs them. Your marks should then go away

      • #3367283

        Mysterious margin marks

        by qaman10 ·

        In reply to Mysterious Margin Marks

        Your user has at some time opened a document with an East Asian language active. When it happened to me, I found Korean to be one of the options. Go to Programs-Microsoft Office Tools-Microsoft Office Language settings and remove any language from Asia – that is unless your user really needs them. Your marks should then go away

    • #3309074

      Weird black boxes show up in Powerpoint

      by ligurza ·

      In reply to Join the Microsoft Office Suite discussion

      Hi. I have a user that has a Powerpoint presentation. She is using a logo on it. When opened the presentation slide with the logo on it, as a black boxes, about a quarter the size of the slide. When she opens a MS Word doc, the same thing happens with a logo at the top, used as a letterhead. Only the logo is affected. She is using HP Compaq Nx9010 laptop with onboard ATI graphics card. Any suggestions? I have reinstalled office & the graphics driver.

      • #3310819

        Check properties of logo?

        by lgoodman ·

        In reply to Weird black boxes show up in Powerpoint

        Have you checked the properties of the logo? Did she copy and paste it into her presentation and word document? Where did she get it from? Some graphics are protected for copy and paste, showing up as just a black box. She may be able to play with it in a photo / graphic editing software (photoshop, etc.. Otherwise, she probably just needs to get a different version of the logo.

    • #3303366

      Problem with File Open/Look In in MS apps

      by willfromsf ·

      In reply to Join the Microsoft Office Suite discussion

      When I select File Open on virtually any Microsoft application (Office apps, Wordpad, Notepad, etc.) and click the down-arrow on “Look in:” (at the top of the Open window) the app freezes and I have to terminate it. Yet this problem does not happen with non-MS apps. Anyone know of a relatively easy fix? Thanks.

      • #3336198

        same problem; any luck?

        by wayne ·

        In reply to Problem with File Open/Look In in MS apps

        I’ve got two users experiencing the exact problem you outlined. Did you find a solution?

      • #3349376

        mapped drive

        by wayne ·

        In reply to Problem with File Open/Look In in MS apps

        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.

    • #3323953

      Word 2000 Normal Templates and Styles

      by mpd ·

      In reply to Join the Microsoft Office Suite discussion

      Does anyone know of a way to remove a given Font setting – e.g. Arial from a Heading Style so that it will be based on the Normal style font setting?

    • #3349340

      Suggestion

      by mrafrohead ·

      In reply to Join the Microsoft Office Suite discussion

      Use OpenOffice!!!

      It’s free and it’s not a crappy bug filled Microsoft product ;p

    • #3116460

      Disabling Alt+Click for Research in MS Word

      by dlfitz ·

      In reply to Join the Microsoft Office Suite discussion

      Does anyone know how to disable the Alt+Click shortcut for getting the Research Task Pane in MS Word? I use Alt+Click extensively to highlight blocks of text. About half the time it works and about half the time it brings up the Research Task Pane. (I know the three key shortcut for block text, but it is too awkward to be practical.)

Viewing 40 reply threads