Search results for query: *

I am working on a project for a client who uses Word 2003. they are merging a mailmerge main document with an Excel 2003 file. Each data file record has a field in it specifying the path and another specifying the document and the rest of the record providing data to merge to the document...

I have a macro that changes the active printer and then runs a mailmerge. When the mailmerge is done, it runs a MailmergeAfterMerge event that unlinks the fields in the resulting document. I also want the event code to change the default tray for the printer. When I run the merge, it crashes...

In Word 2003, during a mailmerge, I want to use the mailmerge If statement to include specific pictures depending on the value in the field. I have gotten that part to work. My problem is how to size the graphic. I can position it by using Advance codes just before the If statement. I just need...

I am converting some old (very old) WordPerfect Mail Merge main documents to Word 2003. In the old WordPerfect files there was a mail merge statement that allowed you to nest forms and nest macros. The nesting was triggered by If or Select Case mail merge code so that different files or macros...

I want to keep a final calculation sheet hidden from the user but I want to be able to print it and only that sheet. Is there a way to do this without making the sheet visible? I need to do the same thing for print preview.

Is there a way in Excel 2007 to import an Access 2007 query into Excel 2007 and maintain the already established column widths in Excel.

in the Advanced Options of Word 2007 there are Compatibility Options where you can pick and choose what layout options you want to have in effect. Does anyone know where I can get an explanation of those options? Most of them I can figure out but some are not so obvious. I thought they might be...

What happens if two people try to update the same record but different fields on an Access 2003 data access page? Is that even possible?

The following code given in the VBA help for Word 2007 does not work. ActiveDocument.SpellingChecked = False Application.ResetIgnoreAll It resets those individual words for which the user has indicated they should be ignored but not if they have used Ignore All for those words. The...

I tried adding the Spell Recheck button to the Quick Access Toolbar but it does nothing. If I close the document and reopen it, it will find the items I had marked to ignore but I want the Recheck to work right away. It does work if I go into the Word Options and do it but not if I add...

In earlier versions of word, there was a nice 'Open Para'(aka Paragraph before) button that worked as a toggle to add or remove spacing before a paragraph. In word 2007 it seems to only add space. It no longer seems to work as a toggle. Is there another name for it. It does the same as pressing...

I have a list of Autotext items that contain Word Fill-in fields. When I start to go down the list in Building blocks for by adding the AutoText button to the quick access bar, it starts to play out the Fill-in prompts even if I don't want to use that Autotext item. Any ideas on how to get...

Is there a way to check and see the number of lines that were entered in a form field in Word 2003. I have a text form field in a cell in a Word Table. I want to limit the number of lines so that the row does not exceed a certain height. I have limited the height of the row and the number of...

Is there a way to have a macro run when starting a new spreadsheet from a template? I want to have a cell value increased by one (like a work order number) each time a new spreadsheet is created from the template.

I have a macro that copies text from one document to another. The macro is started from the document from which I am trying to copy text. I am getting an error when the macro tries to return to a specific document window that is open while copying text from another document window. It get an...

I want to create an Excel 2003 template that allows seeding for a triathalon. Any ideas? I have times for past competitors. I want to be able to seed them and then enter their new times and determine a winner in each event and then overall.

I would like to remove some of the entries in the list of recently opened folders found under File|Open. I have not been able to find a way to remove any or all of them

I need to display only the first and last record of a group and then transfer that information to another report. I am using CR XI. How do I just capture the first and last records' information? I know how to create subreports. I am just having a hard time getting the first and last records of a...

I have a report that is linked to a main report by the grouping value in the main report. I want to get the latest time and the earliest time from the detail in the subreport and display that in the main report. This is the formula: WhilePrintingRecords; Shared stringVar vEarlyECGStrip...

I am not referring to Crosstab reports. Apparently there is a new feature in CR XI that allows something called Cross Reporting. It works in a similar way to ondemand linked subreports. It allows you to set criteria to drill down on any item in a report to get more detail on any data item shown...