Replies

You are welcome. This is a nice place to go to find help. I am glad Woody and Eileen (and all the other people I don’t know about) put this together.

Roberta, I use a lot of temp tables to hold one record of data for a Word mail merge. The temp tables are filled by a make table query. The query always overwrites the one record. Do your tables append a record to the temp table? If so, a make table query would resolve that problem. HTH

The following is from Woody’s Office Watch #6.11. Probably the information in the first paragraph would help you. These shortcuts clear style formatting. I would also go to the web sites listed in this topic.

7. ADVANCED FORMATTING TOPICS
In the last issue of Woody’s Office Tips for Word, I
covered two of the most useful Word shortcuts: Ctrl+Q to
remove manually applied paragraph formatting, and
Ctrl+Spacebar to remove manually applied character
formatting. Are you ready for the advanced course?

There are many, many other similar shortcuts, as you might
imagine – most of which are relatively unknown, or
certainly under-appreciated. I went spelunking through the
Word MVP site again, and found all sorts of good material.
Start your graduate studies with the article called “Some
of the most useful Word shortcuts / Or how to save yourself
hours by giving your mouse a rest!”

http://www.mvps.org/word/FAQs/General/Shortcuts.htm

You can also assign your own shortcuts to Word commands,
and save a lot of time, especially if you have a small
number of commands that you use all the time. Check out
Bill Coan’s articles at

http://www.mvps.org/word/FAQs/MacrosVBA/As…croToHotkey.htm
and
http://www.mvps.org/word/FAQs/MacrosVBA/As…roToToolbar.htm
.

To get a full list of all the Word commands, their
descriptions and default shortcuts, try
http://www.mvps.org/word/FAQs/General/CommandsList.htm .
This list is complete, covering not only the default
shortcuts, but all other Word commands which you can, if
you wish, assign to a shortcut, or a menu, or can intercept
with a macro. It lists the commands using their correct
English names. It is downloadable in Excel format, with
various filters saved as custom views, making it easy for
you to switch between displaying all the commands or just
those which are assigned to a shortcut (and/or menu) by
default. And the descriptions of what the commands do are
mostly much more detailed and useful (and irreverent!) than
those which Microsoft provide. Really cool stuff.

It may be better to just go with the explanatory text next to the icon. You can add a comment to the icon that will pop up a window that tells the user what to do. To do this, highlight the icon, go to Insert|Comment and type in what you would like the comment to say. You could set it up both ways and then ask your users which they like the best. If you need any more info, let me know.

You also might think about changing the [txtTransactionDate]field to a date field in your table design, that is if this date field is a txt field.

Charlotte, in the tblCity, you wouldn’t want a primary key field, would you? Just courious.

frmorris, did Charlotte’s recommendation help?

This is how I would do it. Open your form in design mode. Left click on the combo box, right click and open Properties. Click on the Events tab.

On the After Update or On Lost Focus, left click anywhere on the row. At the far right of the row, a little box becomes visible that has three periods in it (…). Left click on the little box. When you do that, a Choose Builder box opens. Select Code Builder.

That will open a Class Module. Don’t get excited. Your cursor will be between two lines of text: Private Sub Form_AfterUpdate() (or Private Sub Form_LostFocus()) and End Sub.

Between these two lines, use an If, Then, Else statement, something like this:

If Me![Transaction] = “Permit” Then
Me![Type] = “P”
ElseIf
Me![Transaction] = “Easement” Then
Me![Type] = “E”
ElseIf
and so on until you have all transactions listed. The ElseIf after the fifth Transaction can just be Me![Type] = “SixthOne”, whatever it is called.

You must end the If statement with an End If. If you don’t, Access will tell you.

Hope this helps. If this is wrong or if there is a simpler way to do what you want, someone else on this forum will let you know.

Charlotte, thanks very much.

I understand your second recommendation. Not sure about how to do your first, but don’t worry about it.

We are able to get it to work by just changing the file name to 8.3 format. The folder names work OK as long folder names. Go figure.

One additional question when you have time. What does the /nostartup switch mean?

Again, thanks.

The following is an edit to this post:

To confirm your Windows 95 statement, we didn’t have this problem with users that have Windows 98 on their machines.

Bill, just a suggestion, it may be easier to do this in Excel. Of course, in depends on the number of classes that you have to schedule.

HTH.

Hi, Rory. I should have mentioned in the post that I had read the Word post you link to. On my machine, I don’t have the problem. The problem is with our users’ machines.

I looked at the file associations on the other machines and they appear to match mine. It says:

“C:Program FilesMicrosoft OfficeOfficeMsaccess.exe” /nostartup “%1”

The DDE checkbox is not checked. I checked it and copied the same info under the DDE in Word, except I changed Winword to msaccess, and got an error that the application could not be found.

At the end of the Word thread, it mentions re-registering Word using Winword /r. Is there one for Access? We tried MSACCESS /r and it didn’t do anything, that we could tell.

You may not have the structure of your db quite right.

Have one table with EmployeeID, Name, etc. You may have to have a table for each skill that would contain the EmployeeID, Skill, completion date, etc.

Then a report based on a query that looks at all the tables could display the skills completed and not completed.

This is probably what I would do, but I am fairly new at Access. I have had to set up a similar db and this is how it worked for me. HTH.

Have you tried Tools|Options|File Locations? You can change the default Open folder in it.

I just played around and recorded this macro. I have it looking for single spaces after a period and replacing with two spaces. Then it looks for Mr. and Mrs. with two spaces and changes to one space. It also looks for question marks with one space and changes it to two spaces. Of course you can change it to look for two spaces after any punctuation mark and replace with one space, etc.

Sub EndOfSentence()
‘
‘ EndOfSentence Macro
‘ Macro recorded February 16, 2001 by LonnieB
‘
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = “. ”
.Replacement.Text = “. ”
.Forward = True
.Wrap = wdFindContinue
End With
Selection.Find.Execute
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = “Mr. ”
.Replacement.Text = “Mr. ”
.Forward = True
.Wrap = wdFindContinue
End With
Selection.Find.Execute Replace:=wdReplaceAll
Selection.Find.ClearFormatting
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = “Mrs. ”
.Replacement.Text = “Mrs. ”
.Forward = True
.Wrap = wdFindContinue
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = “? ”
.Replacement.Text = “? ”
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
With Selection.Find
.Text = “? ”
.Replacement.Text = “? ”
.Forward = True
.Wrap = wdFindContinue
End With
Selection.Find.Execute Replace:=wdReplaceAll
End Sub

I thought this was neat. (I can say “neat” can’t I?)

In the Open dialog there is a check box on the right side under the buttons for Exclusive.

Click on File|Open or Control+O to get the Open dialog.

Jennifer, you could have a query that has a relationship between the two tables. I think I have had this problem before. I don’t think the query relationship shows up under the Relationship dialog.