General discussion
-
CreatorTopic
-
September 10, 2003 at 9:59 am #2316237
Join the Microsoft Office Suite discussion
Lockedby debate · about 20 years, 6 months ago
This is 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, and offer suggestions for future tips.
Paste the following URLs into a browser to check out our previous discussions. (Please remove any superfluous spaces when you copy and paste these links.)
http://techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=122381
http://techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=130431
http://techrepublic.com.com/5208-6230-0.html?forumID=5&threadID=134380
If you haven’t subscribed to our free weekly Microsoft Office Suite e-newsletter, sign up today!
http://nl.com.com/acct_mgmt.jsp?brand=techrepublicTopic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
September 17, 2003 at 7:51 am #2741554
MS Word bottom margin problem – help!
by roxanne @ tr · about 20 years, 6 months ago
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!!-
September 17, 2003 at 9:05 am #2741538
Try ‘OK’
by carol.balk · about 20 years, 6 months ago
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.
-
January 29, 2004 at 9:44 am #2688850
Try fit to page in printer properties
by misszip100 · about 20 years, 1 month ago
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.
-
-
September 25, 2003 at 8:31 pm #3390318
Margin fix
by rbcchck · about 20 years, 6 months ago
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 IgnoreRegards
-
September 26, 2003 at 11:56 am #3388320
Word Processor Compatibility may be the cause
by tryitagain · about 20 years, 5 months ago
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.
-
July 15, 2004 at 7:44 am #2719310
Compatibility
by xxdrummerxx85 · about 19 years, 8 months ago
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”
-
-
November 20, 2003 at 1:21 pm #2674747
A Question
by matmak · about 20 years, 4 months ago
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
-
November 26, 2003 at 7:35 am #2676287
Same thing here!
by kmichael · about 20 years, 3 months ago
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.
-
January 21, 2004 at 7:35 am #2681843
HP Printer Drivers
by txmischief · about 20 years, 2 months ago
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.
-
June 28, 2004 at 2:44 pm #2723504
Ditto the printer drivers
by long sam · about 19 years, 8 months ago
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.
-
January 26, 2005 at 7:09 am #3324014
Chopped Off Margins Work Around
by atcollege · about 19 years, 1 month ago
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.
-
-
March 3, 2004 at 6:37 am #2696144
margin problems
by nieders · about 20 years ago
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!
-
April 15, 2004 at 10:17 am #2670008
backspace
by marguerite13 · about 19 years, 11 months ago
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. -
January 18, 2005 at 6:51 pm #3326253
Problem with Word 2003
by aj1000 · about 19 years, 2 months ago
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.
-
January 26, 2005 at 8:52 am #3323977
Revision Tracking or Comments
by michael.umehara · about 19 years, 1 month ago
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”
-
January 26, 2005 at 10:02 am #3323952
File, Markup – (de)select
by aj1000 · about 19 years, 1 month ago
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.
-
January 27, 2005 at 2:31 am #3322711
Could be Track Changes problem
by gwk · about 19 years, 1 month ago
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.
-
-
May 12, 2004 at 8:56 am #2692252
Left Margin Issue
by stephanie.hazen · about 19 years, 10 months ago
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
-
February 2, 2005 at 1:06 am #3341807
Scaling
by marianhorsley · about 19 years, 1 month ago
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.
-
-
October 1, 2003 at 6:35 am #3388590
Using Bold in Access reports
by eddie.limoncelli · about 20 years, 5 months ago
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?
-
October 2, 2003 at 1:11 am #3389807
FontBold in Visual Basic
by borre.nilsen · about 20 years, 5 months ago
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.
-
October 2, 2003 at 6:58 am #3389741
great – thanks, but . . .
by eddie.limoncelli · about 20 years, 5 months ago
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.
-
October 8, 2003 at 6:39 pm #3378072
VBA code required
by it_cowboy · about 20 years, 5 months ago
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 -
October 9, 2003 at 8:20 am #3377904
Thanks Greg J! but . . .
by eddie.limoncelli · about 20 years, 5 months ago
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!!
-
-
October 22, 2003 at 12:55 pm #3364824
can do
by pancras · about 20 years, 5 months ago
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. -
November 5, 2003 at 5:27 am #2678218
Conditional formating
by 06scout · about 20 years, 4 months ago
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.
-
-
October 1, 2003 at 9:24 am #3388540
Problem inserting graphic in Word document
by aktib · about 20 years, 5 months ago
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?
-
October 2, 2003 at 1:07 pm #3389529
right-click and remove hyperlink
by freddy2k1 · about 20 years, 5 months ago
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.
-
October 8, 2003 at 6:34 am #3365769
Paste Special
by lady eknoid · about 20 years, 5 months ago
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.
-
October 15, 2003 at 4:16 am #3364490
Thanks for the tip…but
by aktib · about 20 years, 5 months ago
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?
-
October 16, 2003 at 8:13 am #3387149
Maybe
by mddm · about 20 years, 5 months ago
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.
-
October 30, 2003 at 12:06 pm #3363344
Try disabling auto-dial
by msittech · about 20 years, 4 months ago
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.
-
May 24, 2004 at 4:15 pm #2737519
This works
by lady eknoid · about 19 years, 10 months ago
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.
-
-
-
October 8, 2003 at 7:45 am #3365738
Limiting Explore from Office-Word Application
by bfgregg · about 20 years, 5 months ago
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.
-
October 20, 2003 at 7:11 pm #3376892
Re: Limiting Explore from Office-Word Application
by slats · about 20 years, 5 months ago
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?
-
October 29, 2003 at 5:39 am #3363571
Explore from Word
by bfgregg · about 20 years, 4 months ago
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
-
-
-
October 8, 2003 at 7:49 am #3365737
page, section breaks printing!
by wordworker · about 20 years, 5 months ago
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?
-
October 20, 2003 at 7:15 pm #3376890
Did you search MSKB, or if app is retail, contact MS?
by slats · about 20 years, 5 months ago
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?
-
October 21, 2003 at 6:12 am #3376814
nothing found
by wordworker · about 20 years, 5 months ago
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.
-
-
November 20, 2003 at 1:30 pm #2674745
Check the following
by matmak · about 20 years, 4 months ago
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
-
-
October 15, 2003 at 5:22 am #3364476
Mail Merge with Excel file
by zanimaniac · about 20 years, 5 months ago
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.
-
October 15, 2003 at 10:50 am #3364348
Content vs Format
by rooks88 · about 20 years, 5 months ago
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.
-
October 15, 2003 at 1:26 pm #3364307
Content vs Format
by zanimaniac · about 20 years, 5 months ago
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.
-
October 16, 2003 at 12:19 pm #3387015
Reply To: Join the Microsoft Office Suite discussion
by rooks88 · about 20 years, 5 months ago
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!
-
-
November 19, 2003 at 2:42 pm #2675054
Two things to look at
by rick_from_bc · about 20 years, 4 months ago
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.-
November 29, 2004 at 9:21 am #3315739
Excel Formats in Word Mail Merge Doc
by atcollege · about 19 years, 3 months ago
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.
-
-
-
October 20, 2003 at 7:03 pm #3376895
Send E-mail window size in Word & Excel 2000
by slats · about 20 years, 5 months ago
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!
-
October 27, 2003 at 11:07 am #3376328
Microsoft Access Database Search Engine
by ksantos · about 20 years, 4 months ago
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!-
November 16, 2004 at 11:47 am #3311562
Search Engine in Access
by jlblack · about 19 years, 4 months ago
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.
-
-
November 12, 2003 at 7:22 am #2679022
Word “Click and Type” Feature Enabled, Not Working?
by lovetolearn · about 20 years, 4 months ago
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?
-
November 26, 2003 at 2:50 pm #2676163
“Click and Type” is Working
by txmischief · about 20 years, 3 months ago
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.
-
-
November 19, 2003 at 3:52 pm #2675034
Partial ToC in Word
by ctcarroll · about 20 years, 4 months ago
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?
-
December 16, 2003 at 1:39 am #2670727
Partial ToC workarounds
by kees.valkenswaard · about 20 years, 3 months ago
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.
-
-
November 27, 2003 at 7:41 pm #2675651
Access Report Printing Automatically
by allath_2000 · about 20 years, 3 months ago
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?
-
December 3, 2003 at 7:05 am #2686298
Need help on Prinitng form PowerPoint
by cfizz34 · about 20 years, 3 months ago
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.
-
January 28, 2004 at 9:50 am #3369194
not sure if there’s a limit, but…
by corrinav · about 20 years, 1 month ago
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.
-
-
December 3, 2003 at 4:57 pm #2686137
WORD 2000 printing fields in forms
by hro · about 20 years, 3 months ago
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.
-
December 9, 2003 at 11:50 am #2684729
Glitch with Newsletter link to this forum & Communication gap at TR
by hro · about 20 years, 3 months ago
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=137196One 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.-
December 10, 2003 at 6:11 am #2673274
Re: Glitch with Newsletter link
by debate · about 20 years, 3 months ago
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-
January 7, 2004 at 12:27 pm #2684636
where are all the posts?
by freddy2k1 · about 20 years, 2 months ago
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
-
January 14, 2004 at 6:16 am #2683528
Reply To: Join the Microsoft Office Suite discussion
by mddm · about 20 years, 2 months ago
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.
-
January 23, 2004 at 7:35 pm #2688707
same deal here
by murray6 · about 20 years, 2 months ago
In reply to Reply To: Join the Microsoft Office Suite discussion
I also got here for the apology letter
-
January 22, 2004 at 2:21 pm #2677198
Update
by hro · about 20 years, 2 months ago
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
-
January 23, 2004 at 12:47 pm #2676999
Re: Update
by debate · about 20 years, 2 months ago
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 -
January 28, 2004 at 10:26 am #3369183
Found an answer but not a solution
by weze · about 20 years, 1 month ago
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!
-
-
January 26, 2005 at 3:00 am #3324069
Severe Issue with Links and IE 6.xx
by christiegooch · about 19 years, 1 month ago
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.)
-
-
January 14, 2004 at 6:02 am #2683536
Access – auto-update a date
by fdellavalle · about 20 years, 2 months ago
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.
-
January 14, 2004 at 7:48 am #2683502
Calculate the time in a Query or on a Form
by rw2000 · about 20 years, 2 months ago
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.
-
-
January 28, 2004 at 6:30 am #3369252
Access DB Templates
by m hamil · about 20 years, 1 month ago
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?
-
January 28, 2004 at 9:24 am #3369203
PowerPoint to Word
by rjfrank · about 20 years, 1 month ago
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?
-
April 22, 2004 at 10:21 am #2669107
Why?
by lata · about 19 years, 11 months ago
In reply to PowerPoint to Word
Why would you want to do this?
-
May 12, 2004 at 7:09 am #2692323
Can do
by marygail · about 19 years, 10 months ago
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.
-
May 26, 2004 at 3:56 am #2737242
How to go from PowerPoint to Word
by pptmagic · about 19 years, 10 months ago
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
-
-
January 28, 2004 at 8:00 pm #2688981
excel numbers separation by comma
by charuawalkar · about 20 years, 1 month ago
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
-
February 4, 2004 at 7:53 am #2689645
Excel Track Changes Is Blue?
by bpledger · about 20 years, 1 month ago
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.
-
February 4, 2004 at 12:59 pm #2689536
VB
by mddm · about 20 years, 1 month ago
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 SubIt 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.
-
-
February 11, 2004 at 5:51 am #2696550
Automatic fill-in of numerical values
by jarodbee · about 20 years, 1 month ago
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
-
February 18, 2004 at 1:15 pm #2696689
Outlook 2003 not compatible with Business Contact Manager
by mcs1 · about 20 years, 1 month ago
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.
-
March 3, 2004 at 11:03 am #2696041
Access 2002 and Publisher 2003
by newfie49 · about 20 years ago
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 -
March 3, 2004 at 2:19 pm #2696009
MS Word Text Boxes
by graham_gerry · about 20 years ago
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 ?
-
March 4, 2004 at 5:34 am #2695910
Suggestions
by wordworker · about 20 years ago
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.
-
May 12, 2004 at 10:40 am #2692218
Thinking outside the box – really outside!
by rick_from_bc · about 19 years, 10 months ago
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.
-
-
March 24, 2004 at 2:36 pm #2729702
Use “TEST YOUR EMPLOYEE’S ACCESS SKILLS” with extreme caution!
by boulderridge · about 19 years, 12 months ago
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 aboveThe “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 aboveThe “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!
-
March 26, 2004 at 3:41 pm #2695426
Totally Agree
by rkuhn040172 · about 19 years, 12 months ago
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.
-
March 27, 2004 at 9:16 am #2695358
not written by an access person
by freddy2k1 · about 19 years, 12 months ago
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.
-
-
-
March 31, 2004 at 7:16 am #2693703
Business day formatting in Excel?
by ssctechman · about 19 years, 11 months ago
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?
-
April 14, 2004 at 8:22 am #2668827
Filter Out Weekends
by wolfie x · about 19 years, 11 months ago
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.
-
April 14, 2004 at 8:40 am #2668824
Business day formatting in Excel?
by dlfitz · about 19 years, 11 months ago
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.
-
April 21, 2004 at 7:42 am #2669421
AutoFill
by ray.adkins · about 19 years, 11 months ago
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
-
May 12, 2004 at 4:34 am #2692361
AutoFill (2)
by dblayney · about 19 years, 10 months ago
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.
-
-
-
April 21, 2004 at 6:16 am #2669437
Invisible query expressions
by gsawyer · about 19 years, 11 months ago
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?
-
January 14, 2006 at 9:47 am #3077511
Expr1:
by nickrusso · about 18 years, 2 months ago
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.
-
-
April 22, 2004 at 10:23 am #2669105
Word or Outlook won’t connect to DFS
by lata · about 19 years, 11 months ago
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..
-
November 1, 2004 at 10:35 am #3295825
DFS can be glitchy
by administrator · about 19 years, 4 months ago
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.
-
-
April 28, 2004 at 3:46 am #2733258
Outlook 2003: fixing errors in reminders
by gwk · about 19 years, 11 months ago
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?
-
January 27, 2005 at 2:39 am #3322708
Problem probably from old Palm/Intellisync
by gwk · about 19 years, 1 month ago
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.
-
-
April 28, 2004 at 7:14 am #2733233
Excel — determine the amount of data imported
by george_mathis · about 19 years, 10 months ago
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-
May 5, 2004 at 9:14 am #2732010
Copy to End of Excel List
by crookedquilter · about 19 years, 10 months ago
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)
– PasteThis 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 SubThis 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. -
October 1, 2004 at 3:55 pm #2723986
Excel – need to know last row of data?
by david.hanshumaker · about 19 years, 5 months ago
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.
-
-
May 3, 2004 at 7:38 am #2734082
Word – Printing multiple pages on one sheet of paper
by skurve95 · about 19 years, 10 months ago
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?
-
May 5, 2004 at 7:21 am #2732045
Access: “Search for fields with no data” tip
by majortom · about 19 years, 10 months ago
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.
-
May 5, 2004 at 12:51 pm #2731945
Russ you’re wrong
by wordworker · about 19 years, 10 months ago
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.
-
May 7, 2004 at 2:59 pm #2732485
Access: “Search for fields with no data” tip
by majortom · about 19 years, 10 months ago
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.
-
May 12, 2004 at 9:36 am #2692239
version specific
by wordworker · about 19 years, 10 months ago
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.
-
-
-
May 12, 2004 at 5:49 am #2692344
Excel question
by debyteky · about 19 years, 10 months ago
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! 🙂-
May 12, 2004 at 8:09 am #2692273
Formula
by wolfie x · about 19 years, 10 months ago
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”
-
-
May 12, 2004 at 10:04 am #2692233
Excell Question
by khop2305 · about 19 years, 10 months ago
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?
-
May 12, 2004 at 10:23 am #2692224
Easy
by wordworker · about 19 years, 10 months ago
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.
-
-
May 20, 2004 at 12:22 pm #2691965
Excel Database – size limit?
by kbo · about 19 years, 10 months ago
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?
-
May 26, 2004 at 8:07 am #2737161
Outlook thread ??
by soilsavers · about 19 years, 10 months ago
In reply to Join the Microsoft Office Suite discussion
is there a discussion thread on Outlook 2003?
-
May 26, 2004 at 1:00 pm #2737060
Looks like you’ve started one…Net Folders
by puntim · about 19 years, 10 months ago
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
-
-
May 26, 2004 at 9:09 am #2737142
Mysterious Margin Marks
by rmartin · about 19 years, 10 months ago
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?
-
May 26, 2004 at 9:28 am #2737139
Text Boundaries
by wolfie x · about 19 years, 10 months ago
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.
-
June 22, 2004 at 8:15 am #3367286
Mysterious margin marks
by qaman10 · about 19 years, 9 months ago
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
-
June 22, 2004 at 8:17 am #3367283
Mysterious margin marks
by qaman10 · about 19 years, 9 months ago
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
-
-
October 25, 2004 at 6:42 am #3309074
Weird black boxes show up in Powerpoint
by ligurza · about 19 years, 4 months ago
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.
-
November 24, 2004 at 8:26 am #3310819
Check properties of logo?
by lgoodman · about 19 years, 3 months ago
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.
-
-
December 8, 2004 at 10:37 am #3303366
Problem with File Open/Look In in MS apps
by willfromsf · about 19 years, 3 months ago
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.
-
February 14, 2005 at 8:28 am #3336198
same problem; any luck?
by wayne · about 19 years, 1 month ago
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?
-
February 15, 2005 at 1:06 pm #3349376
mapped drive
by wayne · about 19 years, 1 month ago
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.
-
-
January 26, 2005 at 10:00 am #3323953
Word 2000 Normal Templates and Styles
by mpd · about 19 years, 1 month ago
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?
-
February 15, 2005 at 1:35 pm #3349340
Suggestion
by mrafrohead · about 19 years, 1 month ago
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
-
November 2, 2005 at 8:57 am #3116460
Disabling Alt+Click for Research in MS Word
by dlfitz · about 18 years, 4 months ago
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.)
-
-
AuthorReplies