Discussion Locked

Office suite Q&A

0 helpful
135 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Attention Office suite users and support analysts! Do you have questions about using or supporting Excel, Access, or Word? Use this space to post your Office suite questions, offer your comments on the Office suite TechMail tips, or to suggest future tips. We want to hear from you!

If you're not a subscriber to the Office suite TechMail, check it out here under Technical Tips:
https://www.techrepublic.com/techmails.jhtml?repID=r001

135 replies

by discussion

Just to keep things organized, we'll divide this thread into (at least) three different sections. Post your Access-specific questions under this subthread.

by 61mustang

We have several multi-page reports that need the first page on letterhead and the other pages on plain paper. Does Access 97 have a way to do this like what is available in Word where you can pick different paper sources for different pages? I have not been able to find a way for this to work.

by jamesrobinson

Both DB1 and DB2 are Access 97 DBs.

DB1 - Security is set. User has no permissions to use tables. Users access the tables by queries RWOP.

DB2 - Security is set. Different workgroup file.

From within DB2 using the - Dim dbe As PrivDBEngine- I access records from a table utilizing the users RWOP in DB1 by - Set rst = dbs.OpenRecordset("qry_EditRecords") and build a table and report from the records returned by the query.

While in DB2, sometimes there is a need to edit records in DB1. When the user is in DB1 the user uses "qry_EditRecords" to edit records.

My question - is it possible from within DB2 to use "qry_EditRecords" from DB1 as the recordsource for a form in DB2?

Thanks

by technologyisyourfriend

I want to fill in a field in Access with an "if, then" statement and I know how to do it in Excel, but it doesn't seem to work the same in Access. (Access 97.)Can someone tell me how to do this?

by learneverything

If you are trying to do it in a query, it would look like this:

=Iif(test,truepart,falsepart)

For example

=Iif([FieldName] = "yes", "yes", null)

I hope that helps you.

by msquared1

If / Then can be done in two ways
1 is by using VB event call and the following should work....

If Forms![Quote Entry].SumOfPremiums = Forms![Quote Entry].QuotePremium Then

GoTo Yes_PrintScheduleReportButton_Click
Else GoTo Ask_PrintScheduleReportButton_Click
End If.

If you wish to use an function (one of the Access Built-in ones) to do some logic then the following function can be used...

IIf Function

Returns one of two parts, depending on the evaluation of an expression.

Syntax

IIf(expr, truepart, falsepart)

The IIf function syntax has these named arguments:

Part Description
expr Required. Expression you want to evaluate.
truepart Required. Value or expression returned if expr is True.
falsepart Required. Value or expression returned if expr is False.

Remarks

IIf always evaluates both truepart and falsepart, even though it returns only one of them. Because of this, you should watch for undesirable side effects. For example, if evaluating falsepart results in a division by zero error, an error occurs even if expr is True.

Check out the help that comes with MS Access (it is invaluable if you are new to programming).

Hope this helps..

m

by paul

I'm fairly new at access programming (not new to programming though) but I can't find any information on what I want to do ...

I have several queries that require the user to input a date range (2 date fields) when they are invoked.

I have created a form that will allow the user to define the date range (2 fields) as well as check the queries they want to run (all of the queries require the 2 date fields). How do I inject the date field values into the queries using DoCmd.OpenQuery? Or do I have to run the queries using DoCmd.runSQL?

Thanks

by jamesrobinson

In your date field in the query grid try -

Between Forms!YourFormName![Your1stControlName] and Forms!YourFormName![Your2ndControlName]

by Member 25088450

In your query under date (or whatever you call the field) enter the following criteria

Between [Type the Begining date:] And [type the ending date:]

by karen_terminiello

No module programming necessary ...
In the criteria of a query you can have references to the values on a form.
You have to know the "name" of the controls you've added to the form where the user inputs the start date and the end date values.
I'll call the Form InputForm and I'll call the fields on the form StartDate and EndDate ...
In the criteria row of the query, under the date field that you want to query on, you would type:
Between ([Forms]![InputForm]![StartDate]) And ([Forms]![InputForm]![EndDate])
That will use the values entered into those fields on the form as the input parameters for the query.

by tj23

We're using Access 2000 and SQL 7.0. One workstation is unable to 'upsize' Access databases to SQL. Users can log onto other workstations and use the Upsizing Wizard successfully so the problem doesn't appear to be related to Access or SQL security rights. The wizard appears to run correctly but the report always states that all the tables have failed to upsize. We've tried to reload Access and SQL Enterprise Manager on the workstation but upsizing still fails. Any suggestions?

by discussion

Just to keep things organized, we'll divide this thread into (at least) three different sections. Post your Excel-specific questions under this subthread.

by mlbrown

I find it a lot less trouble when wanting to refer to a cell in another worksheet to enter equals (=) and then point at the wanted cell - EXCEL does amuch better job than me at entering all the desired excalmation marks etc.

by peternp

The "Point and Click" feature is a very good habit to refer to other cells. That can be done in formulas and other relevant windows. It prevents typing mistakes too.

by ssctechman

I do have a specific question- some of you gurus out there may have an easy answer. I keep a spreadsheet with much daily information, but I also keep a month-to-date average in many cases. If I enter the first two or three cells (example: =AVG(B2:B3), =AVG (B2:b4), =AVG (B2:B5) and so on), I'd like to then auto-fill the rest of the column. However, Excel doesn't seem to understand I want to end up averaging from B2 to B33 (in months with 31 days), and as I recall copies the formula incrementingby one cell. Does anyone have a solution so that I don't have to enter or edit each cell down the column?

by janesdtr

Have you tried turning B2 into an absolute reference, $B$2, so that Excel doesn't increment that cell as you autofill the formula?

Janie

by teddybear99

If you make the first reference in your formula a static reference (by adding a $ in front of both the row letter & column number) then when you fill down it the cell numbers will not change.

=AVG($B$2:B3)

then when you fill down only the B3 will change to B4, B5, B6 ...

by peternp

Have you tried to make the reference to B2 absolute (e.g. ($B$2:B3) and then copy the formula across?

You can also use an IF-statement, where if the date is in the future, it leaves it blank, otherwise it will execute the calculation
(e.g. =IF(b2

by kmackinnon

What about if you make the formula look like this:

=AVG($B$2:B3)
=AVG($B$2:B4)
=AVG($B$2:B5)
Then drag to auto fill? That way it will know that you do not want the row or the column for B2 to change as you auto fill.

by waldengr

i want to insert new rows immediately above a calculation row, and have the inserted row included in the calculation.

suggestions?

thanx

by firstpeter

I don't believe Excel, by default, will allow you to include the row you inserted right above the calculation in the calculation without intervention.

However, having had to deal with similar situations, I've developed a solution that makes the spreadsheet slightly more readable, as well:

Suppose you have data in rows 2-10. Row 11 is blank, with a height of 2. Row 12 is your calculation row, calculating rows 2 through 11. When you insert data to the bottom of the list you highlight row11 (which looks like the bottom of the list) and insert.

Your calculation is including row 11 (blank), so anything you insert above that is included, as well (provided it's below 2).

by nhicks

Leave one blank row above the calculation row. When you insert a new row, insert on the blank row.

by thechas

Anyone have any good links to aid PROFICIENT Quatro (Corel) users in migrating to Excel?

For that matter, how about an article with migration tips and command comparisons.

Chas

by waresfamily

Is it possible to add the contents of a cell to the custom header of footer? Something like "The week ending "+Sheet1!$A$1

by firstpeter

Sub Comments_To_Header()
On Error Resume Next

ActiveSheet.PageSetup.RightHeader = ActiveCell.Comment.Text
End Sub

Take a look at the code above. Setup a button to automatically run the macro when clicked (or find the macro from Tools->Macro->Macros), and it will put whatever comments are in the active cell into the header (right side).

by melissahughes

How do I create a checkbox in Excel? The Help was not specific enough. I did manage to get one on the spreadsheet, but when clicking the spacebar to "check" it didn't work.

by firstpeter

There are actually two ways to do it, depending on what you're after as an end result. The one I find myself using more often for basic use is achieved via the following:

1. Go to View->Toolbars and select the Forms toolbar.

2. On the Formstoolbar you'll see a checkbox. Click that, and place your checkbox on your sheet.

3. Right-click on the border around the checkbox, and select Format Control (if the border disappears, click somewhere else on the sheet, then right-click on top of the checkbox again).

4. On the "Control" tab you'll see a box that says Cell Link to the left. In that box you can put a cell reference (e.g., "A1" without the quotes) that will change from TRUE (checked) to FALSE (unchecked) when the box is used.

If all you're after is a check box, you don't need #4. However that step adds some functionality to your spreadsheet that may come in handy.

by winlak

Unprotected it is 600kb. Protected it is 6megs! Is this to be expected? Is there a way to keep the protection and still have the size under 1meg?

by mmc akron

I have a spreadsheet I post to a Public folder in Exchange twice a day. I tried to record a macro to automate this with no success.

Can anyone help me figure out how to write a macro to do this?

by webwoef

Hi,

Since service pack 3 in win 2K we cannot open files that are on our server. We get the same error as we would try to save on it with long filenames (longer than 8.3).

We think that behind the scene MS Excell opens a copy of the file and gives it tempory a name that is longer than 8.3 ("copy of blabla.xls")

I tried to remove sp 3 but, it wasn't fixed.

Is there a registry key where we can disable this automatic "copy of blabla.xls" thing ?

by jim.coyle

I have spreadsheet that have lines with a value of zero that I want to remove from a master parts order spreadsheet. Anyone have a marco to remove/delete all lines with a sprecific value in a cell.

by discussion

Just to keep things organized, we'll divide this thread into (at least) three different sections. Post your Word-specific questions under this subthread.

by malosa

This is kind of a silly question, but why is it when I create a .dot template on the network, and I open it out of windows explorer it opens into a new document. However, when I open it out of Word (file/open) it opens the .dot.

I know I should know the answer, but I'm stumped.

by coxdj

Instead of using "File/Open" to open a template try using "File/New". This will open a new document based on your template. By using "File/Open" you are telling Word that you want to open the actual template and edit it.

On our network, I created a folder in which I store all the templates used by the users in my office. I then set up word to look at that folder when user clicks "File/New" the "New" document dialog box appears and the user can choose which template to use. Double click on the template and a new document based on that template opens.

In order to point word to your templates folder on the network do the following:

1. Open a blank document;
2. Click the "Tools" tab;
3. Click "Options";
4. In the "Options" dialogue box click on the "File Locations" tab;
5. You will see a list of different file locations; highlight "Workgroup Templates";
6. Click "Modify" and find the folder you created on the network;

The benefit of doing this is of course that you can go edit the template and it will change the template for everyone.

There may be a better or more efficient way (if so I'm all ears) to do this but I know this works. Hope this helps you out.

Dale Cox
Gunnery Sergeant
U.S. Marine Corps
Legal Assistance Chief
Okinawa, Japan

There may be a better

by whyjillwhy

If you want to open the actual template from Explorer (rather than a copy), you can just right-click on the file name and choose open. If you merely double-click on the file name, it will only open a copy.

by Member 25088450

File open:: is just that it open the .DOT as a document you can make corrections and save them.

File new:: select tempplate name and you get a new documment based on that template.

by isrick

we use word from office 97 and need a address book to print lables and the like we do not have exchange at this time

what can we do?

by computerjack

I'm not sure about Word 97, but in Office 2000 the MS Word program is loosly integrated with the address book in Outlook Express or Outlook. Why create an address list in Word or even Excel that is difficult to manage when you have one that is mucheasier to manage? An alternative could be to create a address book in Access which can also be linked to MS Word.
Good Luck.

by nedster

If printing labels is your primary task, have you tried the mail merge wizard in Word? It actually has an "address book" database that can be used specifically for formletters, envelopes, and labels. If you have Excel you can also use it to create amailing list and then use it in the mail merge process to generate labels. The merge wizard in Word, however, may be more user friendly for you. To lean how to use it go to your HELP in Word and search for MERGE or MAIL MERGE to look up the step-by-step instructions. You will find the merge wizard under the TOOLS menu in Word.

by bill_stephensca

When printing my printer's device options show "Presentation", "Normal", and "Fast" as the options with "Normal" being the default. But I almost always use the "fast" setting. Is there anyway to make word use this as the default setting?

by jeremy.lutley

One of my users wishes to print part of a Word 2000 document in landscape format on A4 paper. The default setting is for A4 but when she selects the landscape option under page setup the system complains that the margins are outside the printing area and gives you the option to ignore or fix. Fixing it does not solve the problem. A re-installation of Office did not cure the problem, does anyone know how to resolve the problem?

Thank you

Jeremy

by paulthompson

Jeremy:

What printer are you using? Has the user changed BOTH the page setup in their document AND in the printer dialogue to landscape? It sounds like the printer is still trying to print portrait while Word prints landscape?
Forgive me if thisis oversimplifying the possible problem.

Paul

by growan

Jeremy

It appears to me that the document needs to be separated into "sections" to enable portrait or landscape orientation to the selected under the "File/Page Setup" dropdown menu selection. The landscape component of the document would form asection and allow the page orientation to be set accordingly. Word help "Sections and Section Breaks" may be of assistance.

Gerry Rowan
Hurlstone Park
Sydney, Australia

by daniel.yanez

Can anybody help me with a mutiple page template? I want to prompt the user to enter information one and the that same information to be filled in all pages. I have used the "Fill-in" and "Ask" features but I'm doing something wrong and can't get itto work right.

by wolfie x

You can insert Ref fields (REF [BookmarkName]) to reference the original Ask field value.

by jardinier

A friend wrote his resume on Word 97 and sent it as an attachment to the prospective employer, who said his computer could not open the Word 97 document.
Now I know from personal experience that Word 97 can read Word 2.0, and that Word 2000 can read Word 97.
So is it possible that the recipient of the document could not open it because he has Word 2002, or perhaps he has Windows XP? I would have thought that the document could at least have been opened in RTF.

by isrick

this was do to a bit lose in the transit not a office thing there was no fix just a resend

by jardinier

Thanks for your postings. In the meantime, apparently the recipient has successfuly opened the document.
Again, many thanks.

by tonygum

In Win98 when I placed the cursor on a .doc file in Windows Explorer, I got an info block with some of the Summary data such as Author, Subject, Title ect. After I had to re-install Office 97, I no longer had this feature. I've looked through all the Office settings and the registry but I can't find a way to turn it back on.
Anyone know the answer?

by cricket4b

Go to Windows Explorer, View, Folder options. Under the tab View, files and folders, check the box next to Show pop-up description for folder and desktop items. Hit apply and you should then see the properties when you hover on a file.

by sctang73

scenario: LAN has workstations made by Gateway, Dell and Compaq. Processors range from P2-400 to P4 2.0GHZ All workstations have 10/100 NIC's & almost all meet or exceed the "reccommended" RAM and hard drive requirements for their respective operating systems

OS used: Win98SE, WinME, NT4 WS w/ SP6a, Win2k Pro w/ SP3 & WinXP Pro w/ SP1. All have IE 5.5 sp2 or higher and have the latest OS, and browser patches

Productivity Suite: this is the painful part - all workstations have MS Word 2000or XP/ 2002. HOWEVER, not all workstations use Office 2k/ XP. about half of the workstations installed MS Word 2k or XP/ 2002 via MS Works v6, v2k, or v2002. All the latest service packs/ patches have been applied.

Problem: many MS Word documentsare still saved in v6 or Word 95 format.

Users have no problem accessing or editing these aged documents. However, if they (mostly WinXP Pro users) do not access the file in a while (bathroom break or whatever other reason), they risk random dataloss via a loss of the LAN connection.
It's the darndest thing as it only seems to happen when users are working in MS Word (no matter which version). The NICs test out to be OK & have the latest drivers. The cables and hubs/ switches/ routers arealso fine (updated applicable firmware to be safe). Autosave in MS Word has been set to 1 minute, and general powersave features have been disabled, especially for the NIC. All workstations in question have been routinely checked for viruses and badsectors.
Have tried to duplicate problem w/ o MS Word running, but failed (had IE, Netscape 4x, MS Outlook 98/ 2k/ XP active). It has been basically confirmed that only MS Word is having any problems.
The File & Print Server is running Win2k SBS, w/ the Exchange service also active for internal mail and external mail (via SDSL). All applicable service packs/ patches are installed, and the antivirus software (McAfee v4.5) is

by sctang73

scenario: LAN has stations made by Gateway, Dell & Compaq. Processors range from P2-400 to P4 2GHZ. All stations have 10/100 NIC's & almost all meet/ exceed "reccommended" RAM & HD requirements for their respective OS
OS: W98SE, WME, NT4 WS SP6a, Win2k Pro SP3 & WinXP Pro. All have IE 5.5 sp2 or higher; latest OS & browser patches applied
Productivity Suite: painful part - all stations have MS Word 2000 or XP/ 2002. HOWEVER, not all stations use Office 2k/ XP. ~50% installed MS Word 2k or XP/2002 via MS Works v6, v2k, or v2002. latest service packs/ patches applied.

Problem: many Word docs still saved in v6 or v95 format.

Users have no problem accessing/ editing these aged docs. However, (mostly WinXP Pro users) files are inactivefor a while (bathroom break & etc), random data loss occurs via loss of LAN connection.
Only seems to happen in MS Word (version irrelevant). NICs are OK & have latest drivers. Cables, hubs/ switches/ routers also fine (updated applicable firmware to be safe). Autosave in MS Word set to 1 minute, & general powersave features are disabled, especially for NIC. All stations in question routinely checked for viruses & bad sectors.
Unable to duplicate problem w/ o MS Word running, (IE, NS 4x, Outlook 98/ 2k/ XP active). Basically confirmed that only Word is having any problems.
F&P Server running Win2k SBS, w/ the Exchange service also active for internal & external mail (via SDSL). All applicable service packs/ patches installed, & antivirus (McAfee v4.5) is updated & set to default level of protection.
Suspicion: multiple "obsolete" versions of word docs causing autosave problem.
Solution?: "upgrade" all Word docs to v97+; have not been successful convincing users yet.

Comments/ suggestions/ insights/ criticisms are welcome.

by ralphm1

Running Office 2k SR1 and Windows2K SP3, Word is crashing when someone uses File menu, Sendto as Mail attachment. Not all people see this, just a few. Anyone seen that before? I've reloaded machines, deleted user profiles, it seems to come back to the same people after I clean it up.

by mrkilby

Whenever some of my users try to save the y get the "unable to load resource Library" error. I found on tech net a TID that says to simply rename the resource library and then reload it. Doesn't tell where to find said resuorce librar y or how to re-install it!. Anyone know a fix to this?

by jeremy.lutley

Selecting ignore leaves the page as a landscape page but when you print (or print preview) you only see a portion of the data on the page.

by seadrake

We were getting the same message and it turned out (in the end, after much agro) to be a driver version mismatch on a networked printer. Our network guys had to install either an earlier or later version driver for that specific printer through a unique TCP/IP port.

Hope this helps. Check to see (have your network support check) if a there are known issues between your Office version (XP?) and your printer drivers on the MS site.

by winlak

If you have other colums of data to get the month to date figure then use B$2(instead of $B$2)and when you copy the column accross you can get the month to date of the data in column C etc.

by sctang73

from experience, office xp/ 2002 products have no problems accessing office 95 & 97 documents. just resend the r?sum?. perhaps compressing it w/ winzip will reduce the chances of data corruption in transit (less data to handle).

by operations

In Word, Excel, Outlook etc. When this user opens the app all is ok. But when you go to "File" then click "Save As" we have Windows "Save As" Box that opens. Here is the problem, If you click on the pull down for "save in" the whole app freezes for about 1 to 2 min.

Once it opens each folder or drive you choose to navagate through pauses 20 to 60 sec.

This is on a 2.4 Ghz box, and navagating in windows explorer is fine, all programs but Microsoft Office are fine.

What gives???

Any help would be welcomed.

by jimbotech

I've seen this on machines that are on a network but the default printer is not avilable. Try to set another default printer, e.g. fax printer.
Also save the doc on a local folder, not on the network. Notice any changes?

by swteach

The "Save As" dialog box probably shows a list of existing files, folders and shortcuts in whatever folder Word defaults to, typically "My Documents". Check to see if, among those icons, is a shortcut to a network drive that is not on line or is no longer viable; in other words, a broken link. Word appears to freeze while it tries to validate all such connections before it'll let you continue in that dialog box. Delete or correct the shortcut links to fix the problem.

by virbc

Pardon for butting in. This should fall under a new thread.

We have several units LAN connected P2/360 & P3/700s, all W98/SE, Office Suite 97/XP.

Problem: Saving Word & Excel documents using "Save As" (w/ same word/excel version) on the P2/MS/Office97 unit takes a minute or more to complete. Using simply "Save" completes normally. Using "Save As" on the P3/MS/OfficeXP units completes normally.

What could be the problem on the P2/MS/Office97 unit? It seems to be waiting for some other processes to complete before the save-as is completed. Can I do a trace, what tool/s can I use?

TIA

by learneverything

I'd like to the forum for tech questions divided into groups for each MS product. I seldom use the forum's anymore because it's too time consuming to sift through all the stuff that doesn't apply to the product you have a question about.

Thanks.

by arjterry

Can anyone share information with me on where is the best institution in the Laurel, Maryland or D.C. area to get my Cert for Master MOUS? I would like to have the option of studying online as well as classroom training for this. Andy good schoolsfor this in the area?

by mlbrown

WORD tables can be quite useful in aligning text, and (easier than using tabs) - but they have hidden "margins" next to the table lines.
I wanted to format some text each line of which started 1 - 8 , 9 - 16 , 17 - 24; so I wanted to right adjustthe numbers, and not have too large a space for the dash. I eventually found the controls for this default "space" around the lines, but it is not obvious. Perhaps it would make a useful article?

by growan

ISSUE - document saving in Word. PLATFORM - Word 2002/Office XP/XP Professional. PROBLEM - an error message received when saving an existing document opened in Word. "Word cannot complete the save due to a file permission error". Click "OK" in response. Another box appears, "Do you want to retry save" with Yes/No options, select "No", no further messages appear. Immediately, select "Save" from File dropdown menu, the document is saved without any further problem. Suggestions or comments sought....

by swteach

I had the same problem. Couldn't save via the toolbar; only via the File menu. Solution: reset the toolbar! Here's how.
Select "Customize" from the Tools menu. Click the "Toolbars" tab at the top of the Customize dialog box. Click once on "Standard" on the list, making sure to *not* clear its checkmark. Click the Reset button on the right, and click "Yes" to confirm that you wish to restore the toolbar back to a factory-fresh state.. Click "OK" to close the Customize box.
That should do it.

by catadmin

Growan,

I don't know if this will help or not, but people in my office experienced a similiar thing with Office 2000 when they have Word open with Custom Toolbars up top. Apparently Microsoft is aware of a problem with Office in which a Custom Toolbar will not allow you to save or creates a fatal error when you click the "X" in the upper right hand corner without going to "File -> Save" first. Their response (since they don't seem too interested in actually FIXING the bug) is to do the File -> Save before you close Word or the document.

As I said, I'm not sure if this is the problem you're having. Are the users in question working with documents which have any toolbars other than the standard?

by lfj

Found this - Microsoft Knowledge Base Article

PSS ID Number: 311153

Article Last Modified on 8/16/2002
The information in this article applies to:
Microsoft Word 2002

This article was previously published under Q311153

by jackosullivan

Any idea why this KB Article cannot be found in Microsoft's KB Search? Have they now abandoned Word 2002?

by michael.urem

I've seen this with Word 97 and Windwos NT 4.0. If you're trying to save a large file to a network drive, this may happen occasionally. Saving it locally seemed to work for me - at that point I would physically move it to the respective network volume.

by bryan_marcum

When using Word XP, there are some new security settings that must be made in Word (or for that matter Excel) before a program is granted access to certain "features" of Word. The way I fixed this same problem was to open Microsoft Word. Then go to the menu line Tools/Macro/Security... This will result in a window with two tabs. The first is security level. However, it is the second tab that I needed titled "Trusted Sources". I had to place a check beside both "Trust all installed add-insand templates" since I was also using VBA macros to perform some work; also the second check box titled "Trust access to Visual Basic Project" had to be checked.

When I did this, all worked fine.

Hope this helps!!

Goodday...

by progrsys

I have a problem with office 2000 sbe sp3.I can install sp1a fine but after I install sp3 word tells me that any document is unavailable.
Does anyone know why?
I OWN THIS COPY OF OFFICE

by mukhtarmalik

Iwould like to make mailing labels from excel data.Please advise step by step an easy procedure. I followed the technical books and lost all my files in MY Document folder and I cant recover these files. Please help. Mukhtar Malik

by bhperuta

I experienced a problem with Powerpoint 2000 at the worst possible time. I created a presentation that would be viewed by 1000 people. I imbedded a couple of wav files to add the necessary sound. When I passed tghe presentation (as a slide show and as a presentation) to the event planners, the sound wouldn't play. I quickly added the filed to the network share where the presentation was being stored and it worked. My questions is - Aren't files added to a presentation stored as imbedded objects and not referenced objects? Based on what I've seen with Powerpoint 2000, that isn;t the case.

by trickydick

These types of files are not embedded. They must reside in the same location where you pointed to when you added them to the slide. We've had the same problem. Putting a large presentation on a CD to play at a presentation requires that the wave/video files be accessible to PowerPoint.

Hope this helps!

by jayers

When moving a presentation to a different location, use Pack and Go. PowerPoint will take all necessary files along with it including sound and video files that are not embedded. (Be sure to check "Include Linked Files" when running the Pack and Go Wizard!)

by fung

I cannot use fill color this feature. After I make a table, I tried to use the fill color feature. It is grey out, I cannot use it. Would any one tell me how can I reset this feature.

Thank you

by tarasandford

For tables, try using the Shading Color tool on the Tables and Borders toolbar. The Fill Color tool on the Drawing toolbar is typically used for drawing objects, and that is probably why it's "greyed out".

by trickydick

The fill feature is only active when you are working with drawing objects (Drawing toolbar). To fill cells in a table, click in the cell, select the range, or the whole table. Then on the Menu bar click Format>Borders and Shading, and click the Shading tab to select what you want.

Hope this helps!

by stumpy2

Anybody else using Office 2003? I recieved it in the mail the other day. It is a whole lot different than XP!

by trickydick

It's bad enough having to switch from Office 2K to Office XP!! I don't want to even think about going to 2003!

by tednitka

May be great but cannot assign OPPORTUNITY to Contact or Account. Is there someone at MS we can call to resolve issue? This prevents use.

by bpahlow

One note, which I believe is going to be available as a standalone, is a handy application. I use it a lot. I also like some of the features of the new version of Front Page, especially the split-screen view.

by nadine

Which software to use? I would like to set up a form where an employee could request some hours off (several fields), then send the document to their supervisor who would have access to an approval field (employee would not), then to the manager who alone would have access to the final approval field.

by ann - consider it done

To protect the supervisor authorization field lock it by pressing press Ctrl+F11. That keeps the field from being modified. The supervisor would then unlock the field, by press Ctrl+Shift+F11. Or,

Create a separate section in the document(INSERT|BREAK|CONTINUOUS) and creat teh approval field. Use TOOLS|PROTECT DOCUMENT and click the Sections button and specify the section where the approval field is.

by discussion

With regard to the tip on random text in Word ("Generate dummy text," April 4, 2003), here's some additional information.

If you enter =rand(), you get 3 paragraphs of 5 sentences. Alternatively, you can enter =rand(n)to get n number of paragraphs with 5 sentences in each.

This trick saves a bit of time for us slow typists.

(This comment was submitted by a reader via e-mail.)

by trainermanager

This is a long-time trick (at least back to Word '97). You can specify both the number of paragraphs & the number of sentences per paragraph. Type "=rand(10,3)" for 10 paragraphs of 3 sentences each or "=rand(15,10)" for 15 paragraphs of 10 sentences each and so on. Very useful in training classes - focus on the work at hand, not generating enough text to, e.g., push to a second page to demonstrate the running header feature of a document.

by tednitka

try to delete contact - SCRIPT ERROR - OBJECXT DOES NOT SUPPORT THIS PROPERTY OR METHOD. PAGE SBE.DATAGRID1 - LINE NO:11

WHAT TO DO??????

by Former member

Hi,

I've observed a common problem recurring in a few versions of PowerPoint: sometimes after copying and pasting a text box from one slide to another in the same PowerPoint file, the words in the pasted text box do not appear in the second slidein the Outline view.

It may not happen all the time. Is this a bug in the software?

by dblayney

Text entered into text boxes does not appear in the Outline view. By pasting a text box (even if it was originally created by typing into the Outline view) you will therefore not see it in the Outline view.

The solution is to copy the text _from_the Outline view and paste it _into_ the Outline view rather than copying the text box. This works every time.

by trainermanager

You don't need to paste into Outline view. The issue is that only text entered into the "default" text boxes of a layout from Slide Layout will appear in Outline view. If you manually draw a text box and enter text, it won't appear. Thus, the trick is to copy the text and paste it into the default text box of the new slide - DON'T copy/paste the entire text box from one slide to another. HTH

by dblayney

Your comment is absolutely correct. I tend to work with completely blank slide layouts where there is no default text box. In this case, my earlier suggestion still applies.