Replies

Mark

The problem is with the AutoNumbers is that we have an older copy of the data and those numbers are there. So there is no question there is significant lost of data.

I don’t think I placed any cascading deletes in, but can prove it. If you had created Relationships on the Relationship grid and that grid got cleared or objects moved into a new database would any relationship/cascading deletes still be in play?

Fay

Don’t bother with the organizer. Copy the Normal.dot form the old computer and replace the existing Normal.dot on the new computer with the one from the old computer. Also you may want to copy over her old AutoCorrect file to to save her having to rebuild that one. Look for the MOS*.acl file. The * will be a number which corresponds to the language US English is 1033. When you find it look for the file with the most current date. Copy that to the appropriate location on the new machine. This comes from an article I found on the http://www.mvps.org/word/FAQs/ site. Sorry not sure exact location. Title is How can I import and export all my AutoCorrect entries, so they can be transferred to another machine?

Hope this helps. Fay

Follow-up on Andy’s comment earlier about the HR not accepting documents not formatted their way. This is a major organizational problem. If there is a criteria that others must meet then the organization has an obligation to 1: teach the computer users how to use the computers. 2: create templates or forms that are available company wide. Barring those then HR needs to get off their high horse and accept what they get.

I have seen to many organizations that have no clue. That computers are tools and the user needs to be trained on how to safely and correctly use that tool. Rant over.

Fay

i teach computer skills and develop my own handbooks. I teach how to automatically create space after a paragraph and/or how to do first line indent. It is a time saving factor, but I also have been known to do it the old way, Enter Enter or Enter Tab. But I stress that if you are creating any type of template or long document let the computer do it for you. One is saves time and two there is the consistency issue. Styles are time savers, once you get a good understanding of them. Most people do not know that the computer can do this work for them.

To remove the extra Enter space do a Edit | Replace. In the Replace dialog box Click in the Find window | select the More button | Special button | Paragraph Mark (do this twice to have Word look for double Enters) note you can not manually enter the combination | Click in the Replace With window and put the Paragraph Mark in there once. Click Replace or Replace All button. To then put the spacing after select the paragraphs needed and then use the Paragraph dialog box to insert the proper spacing. Usually the 3/4 of the height or same height as the font being used. So if using 12 pt type insert either 9 or 12 pt of space after the paragraph.

Lets throw something else into the situation. Never use the Enter key to force a page break. Either use Ctrl+Enter or Insert menu | Break | Page break. The problem here is that if more material is entered or remove above the material you wanted at the top of the next page. The top of the next page position is not static when you manually put it in with multiple enters. So the top of the page after removing or entering material is pulled up or pushed down. Bottom line it will not be where you need it, your hair becomes gray, and the computer screen is wearing your fist (or maybe I should say your fist is wearing the computer screen.)

A good site is http://www.mvps.org/word/FAQs/ they have a lot of good answers for you.

Fay

Okay I admit it. I blew it. It was so simple that I am embarrassed. I was creating my form using a totals query. All I needed to was create a field called Last based on the DateofService field and set the Total row to Max. A piece of cake. Thanks to everyone who looked and those that responded to this message. Fay

I tried DMax using the following =DMax(“[DateofService]”,”Services”,”[ClientIdentification]”
It gives me the last DateofService for the whole table.

The database holds clients, staff, and service tickets for when the clients were seen. On the report I need to know when each individual client was last seen by a staff member.

Thanks Fay

It worked like a champ. Thank you. Can you explain the code a little more. The Mod2=0,”B”,”A” part.

Once again you guys come through again. Fay

Home run, 3 points, thats is it. Say it any way you want, that did it. Thanks Charolette as always you come through. Fay

I found this and think you may find what you need at the following location http://www.mvps.org/word/FAQs/Userforms/CreateAUserForm.htm. I attached a test of what is at the site mentioned here.
Good luck Fay

Is it possible that you have a task calendar assigned to the tasks that are giving you problems? If so and you don’t have schedule ignores resource calendar marked Project will look for the first time both the resource and task calendars meet and schedules the task for that time. Access the schedule ignores resource calendar option on the Advance tab of the Task Information dialog box. I hope that helps. Fay

Edited by gwhitfield on 03-Jan-02 07:48.

Try the following address http://support.microsoft.com/directory/art…B;EN-US;Q269006
or search Microsofts knowledgebase for articl Q269006. I think this is what you are talking about? If not sorry.

Hope it helps. Fay

Look at File | Page Setup | Layout tab. What does it say under Section: Section starts. If it said odd and your last page was an odd page it will automatically add another even page before the odd page. Fay

I solved the problem. I put a textbox with the control source of =Sum[] in the footer of the subform then made the control source on the textbox on the parent form to the textbox on the subform. It worked like a champ doing exactly what I needed it to do. Thanks. Fay

I put the repaint line in the requery code and it didn’t work.

The source for the txtTotalPer textbox and the parent form is a query “qryPerson” The frmClasses is tied to a query qryClasses. I am not sure what you mean about what else is going on. To this point there is no code except to maximize the parent form on opening. The arrangement is a simple parent and unglamorous child form. Most data will be entered on the subform. Thanks for working with me. Fay

I tried

Private Sub Form_AfterUpdate()
Parent.Repaint
End Sub

I also tried Parent!txtTotalPer.Repaint

It does not change the text box.

Thank you. Fay