Recent content by JillT

Hi mp9. Thanks for that code. However, sorry to say it doesn't work for me, I still go to a blank record if I press page down. I have some workarounds, but it seemed such a simple thing to do!

Has anyone got any idea how to disable the Page Down key so a user doesn't go to a new record on a form if they hit it please?

I use the following code to check if a document has been protected for forms: If ActiveDocument.ProtectionType = wdAllowOnlyFormFields Then ActiveDocument.Unprotect End If But if you are checking whether the form has been protected for tracked changes or comments you will have to change...

I have used form fields in a very complicated (and long!) form and the user now wants to use hyperlinks to go to the various pages. If the document is protected (and it has to be) the hyperlinks are disabled. Anyone know of a way to enable them in a protected document?

I had this problem too and got round it by using a Word-based Office form and Word form fields. In Outlook select File>New>Office Document>Microsoft Word Document>Send the document to someone. Click Tools>Form>Design this form and create a Word form on the Document tab. You may need to edit the...

Well, maybe this will help ... I have done this in Access by adding this line to the open event of the form containing the listbox. This selects the first row in the list: Me.LstDescription.Selected(0) = True Hope this is what you want!

This is the click event of a command button on a user form, PrintPage which refers to checkboxes (each named Section#)to print selected sections of a document. It works fine except I get a blank page after some of the printouts. I added MoveLeft to reduce the selection but it makes no...

Actually I think what you want is the IF function. This will allow you to set criteria to match to return a value from another cell. For example: =IF(A1=5,B5,B1) If the number in A1 equals 5, then return the number or formula in B5, else return the number or formula in B1. Take a look at...

I have a Word 97 template, with headers and footers, accessed by several users on an NT network. Some users find that when typing the last line on some of the pages the text flickers until the page breaks and text continues on next page. This is intermittant and some users have no problem. All...

I have been tasked (whilst on holiday!) with producing our organisation's Outlook forms. Designing is no problem but I can't print the forms as they are designed. The only fields that print are To: From: and an alphabetical list of fields and their values. Is there any way of printing the entire...

I am creating an on-line which which requires the user to change the font to strikeout and back to normal in a form field. I planned to use 2 buttons on the toolbar to run macros; the first to turn protection off and change the font style to strikeout; the second to turn protection back on...

Not exactly sure what you want here, but you may want to look at File>Versions, which will enable you save versions of the document before you make changes (effectively a snapshot).

I need to automatically weed records from a database. My user wants to find records which have not been updated or modified for one year. I could add an extra field to the table to insert a date whenever the record is modified and base a search on this field, but there must be a better way...