General discussion
-
CreatorTopic
-
June 1, 2004 at 8:09 am #2293849
Join the Microsoft Office Suite discussion
Lockedby debate · about 19 years, 10 months ago
This is the fifth 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
http://techrepublic.com.com/5208-6335-0.html?forumID=5&threadID=137196
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
-
-
June 2, 2004 at 4:19 am #2731205
excel: vlookup
by brucelparsons · about 19 years, 10 months ago
In reply to Join the Microsoft Office Suite discussion
VLOOKUP defalults to the next lowest vlookup_value if the vlookup_value looked for is not found. Is there a way to cause it to go to the next highest number instead?
-
July 7, 2004 at 12:41 pm #2724666
Vlookup with IF()
by rick_from_bc · about 19 years, 8 months ago
In reply to excel: vlookup
=if(vlookup(A1,$H1:$J10,1)
-
July 23, 2004 at 1:27 am #2701581
Nice try!
by dblayney · about 19 years, 8 months ago
In reply to Vlookup with IF()
The problem is what value of X to use. If it’s too low then the second lookup will get the same value, too high and it could “overshoot”. There is also the difficulty of handling the case where the value in A1 is greater than the highest value in H1:H10. In my opinion, this probelm can only be solved with Visual Basic but I would be very interested in being proved wrong.
-
August 25, 2004 at 7:07 am #2711770
this worked for the original poster
by rick_from_bc · about 19 years, 7 months ago
In reply to Nice try!
dblaney, you are right – this is a quick shot at solving the
problem. I tried it out with several scenarios, and the
results were good if the table was ‘regular’ – the values
stepped up in fixed increments. This solution didn’t work
for irregular expressions n a consistent manner, as you
pointed out.However, I did get feedback from the original poster, and it
worked for him. C’est la vie!Sometimes, a cigar is only a cigar.
-
October 21, 2004 at 3:46 pm #3307714
Slight modification to Rick from BC’s solution
by david.hanshumaker · about 19 years, 5 months ago
In reply to Nice try!
To make VLOOKUP pick the next higher value instead of the next lower value, insert a new column 2 into table h1:j10, so table is now h1:k10. Copy h2:h10 into i1:i9 and h10 into i10. This gives a second col whose values are offset by one row from the first col. Now, nest VLOOKUP into VLOOKUP into IF as follows:
=IF(VLOOKUP(A1,$H$1:$H$10,1)largest value in table.
-
-
October 20, 2004 at 7:40 am #3309995
Tabs. AArggghhh
by big paul · about 19 years, 5 months ago
In reply to excel: vlookup
Word_ Extra TAB when updating a table of contents
I have a document which has a table of contents based on Heading 2 only.
This is nicely aligned
If I click OK to the update box “Word” inserts an additional tab into the table of contents space which messes with the format ~ pushes each line over the edge
If I manually delete the additional tab the alignment of the ToC reverts to the original layout.
The tab is NOT in the style {Heading 2]
I have scrolled through the document. I do not have a tab in that position within the document!How do I tell Word not to add this tab when I update the ToC?
Regards Paul
-
January 19, 2006 at 9:33 am #3098453
Tab issues
by mzzoo · about 18 years, 2 months ago
In reply to Tabs. AArggghhh
I have encountered the same problem as you have described above. Check to make sure that Tools -Autocorrect Options – AutoFormat As You Type – the bottom 3rd of the tab, Automatically As You Type -make sure that all 3 boxes are checked. This resolved my issue and I hope that it does yours.
-
-
-
June 23, 2004 at 12:55 pm #2734360
General
by beezee · about 19 years, 9 months ago
In reply to Join the Microsoft Office Suite discussion
While I appreciate the MS Office Suite newsletter, I was wondering if anyone besides me is interested in PowerPoint tips. I certainly have a lot to learn about this application. Anyone from Tech Republic listening?
TIA
-
June 30, 2004 at 7:23 am #2735584
PowerPoint tips?
by roykendrick · about 19 years, 9 months ago
In reply to General
I too would be interested in a PowerPoint tips discussion. I’ve been wondering if it could be used to email family photos for genealogy purposes and could narrative be added? Would this be simpler than using it to create a CD? I’ve not attempted it yet.
-
June 30, 2004 at 8:38 am #2725559
PowerPoint for family photos
by blueknight · about 19 years, 9 months ago
In reply to PowerPoint tips?
Sure, using PowerPoint to e-mail family photos with or without narrative(s) would be easy. My sister went to Hawaii two years ago and took photos of the schoolhouse where our grandfather was Principal (and where our father was a student), along with many other interesting sights. She e-mailed me a PowerPoint presentation with her photos in it and comments for each shot so I’d know what I was looking at.
If you’re going to send the presentation to someone who doesn’t have PowerPoint, you can create a presentation file that contains the viewer (a .PPS file). That way folks without PowerPoint can still view your presentation. Instructions on how to do this can be found in the PowerPoint help facility. Be sure to try it out before you send the file to them to be sure it works properly.
Kinda funny… I’m the only one of us “kids” born in Hawaii and I’ve never been back since we moved here when I was 3. -
July 2, 2004 at 8:43 am #2726016
Thank you!
by roykendrick · about 19 years, 9 months ago
In reply to PowerPoint for family photos
Thanks Jim, I’ll try it.
-
July 6, 2005 at 4:39 am #3180049
print backgrounds in word
by ray_luke · about 18 years, 9 months ago
In reply to PowerPoint tips?
Ichanged the back ground to light blue,every print but the blue back ground. ???
Luke -
December 22, 2005 at 3:17 am #3198168
Free Powerpoint viewer
by neil.mclean · about 18 years, 3 months ago
In reply to PowerPoint tips?
If your relatives don’t have powerpoint you can get them to download a free viewer from Microsoft at http://office.microsoft.com/en-gb/officeupdate/default.aspx.
-
April 5, 2006 at 10:20 am #3106505
Reply To: Join the Microsoft Office Suite discussion
by vanessaj · about 17 years, 12 months ago
In reply to PowerPoint tips?
BlueKnight is right. And PPT does email well…but you have to watch out for what some call “PowerPoint bloat”. Graphics/pictures are larger files than text files by far and once you put them into PPT, it can become a rather large attachment. Make certain that your email client – and the email client of the recipient can handle the size attachment you are going to send. If it is large, burning a CD and snail-mailing it may be prefereable for you. ALSO, I always use the “Package for CD” in the File menu and remember that you can use “Options” and “Add Files” for further customization of how and when you want your presentation to play. Adding simple narration is pretty easy if you have a microphone at: Insert > Movies & Sounds > Record Sound. You can also add a soundtrack to play throughout the entire presentation (all slides). Good luck and have fun!
-
-
June 8, 2005 at 5:42 am #3191277
I use PowerPoint occassionaly
by funtoknow · about 18 years, 9 months ago
In reply to General
I have used PowerPoint occassionally. I used it a little more often when they had a better org chart tool than the very basic one included with 2003 (better off using Visio).
Ove the years I have collected quite a number of “tips” I am willing to share.
“An eye-catching animation on a PowerPoint slide is to have the text “type in” as though it were being typed on a typewriter. PowerPoint even provides the typewriter sound for you!
To check this out, open a blank slide and click the Text Box button in the Drawing toolbar (its icon looks like a printed sheet with a large A on its upper-left-hand corner). Add some text to the Text Box. Next, right-click the Text Box and choose Custom Animation.
When the Custom Animation dialog box opens, click the arrow at the right side of the Introduce Text list box and select
By Letter. Now, click the top list box under “Entry animation and sound” and select Appear from the list. Expand the second list box and select Typewriter as your sound.” -
April 5, 2006 at 10:07 am #3106514
-
-
June 30, 2004 at 7:00 am #2735588
scrolling
by foreigner · about 19 years, 9 months ago
In reply to Join the Microsoft Office Suite discussion
[Office 2000:]
The lack of “smooth scrolling” in Excel and Outlook Contacts (phonebook view) bugs me. Thankfully, it is implemented in Word.In case I should not name the technical property correctly, not being a Windows programmer, I mean the behaviour where the frame’s contents move while the scroll box moves, rather than afterwards.
-
June 30, 2004 at 6:07 pm #2725380
Contacts Details
by aakash shah · about 19 years, 9 months ago
In reply to Join the Microsoft Office Suite discussion
I use Office 2003 for my personal use. Unfortunately, when I add a new contact, the phone number field names it offers me are “1. Business, 2. Home, 3. Business Fax, 4. Mobile” How can I change the default field names that appear so that I can get something like “1. Home, 2. Mobile, etc.” Also, is there a way to add new fields to this list, such as “Mobile 2”? I would like to have the address default to Home rather than business. Any helpl with this would be greatly appreciated.
Thanks!
-
July 14, 2004 at 12:57 pm #2718939
Making Changes
by krkuehne · about 19 years, 8 months ago
In reply to Contacts Details
I’m not totally familiar with Office 2003, but in XP you can change the “fields” for your address information [business, home, other] as well as changing how your phone numbers appear. You need to click on the drop down buttons located by each one. However, I do not know if it possible to have it set as a default – as I just change mine based on the information I’m entering.
-
July 28, 2004 at 3:47 pm #2699248
Edit the forms
by imaer · about 19 years, 8 months ago
In reply to Contacts Details
How you ask
In Outlook, select Tools > Forms > Design a Form. From the list select ‘contacts’. Redesign to your heart’s content. Be sure you are happy with your changes before you save.
If the ‘Field chooser’ pop up is not on screen, click ‘Form’ > ‘field chooser’ and you will see an option ‘New’. This will create new fields for you. Of course you could just modify the existing labels and problem solved.
Give it a go using the help options built in to Office.-
August 4, 2004 at 9:03 pm #2713640
Thanks!
by aakash shah · about 19 years, 8 months ago
In reply to Edit the forms
Thanks a lot! This will be a big help.
-
December 8, 2004 at 5:35 am #3303450
Can’t change label name
by ewarden1 · about 19 years, 3 months ago
In reply to Edit the forms
It appears that if you add a new field that you can change the displayed name but if the field is an original field that you can’t. I selected the E-mail field and properties and it allowed me to edit by when selecting “Apply” the name reverted back to the original. I can see why the field name should not be changed but why the caption?
-
-
-
July 2, 2004 at 12:08 pm #2725960
re: Change a control’s formatting with two mouse clicks
by georgewpg · about 19 years, 9 months ago
In reply to Join the Microsoft Office Suite discussion
The tip regarding copying of text box formatting from one box to another suggests a multi-step process to copy formatting, repeating the whole process for every additional box. By DOUBLE clicking the format painter button, it stays selected, and one can click field after field until all the desired format copying is done. To end the process, either press the ESC key, or click on the format painter button once more.
This trick works on other Office applications as well.
-
July 28, 2004 at 1:28 pm #2699308
Access calculation field question
by kbo · about 19 years, 8 months ago
In reply to Join the Microsoft Office Suite discussion
We have an Access 2002 database on a network share. The calculation fields stopped working a week ago, but if the database file is copied to a computer’s C: drive and opened from there, then the calculation fields do work. Any ideas of what would cause the fields to stop working in the copy of the database on the network share? The permissions on the share give complete read/write access to all who use the database.
Thanks for any suggestions for troubleshooting.-
August 11, 2004 at 8:47 am #2703486
Here’s what I did
by shane.freman · about 19 years, 7 months ago
In reply to Access calculation field question
I have had the same problem in a database I was working on for a customer. As near as we could tell it had something to do with the amount of people that were working in the database as any given point in time. My solution was to divide the database into a FrontEnd version (containing all the forms, queries and reports) and a BackEnd version (containing just the tables). Put the front end on everyone’s local machine and put the backend on the server. Then simply open the front end and link all the tables from the back end. This may slow down your data entry and querying but it solved a majority of our technical issues.
-
August 11, 2004 at 5:29 pm #2703347
Thanks for the information
by kbo · about 19 years, 7 months ago
In reply to Here’s what I did
Thanks, I’ll look into this. I’m not sure about how to set this up, but hopefully someone else at my office with more Access experience will know what to do to test this.
-
-
November 9, 2004 at 12:33 pm #3312232
General Suggestion
by gm forsythe · about 19 years, 4 months ago
In reply to Access calculation field question
As a rule, calculated fields in a table are more trouble than they’re worth. Most database designers would advise putting these into a query.
Splitting the database as suggested by the previous respondent, is of course a very necessary step. The only caveat to the suggestion of putting the “front end” on numerous workstations is that it is a bear to maintain. I generally put one front end on the server and let everyone use that. This way, if something goes wrong, or a refinement is needed, it’s much easier to do. Of course, if each user has different needs, then you WILL need numerous front ends.
-
-
August 4, 2004 at 6:39 am #2714525
Excel Print to File
by livewire^ · about 19 years, 8 months ago
In reply to Join the Microsoft Office Suite discussion
It would be nice to be able to pick the location of where Excel is printing to file on a file to file basis as opposed to having all files go to the “General” save location.
Thanks
-
August 4, 2004 at 6:56 pm #2713676
Multiple Words Rapidly
by scot · about 19 years, 8 months ago
In reply to Join the Microsoft Office Suite discussion
Desperately annoyed with Microsoft Knowledge Base Article – 203488, stating that normal.dot file corruption error is a direct result of opening too many instances of Word too quickly (article refers to 97, but same for 2000, which I’m running). Any (new) bright ideas? Say, a hack to open all (like 5) docs in one instance of Word?
-
August 11, 2004 at 6:09 am #2703586
Try this
by mddm · about 19 years, 7 months ago
In reply to Multiple Words Rapidly
Word provides a complete file management system as part of Word. One of the features of this system is that you can quickly load multiple documents in one easy step. To do this, follow these steps:
Click on the Open tool on the toolbar, or choose Open from the File menu. This displays the Open dialog box.
Instead of double-clicking on a file name, start to create a “selection set.” If you are selecting sequential files, click on the first file in the sequence, then hold the SHIFT key as you click on the last. You can add additional files to those selected by holding down the CTRL key while clicking with the mouse.
To remove files from the selection set, hold down the CTRL key while clicking on a file name you previously added to the set.
When you are satisfied with the list, click on Open.
-
January 19, 2005 at 2:39 pm #3326645
Close Many Documents at One Time
by atcollege · about 19 years, 2 months ago
In reply to Multiple Words Rapidly
If you want to close all the documents that you’ve opened without going to File, Close (or other ways) for each one, hold down your SHIFT key while clicking the File menu. You will see Close All listed. Click Close All and they all close at once.
-
-
August 11, 2004 at 4:35 am #2703623
Word Not starting printer up
by olsenbanden2 · about 19 years, 7 months ago
In reply to Join the Microsoft Office Suite discussion
In Works 2000 I could click on print in any og the works programs and the printer would wake up and start to print. Now in Office 2003 Pro. it works in all programs except in Word. Has anyone had the same problem.
John-
August 11, 2004 at 6:06 am #2703588
Try this
by mddm · about 19 years, 7 months ago
In reply to Word Not starting printer up
Printing problems in Microsoft Office Word 2003 can be specific to particular documents and templates. Create a new document and try. If this does not print close Word and rename the normal.dot to normal.old, open Word and try again.
-
August 12, 2004 at 8:15 am #2702402
Thanks But ….
by olsenbanden2 · about 19 years, 7 months ago
In reply to Try this
Thanks for your suggestion. I tried that but it still does not wake the printer up. I stil have to “wake” it up for the document to print.
-
-
-
August 11, 2004 at 8:43 am #2703491
Excel: Updating the last occupied cell
by shane.freman · about 19 years, 7 months ago
In reply to Join the Microsoft Office Suite discussion
Is there a quick fix to recalculating the last occupied cell in a worksheet. For example, if you type something in C16, hit Ctrl+Home to return to A1, then Ctrl+End it will take you to C16. If you then delete the information in C16, hit Ctrl+Home to return to A1, then Ctrl+End again, it still takes you to C16. Why does it do this and aside from closing the file and reopening, how can you fix it?
-
October 22, 2004 at 8:15 am #3309574
Save the Spreadsheet
by want-to-leave-tech-r · about 19 years, 5 months ago
In reply to Excel: Updating the last occupied cell
No need to close and re-open. Excel updates the “End” cell when you save.
-
-
August 11, 2004 at 5:35 pm #2703343
Reply to multiple Outlook messages?
by kbo · about 19 years, 7 months ago
In reply to Join the Microsoft Office Suite discussion
Is there an easy way to reply to a large number of individual messages with just one message sent to all the Senders? A user has about 1000 messages in an Outlook folder, wants to send one message to all the senders, but doesn’t want to have to add each sender to his Contacts, make a distribution list, etc. When a group of messages is selected, the Reply buttons are greyed out.
-
September 9, 2004 at 2:03 pm #2712324
Found a solution
by kbo · about 19 years, 6 months ago
In reply to Reply to multiple Outlook messages?
I found I could use Outlook’s Import/Export tool to export the senders’ e-mail addresses from the Outlook mail folder into an Excel file. Then I created a new Outlook Contacts folder and imported from the Excel file into the new Contacts folder. With that Contacts folder open, I could use Outlook’s MailMerge from the Tools menu to merge a message with the e-mail addresses in my new Contacts folder.
-
January 19, 2005 at 2:43 pm #3326644
Copy addresses into the BCC line
by atcollege · about 19 years, 2 months ago
In reply to Found a solution
Once you have the contact’s email addresses in Excel, you can copy the range containing the email addresses. Then start a new message in Outlook, display the BCC line and paste the addresses there. Once pasted, remove any non-email address text. Using the BCC line prevents the looooonnngggg To: information from showing.
-
-
-
August 18, 2004 at 7:48 pm #2704858
Can’t see the insert pictures in a word doc
by olsenbanden2 · about 19 years, 7 months ago
In reply to Join the Microsoft Office Suite discussion
I opened documents that I have saved in my documents folder, and they have pictures and clipart insert on the documents. Now I can not see the clipart or pictures any more when I open the documents, but if I print the document out they are on the printout.
I even tried to reinstall my Office XP 2002 Small buisiness Version, without any change.
Can any one help me with a solution.-
August 19, 2004 at 8:08 pm #2710673
Found a solution
by olsenbanden2 · about 19 years, 7 months ago
In reply to Can’t see the insert pictures in a word doc
I made a clean install of OS (Win XP Home) and all other programs and now it works again. If anyone know what happened I would like to hear from them.
Thank you
John-
October 20, 2004 at 4:07 pm #3309855
Picture Placeholders
by gmlusby · about 19 years, 5 months ago
In reply to Found a solution
The reason for pics not showing could be that you had “Picture Placeholders” box checked under Tools, Options, View. (That is where it is in Word 2000.)
If checked, pic frame margin will show on screen but not picture. It will print with picture though. Sounds like this is what happened maybe.
Greg
-
-
-
August 20, 2004 at 1:09 pm #2709750
Excel Hide & View Buttons left of Row #s
by ltbrehmer@customerselects.com · about 19 years, 7 months ago
In reply to Join the Microsoft Office Suite discussion
I have a user with an old excel work sheet brought forward from as far back as 1992. It contains records of amounts given to different individuals. It has each individual listed separatley with totals at the bottom of each individuals section. It has on the left of the row numbers another column with what appears to be able to toggle between hide the contents and just view the totals or to view all the entries.
There is not a right click menu for this added column. at the top of the column are two buttons one that hides all the data exdept the totals and the other that shows all the data. Each individual has a plus sign left of the row # for that idividual. this will open and close the view of just that individual. The file has no known macros associated. This is very difficult to explain. I do not know how this was accomplished. Is this an excel tool or has someone monkied with the code. If someone can lead me in the rigth direction I would be very greatful-
August 25, 2004 at 7:13 am #2711769
could be the SUBTOTAL function
by rick_from_bc · about 19 years, 7 months ago
In reply to Excel Hide & View Buttons left of Row #s
In Excel under the menu DATA, there is a subtotal function.
What you describe sounds pretty much like that.Good luck.
-
August 26, 2004 at 3:39 am #2710165
… or manual use of group/outline
by dblayney · about 19 years, 7 months ago
In reply to could be the SUBTOTAL function
The same effect can be created manually by using the Group and Outline function (Data:Group and Outline:Group to do it the hard way or use Auto Outline for the easy option). Used either with the SUBTOTAL function or the AutoSum the same effect as described in the original post can be achieved.
-
-
January 19, 2005 at 2:53 pm #3326641
Agree with Subtotals Theory
by atcollege · about 19 years, 2 months ago
In reply to Excel Hide & View Buttons left of Row #s
Isn’t it fun inheriting old work? If that extra column on the left side has +’s down the left and at the top of that extra column numbers like 1, 2, 3, that will contract or expand each group, you most likely have Subtotals turned on. In order to turn them off, click in any raw data cell, then click on the Data menu and select Subtotals… and in the resulting dialog box, click Remove All. Ahhhh.
-
November 17, 2005 at 1:41 pm #3132429
hide and view buttons
by deadhead ’59 · about 18 years, 4 months ago
In reply to Excel Hide & View Buttons left of Row #s
The Data menu is the right direction, but you need to use the group and ungroup commands. If you highlight the rows under your “heading row” (the one you want to stay visible all the time) then click Data\Group and Outline\Group, it will add the plus sign and show the grouped rows with a bracket. Very handy feature!
-
-
September 9, 2004 at 9:58 am #2718248
Access: Mail Merge
by mathtchr · about 19 years, 6 months ago
In reply to Join the Microsoft Office Suite discussion
We would like to create an Access 2000 database and use that data to create mailing labels and form letters for all entries or selected entries in that data. Any good training materials would be appreciated.
-
October 15, 2004 at 3:10 am #3307200
Access Mailing Lables
by retiredteacher · about 19 years, 5 months ago
In reply to Access: Mail Merge
The easiest way to print labels in Access 2K is to use the Access Label wizard.
1. Create a Select Query to choose your labels. Save your query as qryLabelsForWhatever.
2. Go to forms object and click New; Label Wizard. Be sure to select the above query to base your report on, and your label size (Avery No.).
3. Design and save your report (rptLabelSomeName).
4. Run your report. You can then include a cmdButton in your form to run it automatically.If you want individual labels:
1. You can either copy and rename the above select query (or create a new one) and put your list of individuals in the criteria grid save and name it.
2. Open your report (rptLabelSomeName) and change the ControlSource to the new name – if you created a new one.
3. Run your report with just the individual names (from the criteria) printing.The only problem with this is your individual names will always start in row 1 column 1 of your label sheet. I do remember seeing some coding the will allow you to choose what row and column you want to start the printing, but I can’t put my eye sight on it right now. It’s someplace on my computer. If and when I find it, I will try to post it to you or if you give me your email address, I will send it directly to you. You can email me directly to rraszk@direcway.com.
Richard – Retired computer instructor
-
November 9, 2004 at 12:16 pm #3312239
Slight refinement
by gm forsythe · about 19 years, 4 months ago
In reply to Access Mailing Lables
I’ve found that adding a Boolean (Yes/No) field to a table is very handy. Then you can scroll through your table and check off the ones you want to include in a mailing or whatever. This is for those times when it is not easy to make a query but that you want to pick and choose according to some criteria not easily expressible in SQL, such as “Which of my friends do I want to send ‘Happy St. Patrick’s Day’ cards to this year?” You can then base your label query on the value of the Boolean field. If you want to re-do the whole business, you can write an update query to change all values to No and then check off the ones to go with for the NEW list, such as “Who owes me money that I want to collect this month?”
-
-
-
September 15, 2004 at 1:27 pm #2707219
Office Workgroup Templates – Subfolders and Shortcuts
by ibexscribe · about 19 years, 6 months ago
In reply to Join the Microsoft Office Suite discussion
I came across an interesting situation with Workgroup Templates, specifically in Word, but I would assume that the rest of the Office suite would experience the same issue. We have a rather complex network template system with folders and subfolders for departments and subunits within departments. To simplify our lives, we use shortcuts to other folders and shortcuts within folders to master copies of the templates so we only have to make changes in one location. As helpful as this is, I discovered that it can also cause some problems, some which we have solved and others which we have no idea how to solve.
*Beware of circular references! Word will open one level of subfolders under the main template folder. If the subfolder contains any shortcuts to other folders, Word will show the templates located in the folder for which there is a shortcut in addition to the templates in the said subfolder. This is great, unless the subfolder contains a shortcut to itself at any level. What then happens is Word will show multiple copies of the same template. I have seen 12 copies each of three templates in a tab for a folder that contained only three templates. Word may also show the same template 30+ times and not show any of the other templates in the folder. Word may also decide that it just doesn’t like the circular reference and won’t show any templates for that tab.
*Templates may not appear or may appear twice. This is still baffling to me and I can’t find any information about what to do with the problem. For specific users, templates may appear twice in the same tab in Word when only one copy of the template is present in the folder. Has anyone come across this? I have not been able to figure out why it is happening. Other users are not able to see one or two templates, even if they are saved locally in the user template location. Does anyone know how to fix this problem? -
September 29, 2004 at 10:25 am #2721233
Word Suggestion
by nondrakhali · about 19 years, 6 months ago
In reply to Join the Microsoft Office Suite discussion
I would really like to be able to select text and use a hotkey to put quotes or parens around it. Possible?
Nondra Khali
nondrakhali@grant.k12.ca.us-
October 13, 2004 at 8:18 am #3306825
Macro Code
by wolfie x · about 19 years, 5 months ago
In reply to Word Suggestion
You can create subprocedures with code similar to the following:
With Selection
.Text = “””” & .Text & “”””
.Collapse wdCollapseEnd
End WithWith Selection
.Text = “(” & .Text & “)”
.Collapse wdCollapseEnd
End WithYou could use Record Macro to create the procedures and assign hot keys, then clean up the code if you are comfortable doing so.
-
January 19, 2005 at 3:06 pm #3326636
Macro May Be the Thing
by atcollege · about 19 years, 2 months ago
In reply to Word Suggestion
How about creating a macro to do each thing? Make sure it is a “global” macro and assign the macro to a keyboard combination, like Alt + )
I would assume that you need to select the text FIRST before trying to create the macro.
-
-
November 9, 2004 at 12:23 pm #3312236
Access Annoyances
by gm forsythe · about 19 years, 4 months ago
In reply to Join the Microsoft Office Suite discussion
When designing forms, Access defaults to showing Record Selectors and Dividing Lines. I forgot how to automatically delete these things, but I would like to know what, if any, purpose(s) they serve. I have always found them extremely annoying and unuseful.
Any responses would be helpful.
-
November 10, 2004 at 9:35 am #3313291
Look in the Form’s property page
by el guapo · about 19 years, 4 months ago
In reply to Access Annoyances
Go to the Form’s property page. On the FORMAT tab, find the RECORD SELECTORS and DIVIDING LINES category and set them to NO. The Record Selectors are there so you know which record is on focus. Dividing Lines…who knows? I usually set these properties to NO anyway.
-
November 16, 2004 at 8:36 am #3311637
Thanks But
by gm forsythe · about 19 years, 4 months ago
In reply to Look in the Form’s property page
I know how to eliminate them from forms; I just can’t remember how to set Access so that the DEFAULT is “No” to both these annoyances.
Thanks for your help.
George
-
November 24, 2004 at 9:50 pm #3293446
Check This Out
by micjones · about 19 years, 4 months ago
In reply to Thanks But
Look under “Creating a New Template for Forms and Reports” at:
http://eis.bris.ac.uk/~ccmjs/accform.htm
-
-
December 22, 2004 at 1:02 pm #3300436
Using a form template
by lamalcz · about 19 years, 3 months ago
In reply to Access Annoyances
Make a blank form and set all of the default properties as you please. You may want to make at least two, one for Master and one for Sub forms.
Save them with a nice name like ZMaster and ZSub.
Now go to Tools:Options:Forms/Reports and make the Z… form the default template for forms. Be careful, make sure to change the default form when you switch from master to sub form creation.
-
-
November 23, 2004 at 10:50 am #3304887
XP Office and Activation codes
by andeanderson · about 19 years, 4 months ago
In reply to Join the Microsoft Office Suite discussion
I am preparing to rebuild my system, to clear out some problems with my XP Pro and XP Office that have been adding up for the last couple of years, before installing the XP SP2.
I know that XP Pro uses a file, wpa.dbl, to store activation information and that by copying and then restoring this file I do not have to go through the Activation over the phone route with Microsoft.
Does XP Office also use such a file? If so, then what is it? I ask because the original Key Code was invalid and the people I got the system from had to give me a second Key Code to activate my Office XP. Unfortunately, due to my failing to file the information in the correct place, I cannot find the updated activation code.
Thanks
-
February 2, 2005 at 4:29 pm #3343852
I need same information – save OffXP activtion
by mspatel · about 19 years, 1 month ago
In reply to XP Office and Activation codes
Please email me your answer as I have similar problem including Content Advisor not filtering rated sites.
mukesh111@hotmail.com
-
-
January 5, 2005 at 8:06 am #3313968
Excel
by lori · about 19 years, 2 months ago
In reply to Join the Microsoft Office Suite discussion
I know this is an easy question, but I am having a block. I have a pivot table with numbers like 3 digit codes in column A this code only display when it changes, 6 digit numbers in column B again this number only displays, and 4 digit account numbers in Column C. I need to put this information on another worksheet, on this worksheet I the 6 digit number column A, I already have the 3 digits code on every row in Column B and depending on the account number I need that is Column C or D. How do I write this?
-
January 12, 2005 at 5:09 am #3346151
Outlook Images
by roybcarter · about 19 years, 2 months ago
In reply to Join the Microsoft Office Suite discussion
Recently many users have complained that images sent in email no longer open from Outlook. They have to save to HD before they can open the images. Is this a security feature or has something changed on their machines. We have a mix of Outlook 2000, XP, & 2003-not to mention MS Office for Mac of various flavors.
-
August 5, 2007 at 2:46 pm #2635806
Animated gif in outlook
by gamber52 · about 16 years, 7 months ago
In reply to Outlook Images
I have the same problem in sending animated gif in outlook. What I can do in extracting the gif from the mail and send it as attachment?
Xp sp2, office 2000.
Thank you for your support
-
-
January 12, 2005 at 7:08 am #3346095
Outlook 2003 Printing Question
by rchuch · about 19 years, 2 months ago
In reply to Join the Microsoft Office Suite discussion
In Outlook 2000 I could print attachment and Bcc information, However, in 2003 this information does not print. Can someone advise what has to be done to print this information.
-
January 19, 2005 at 3:22 pm #3326633
Print Message and Attachment
by atcollege · about 19 years, 2 months ago
In reply to Outlook 2003 Printing Question
Print an e-mail message and attachment
Select the messages you want to print.
How?To select adjacent items (item: An item is the basic element that holds information in Outlook (similar to a file in other programs). Items include e-mail messages, appointments, contacts, tasks, journal entries, notes, posted items, and documents.), click the first item, and then hold down SHIFT and click the last item.
To select nonadjacent items, click the first item, and then hold down CTRL and click additional items.
To select all items, click the Edit menu, and then click Select All.
Note Changing the view (view: Views give you different ways to look at the same information in a folder by putting it in different arrangements and formats. There are standard views for each folder. You can also create custom views.) for items can make selecting specific items easier. For instance, if you want to select all messages that have the same subject, in the folder containing the messages, on the View menu, point to Arrange By, and then click Conversation. Select the messages you want from the view.On the File menu, click Print.
To print attachments, select the Print attached files check box.
Note Attachments will print only to the default printer. For example, if you have printer A set as the default, and you open a message with an attachment and choose to print the e-mail to printer B, the message will be sent to printer B, but the attachment will go to printer A.(Microsoft’s Help is a wonderful thing!)
-
January 20, 2005 at 6:24 pm #3328394
Clarification of Question
by rchuch · about 19 years, 2 months ago
In reply to Print Message and Attachment
I guess I was unclear with my request. I understand how to access an attachment and print its contents, however, I am interested in having the attachment’s file name that is displayed with an e-mail printed as well as the information in the bcc field printed when I print an individual e-mail message for my records. Both these pieces of information are not printed when I print an e-mail that contains these fields.
Thanks
-
-
-
January 12, 2005 at 10:13 am #3346013
Which is better Microsoft Works or Word
by csdon47 · about 19 years, 2 months ago
In reply to Join the Microsoft Office Suite discussion
Which is better to own and use Microsoft Works or Microsoft Word. I thought that Word came with my computer but I was surprised when the trial version ran out. Now I only have Works and it is different than Word.
-
June 3, 2005 at 4:04 pm #3170484
What’s a demo for?
by jerry~beans&bytes · about 18 years, 10 months ago
In reply to Which is better Microsoft Works or Word
Why do you think they gave you a demo of Word?
So that when your demo expired, and Works wouldn’t do what you were used to doing, the way you were used to doing it, you would pay to get Word back.
-
-
February 9, 2005 at 5:42 am #3337035
Outlook2K3 – sync PSTs on separate PCs
by gwk · about 19 years, 1 month ago
In reply to Join the Microsoft Office Suite discussion
I run a very small business – no Exchange server, just POP3 to email accounts. I have two PCs and want to be able to use either to access emails – stored in the (local) PST file and download to it. I’ve tried sharing the PST file over a local network, but that corrupts the file (as it is the main Inbox/Outbox etc delivery location). Any ideas on how to sync the two files without ocrrupting them, so both PCs can have emails/contacts/tasks etc in sync?
-
February 11, 2005 at 2:43 am #3338231
Problems installing Digital Certificates for Outlook users
by gwk · about 19 years, 1 month ago
In reply to Join the Microsoft Office Suite discussion
I have been using a public digital certificate provider, and downloading digital certificates (public + private) through IE to the user’s PC. In all situations the installation is stated as complete and OK. On some PCs, that leads to Outlook being able to send digitally signed emails just fine (and then handle incoming encrypted emails), but on other PCs Outlook cannot find the private part of the certificate and so refuses to sign outgoing emails. On these PCs, going back to IE and trying to export the complete certificate also fails – the private part is apparently not available. I am looking for why this happens and how to fix it – the certificate provider won’t permit multiple downloads (for obvious security reasons) so it gets expensive getting new certificates when the downloads have apparently worked OK but actually fail on the client device. Environment: Win2KPro, Outlook XP or 2K. Any thoughts welcome.
-
April 7, 2005 at 1:13 pm #3234059
Macro -Stop Recording tool bar missing
by foxfire2010 · about 18 years, 11 months ago
In reply to Join the Microsoft Office Suite discussion
Whenever I records a Macro the floating “Stop Recording ” toolbar does not pop up. Therefore I am unable to use the relative function when recording a Macro.
I have tried an activate and Repair – but that did not make any difference.
anybody have any suggestion, what I need to do in order to bring the toolbar back?
I am using Excel XP-
May 31, 2005 at 7:08 am #3180563
“Recovering” Macro Stop Recording Toolbar
by david.hanshumaker · about 18 years, 10 months ago
In reply to Macro -Stop Recording tool bar missing
That toolbar may no longer be meant to automatically pop up when recording a macro. To add it permanently to your standard toolbars, customize your toolbars. On the Toolbars tab in the pop-up box check the Stop Recording toolbar. When you close it will appear permanently on your toolbars above the worksheet.
-
-
May 18, 2005 at 6:22 am #3237554
Microsoft Office Suite
by i,technician · about 18 years, 10 months ago
In reply to Join the Microsoft Office Suite discussion
We use the Microsoft Office apps for everything. I am looking for a good source that will explain how I can use individual apps together for more effective work, colaboration and communication. Any advice?
-
June 2, 2005 at 2:28 pm #3172066
need more info-what are you trying to do?
by jerry~beans&bytes · about 18 years, 10 months ago
In reply to Microsoft Office Suite
wow, that’s a big question. some more info on where you are vs. where you want to be might help.
for instance (excuse me for subbing off your thread): I am a competent SQL guy, currently using M$ Access, and I have come to the point where I think I need to learn some Visual Basic to make my Access database app. do what I want it to do. I have some limited programming experience, but I am an accountant, not a programmer, and I’m too d*** old to change career paths.
Anybody know any reference materials that might help me?
p.s- i have this set up as a 250-point question under Programming in Technical Q&A section
-
-
July 21, 2005 at 10:05 am #3193896
Can anyone make Word 2002 Reviewing toolbar go away?
by david.hanshumaker · about 18 years, 8 months ago
In reply to Join the Microsoft Office Suite discussion
When using Word 2002 the reviewing toolbar automatically pops up everytime I open or work in a document. I always have to go to View->toolbars and uncheck it. Does anyone know why this happens or how to prevent it? Can’t say how annoying this is.
-
August 4, 2005 at 3:08 pm #3050701
Using quotes
by jim l m · about 18 years, 8 months ago
In reply to Join the Microsoft Office Suite discussion
In writing I frequently must go back and put text in quotes. I do not thik this problem is unique to me. I am surprised that Microsoft has not come up with a ‘highlight, enclose in quotes’ command.
Are there any simple shortcuts to doing this other than inserting hte quotes and the appropriate punctuation?
-
January 11, 2006 at 6:24 am #3079614
Excel – Sort by color
by giboya · about 18 years, 2 months ago
In reply to Join the Microsoft Office Suite discussion
Hi,
Is there a way to sort a column in Excel that has cells that have a fill in color?
Thanks……-
January 11, 2006 at 11:19 am #3079389
Possible source of an answer
by funtoknow · about 18 years, 2 months ago
In reply to Excel – Sort by color
Go here for some helpful advice:
http://www.pcreview.co.uk/forums/archive/forum-275-29.php-
March 26, 2006 at 12:13 pm #3100236
how to do this
by asd1023456 · about 18 years ago
In reply to Possible source of an answer
could u send me how?
-
March 26, 2006 at 5:27 pm #3100204
how to do this
by giboya · about 18 years ago
In reply to how to do this
Hi,
I recently discovered that I am able to sort rows in Excel by colors by installing a free utility from http://www.asap-utilities.com.
Good luck!
-
-
-
-
AuthorReplies