Word Error

I have an issue I cannot find help with. I am getting the complie error in hidden module: autoexec when i start word or close it. I believe what caused it was when I tried to put adobe acrobat on my computer and realized the version i had would not work with Vista. I uninstalled acrobat but it must have left something behind. I do not have any files in either of the startup folders as described in some of the threads. In word if I look at the templates and add-ons it shows pdfmaker.dot but it will not let me delete. I tried uninstalling and reinstalling office but that did not wo

Multi-Column Report

I have a 3-column report. The SID header (GroupHeader0) has Format properties as follows: Force New Page...None New Row Or Col...Before Section Keep Together......Yes Visible.................Yes Can Grow.............No Can Shrink...........No Repeat Section....Yes Depending on the value of SID header, I would like to forego making a new column, and just keep printing within the same column as the previous SID header (but include the new SID header value in that same column). Anyone know how to do this?

Drop down list in Microsoft Word 2007

I have added a drop down list to my form in Word 2007 but there is no arrow for the user to click to see the options. How can I fix this?

Path.GetInvalidPathChars "Visual Basic 6.0 Classic" equivalent

Someone may remember putting me onto Link_File_1532711212003. I'm using it for my VB6.0 lnkfile IMDB rating project. At that time I had a problem with Microsoft updates breaking the IsLink function. Now, I am finishing up interfacing the 32bit AMDBW14 title.exe program and it produces a txt file for each IsLink entry in the folder. Once all the txt files are sorted, the 1Kb files are, almost without exception, unfound entries, and where the name needs cleaning. Firstly, to clean the names, I plan to cycle through these extracted 1kb links to the now deleted txt files, where the not

FINE config WMP 11 to show countup or countdown of video time OR B

My Windows Media Player 11 video time progress gone from countup to countdown to zero how do i adjust set it back? It used to be it would only do this if I double-click in video area to go to FULLscreen mode; otherwise/anything else, it's countup--everything that I want (meaning the way it was)--I think! But a few days ago, don't know what happened/what/something I did, WMP is now always countdown (to zero)...so how do I get it back? Better yet, is there somewhere where I can FINE config WMP to where it shows countup or countdown...or BOTH, separated by a SLASH / maybe??? Vis

Analog Tuner Function

I have an HP Pavilion running Windows 7 Home Premium. When I was running XP I was able to listen to FM radio direct (not over the internet) using a built-in FM tuner. I don't have that now. Was advised to 'set up' an analog tuner function. How do I do this? OldEd

data type mis match error

I am getting a Compile error: Type-declaration character does not match declared data type Private Sub optMH1_Click() Call SelectMHform(1) End Sub Sub SelectMHform(a As Integer) With Forms("BaseForm") .optMH& a&.value = 1 .txtPicture.value = "MH" + Str(a) .cmbBoxMaterial.value = "" .txtBoxLength.value = "" End With End Sub I tried some other things too but I am still getting an error due to .optMH& a&.value = 1 How do I use a variable in this situation?

Word 2007 Is Non-Functional

HELP! Yesterday, Word 2007 worked fine. Today, after some Microsoft auto updates were applied (one was a security update to Office (KB978380)) it fails every time. If I start Word and try to save or open a file - crash ("Microsoft Word has stopped responding"). My system has a QX-9650 Quad-Core with 8GB of memory and dual video cards in a quad-SLI configuration (2GB VRAM). I have one application open (Word) so system resources are not an issue. I'm running Vista x64. I went to the Technet site and found an article on Word continually crashing but neither of the two cau

What Versions of Windows Media Player are Still Supported?

Which of the following versions of Windows Media Player are still supported by Microsoft (i.e. receiving security updates, etc.)? For all currently supported versions of Windows Media Player, when will the support periods for each end? I tried looking for this information on the support site but could not find anything. Windows Media Player 12 Windows Media Player 11 Windows Media Player 10 Windows Media Player 9 Series Windows Media Player for Windows XP (Version 8) Windows Media Player 7.1 Windows Media Player 7.0 Windows Media Player 6.4 (mplayer2 for XP and 2000)

Word: Need form's CommandButton to open another doc. HOW?

I'm making a form in Word. I am usually quite fluent...but can not figure out how to tell a CommandButton what to do. HELP!!

How to force the critical path through a milestone

I have a project with a few long duration non-critical task which define the ultimate duration of the entire project. However, I have a few critical intermediate milestones which are critical. Does anyone know if there is a way to force the critical path through specific milestones without date constraining them? Many Thanks.

word stopped working

I saved file on a flash drive. When I tried to open it the next day, I got the message Word has stopped working. MY OS is Vista. Thanks for any help. CHV

Pivot Table help

I previously asked about consolidating rows of data that I was looking at and got the following response that worked great: I took your Source data and did the following... Created a pivot Table from the data (I think you are good to here) Placed the Duty Location in the Left Column (not top row) Placed the State to the immediate right of the Location (not in the data section) .... same thing for all of the remaining fields Place FTE's in the data section. Pivot tables like to add in subtotals. You can remove the subtotals by right clicking on the field and select Field Opti

Defender Setup Fails

Today I tried to install Defender on a PC with Windows XP SP3 fully updated. I got a MsiInstaller error 1920 telling me to make sure I had sufficient right to do the install. This PS is joined to a domain and the logon I was using is a domain administrator. I found no TechNet articles that discussed this error. Any ideas? -- Bettie

continually recovering files/folders

This is a multi-part message in MIME format. ------=_NextPart_000_0118_01CAC141.84345E60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable how to stop WLM from continuing to recovering the same files/folder = every time it is run. folder/files are deleted and WLM successfully compacted. next run it recovers them again. mikeyhsd@hotmail.com ------=_NextPart_000_0118_01CAC141.84345E60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Trans

Averageif?

1 -20 1.6 -20 2.4 pass 3 35 1.5 14 2.7 7 How do I average the numbers in column A if the numbers in column B are greater than 0? There is some text in column B.

SUMIF or SUMIFS help

I have 2 sheets in one workbook (Sheet 1 and Sheet 2) Sheet 2 has 3 columns: A B C MAKE TYPE QTY 1 toyota compact 10 2 ford pickup 15 3 toyota sedan 20 4 toyota pickup 80 5 nissan hybrid 10 Sheet 1 has 2 columns: A B MAKE PICKUPS 1 toyota ? (SUM) I need Sheet 1,B1 to calculate the total number of matching items in sheet 2 that matches the data entered in Sheet 1,A1. In other words, I need sheet 1,B1 to automatically sum up the total number of to

How do I get my sizing handles back? Graph/data on same page.

I created a simple line graph on the same page as the data. The blue sizing handles use to be present when I wanted to add data, but now the handles are no longer present and I have to go through the longer way of adding data by using the Chart source data option. Is there a way to get the sizing handles back?

Prompt if data is not entered after so many times

Is it possible to highlight a cell if that data has not been entered after so many times? For instance, if I have a column where I have entries of A,B,C, & D and say B hasn't been entered for 7 times since the last entry of B, is there a way to highlight that last B then? Hopefully my question is clear enough to understand.

Problem Saving

Wow, got a good one and finding nothing... I have a user who checks out a file, (Excel in this case), Edits the tile, saves and checks back in via Excel. Then when another user opens said file the changes are not present. The version history lists the revision time and date by the user but the changes are not present. No errors on saving or checking in, nothing. Extremely weird and I was wondering if anyone else has seen anything like this... WSS 3.0 Client is Windows 7/IE8/Office 2007. Any ideas are welcome... Thanks, Derek

How to incorporate page counts in TOC

I need to find out how to incorporate each document’s total page count into the Table of Contents instead of the current page number. In my case, we have 20-60 separate document files that need a single TOC that states the total number of pages for each file. Example: Section No. of Pages 100 3 200 2 300 10

Removing Of/And/The from Acronym Function

Someone kindly provided me with: Function FrstLtrs(MyStr As String) As String Dim temp Dim i As Long TmpStr = Split(Trim(MyStr)) For i = 0 To UBound(TmpStr) If Asc(Left(TmpStr(i), 1)) >= 65 And _ Asc(Left(TmpStr(i), 1)) <= 90 Then FrstLtrs = FrstLtrs & Left(TmpStr(i), 1) End If Next End Function Which worked great but didn't ignore The/And/Of if capped. So I found some code that should have worked If Not (UCase(TmpStr) = "OF") And Not (UCase(TmpStr) = "FOR") And Not (UCase(prom) = "THE") And _ Not (UCase(prom) = "AND") And Not (UCase(prom) = "A")

Drop Down Box Length

I know that you can only have a drop down box be so long (NOT number of items to choose from but number of characters on a line). Is there any work around this? I want to create a form letter where the person creating the letter has to choose between one paragraph or the other (using a drop down box). The form must be lockable. I was thinking about creating a macro that inserted the verbiage I needed but not sure if this would work or how to do it.

Your new help tab sucks.

Your new help tab really, really sucks. All I really need is a box where you type a command, say "header", and the buttons for that command appear. That's it. I don't need yet another way to search help. I don't need a button telling me how to find the Save button. I don't need an interactive version of Word 2003's menu. I just need a way to quickly bring up commands by name. -- Jonathan Allen ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" butto

Entourage Contact Syncing

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Email Client: imap How do I prevent some of my contacts from syncing to my BlackBerry? I have some contacts I want to keep on my Mac in my Entourage that I don't want on my Blackberry. Is there a way to select a contact and exclude it from being transferred to my BlackBerry?

May be nothing or

Using XP fully patched and Avast protection. I notice that if I have no applications running and then sign out of XP that a few groups are sent over my modem. I do not know if that is normal but can think of no reason for it. My question is: Is that normal for XP?

Word Bibliography and Citations

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel <i>have two issues.</i>&#32; 1. I have created many citations for the bibliography for three different project. If I close a document and reopen it, the Master List appears but the Current List is gone. I have to recopy all of my citations. It's very frustrating. <br><br>2. When I go to insert the Bibliography, I go to insert Document Elements but all the choices are grayed out and I cannot insert it. I did this before so I know it is installed. <br><br>HELP

gridview inside updatepanel

I have gridview that has templated fields in it. One of the template fields has the calendar extender associated with it. All of this is inside of an update panel which works fine so the gridview/webform doesn't flicker when a control is used. But, with the update panel comes problems. It is with the calendar extender. With no updatepanel, the calendar on the txtbox looks and performs great, just like the css says it should. With the updatepanel, the calendar still shows (smaller than normal) but is scrambled and the function is questionable. Is there a way to prevent the

global and 12 folder do not exist

Operational MOPS 2007 system, patched same as described for client: A user has MSP2007 Pro SP2 patched to Dec CU. THe user's 12\1033\global.mpt folders and .mpt file do not exist. Only the Cache folder and 11\1033\global.mpt exists in the usual %app data% path. I found that the MSP2007 Pro client was using a global.mpt file at this path: C:\Program Files\Microsoft Office\Office12\1033\global.mpt It is not a shortcut in the client icon, it simply is somehow mapped there. I created the missing folders manually and copied the global file to the usual location and then mapped the

DPM was unable to attach the content database to the SQL Instance

Hello, I'm trying to restore a document back to my SP Farm using Recovery Farm which but I get the message that is is unable to attach the content database. I checked the errlog on the Recovery Farm server for DPM and see this genericstatus.cpp(1089) [00000000007BB1 |TaskID=8C81A792-FF26-4BE3-8633-DF4FDB8DEF8F Failed: Unable to open the QFE registry key [Software\Microsoft\Updates\Windows Server 2003\SP3\VSS\KB940349]: 0x80070002 vadatasourcestate.cpp(651) |TaskID=EF05DA88-B436-4C96-B939-7E1DD76339D9 GetModuleHandle failed for Library [WSSWriterHelperPlugin], Hr = [0x8007007

Embedded objects / pictures automatically enlarged upon clicking s

When I insert a picture or a Microsoft Object (e.g., Excel Worksheet Object), everything looks good, but when I click on Send the picture and/or object is enlarged to 333% and the email is sent. Note that I won't know if this has happened unless I open the sent email. Also, this happens about 60% of the time. Sometimes I'll have two objects/pictures in the same email, only one of which is enlarged. Any ideas why this is happening and what I can do to stop it (other than discontinuing using Word as the email editor)? I'm using Outlook 2003 (with Word 2003 as my email editor

Outlook Equivalent to Lotus Notes Journal Entry

What is the equivalent to a Journal Entry in Lotus Notes -- JerryG

Alphabetize Enterprise Templates on MSP 2003

Our List of Enterprise Templates in MSP is by creation date, it seems. I have asked the Project server admin if it can be sorted alphabetically in order to easily find templates out of the 40+ we have on file. I am told that there is no way to do this. Is this correct? Are we stuck having to scroll through all the templates to find the one we need? -- robin

Access 2007 flle moved and gets a path error

I have a question on opening a client's file I get this error. It can't find the path. E:\Mineral Tracker - Cleaned Backup\mineralTrackerDataDase.accdb ' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. I guess the client had it on the E:\ drive. In any case I went to the External Data/Access tab and put in the new path. The file opens but I keep getting this error. How can I fix the path? thanks,

Update Trigger

Hey guys, whats up?? I am not new to SQL but I am trying to create an Update trigger for the first time. I have found several links to Update triggers but they seemed to confuse me more than anything. So, here's what I'm trying to do. I have a table called, "MattersQLegalAssistant" (Table 1)that has a field called "Q1stLABridgelin" (Field 1). I am trying to update a field called, "Q1stBridgeline" (Field 2) in a 2nd table called, "MattersQMSUHearing1" (Table 2). So in other words, Update Table 2, Field 2 with values from Table 1, Field 1 if Field 1 is updated. I thought this shoul

Help with Document Merging

I am not even sure if this is possible....so I will give you some background to help you understand what I need... Thanks in advance for any help you can provide... I work for a staffing firm and we use various questionnaires to collect information about our candidates. Each questionnaire is targeted to a specific type of candidate, i.e. a questionnaire for accounting candidates versus a questionnaire for an HR candidate or an IT candidate. Each questionnaire has a set of questions that is specific for that job type, but each questionnaire also has a set of general question

deleting temporary excel files

My computer crashes when exiting excel on all files. I remember that you can delete temporary excel files and cannot remember how to locate them and delete. Will this fix my problem Dave

Need to change NULL to Space in Form

We have an Access 2007 table that has a field in which NULLS are not allowed. In the table definition, we have set up a Validation Rule “Is Not Null”. This works nicely. The catch is that in some situations, we want to store a space in this field. We are using a FORM that is based on a Query that is in turned based on the Table with the validation rule. We have tried to change the field from NULL to spaces in the BeforeUpdate event for this field on the form. We can detect when the field is NULL, but Access will not let us plug in a space at this point in time. Wha

Format issues when saving file from .docx to doc

I am having formatting issues when saving a file into a previous version of Word. The oriiginal document was created with the 2007 version and when I "save as" 97-2003 version, it seems to lose the orignal format. It actually puts the page number onto the next page but not at the top like you would assume...it pushes it between text. Almost like the page margins at the bottom are increased. I have tried to delete and cut and then paste but it has changed the page size...or so it seems. I hope this makes sense

Combine 2 presentations w/o losing hyperlinks?

I have 2 large presentations, each has hyperlinks within the presentation. Each pres also hyperlinks to the other. How can I package the 2 files so the hyperlinks are intact? Using ppt2007. I know I've done this before using ppt 2000 or 2002 but I can't remember how.

Set MS Project so it opens on last date saved

I have been woking on the same project file (in MS Project 2002) for a few years. When I save the file & open it again it opens in May of 2008 even though I have the Project start date set at 1/1/10 & no tasks start earlier than 1/1/10. How can I set it to open on the date I closed it last, like March 2010?

Countif function

I need to find out how this countif works. In my excel class I did the countif like this. Statistical, countif, I selected the range, press F4, tab and with insertion point in the criteria box I clicked the cell that was needed. It came out really well. However, when I had to do the skills review, I did exactly the same thing, the formula came out, but the answer was obvously wrong. The question was to count the number of employees with a rating of 5. So I clicked in the cell that it needed to go, selected the range of the employee ratings and F4, then selected the other cell

I e-mails, some are blank - others are correct

In the past week we are receiving blank e-mails. They will initially appear correct, close outlook and then several messages will appear with symbol and date/time/size but no message and no from. This happens with Outlook 2007, if I go to explorer and open hot mail the messages are there.

Internet Explorer

Up to this date I have been using IE6. However, lately I have started experiencing situations where it would stop in loading a web page. When it hit control,alt,delete, it states that the page that is loading is (not responding). I did a search and there is a Microsoft page that says that there is a "hot fix" for this problem. Before I install it, I first wanted to ask if it would be better to just go to IE7 or an even later version. Any help will be appreciated.

Easy One!

I have this formula: =COUNTIF(A1:A10,"sup") I want the sum of a few other acronyms as well. How can I retrieve the sum of several different acronyms within the same data range? Help!!!

Unable Force Tapes Free

I posted this earlier looking for some help. I am updating my request for help. http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dataprotectionmanager&tid=e20cf4d0-6b3b-4375-833c-2fadbbf233e4&cat=en_US_c18d9b67-8a4f-493f-99fa-246042fd5824&lang=en&cr=US&sloc=&p=1 After migrating to a newer DPM server, I cannot reuse any of my tapes. When I run the force tape free script, I get the following error message after it expires the data on the tape: PS C:\users\Administrator\Desktop> .\ForceTapeFree.ps1 DPM server name: : dpmsrv02 Library name: :

How to change font for cross-references

I have been a WORD user for years, but I still cannot work out how to make a cross-reference appear as a link. When I create a cross-reference it just appears as normal text (unlike applying a hyperlink). Is this a default and somewhere you can opt for colored text and an underline? And what is the point of a x-ref that cannot be identified as a x-ref until you actually hover over it? Unless I am missing something really basic, that seems really stupid.

Paste a word doc into a .ppt slide

I have created a word doc with picstures abn connector lines and text boxes and need to place the whoe doc into a .ppt slide. I can't figure out how to convert it.

Help with linking columns of multiple sheets

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am clueless when it comes to Excel and only use it once a year for taxes, because my accountant likes it. <br><br>Anyway I add in all my expenses on a monthly basis and treat it as a worksheet (i use the Sum function to total things like postage, miles, software, etc). I want to have a final worksheet that shows all 12 months of 2009 (the totals of each spreadsheets and I want to be able to sum a total of any category like postage or mileage in a yearly total. I am able to cut and paste the totals of each mont

deleting addresses instead of going to them!

for the web addess list that is available when using the drop down menu when signed into IE8 - whose silly idea was it to put the delete button immediately below the drop down menu arrow, so that every time i want to go to the address i delete it instead!! not a useful feature!