Replies

I tried the same experiment at a computer at work and I had no problem. However, I have included a document that has the word “the” mispelled. At home and at work, when I tried to correct them all at once, it doesn’t work. I noticed that the style is something the author created, but I put it back to normal and it still doesn’t work. Any idea what is happening?

Just reread your posting. I have never created a style for a date that I know of. When I go to my style list, there is a style called Date. It allows me to add English (US), but not English (Canadian). I can insert dates every other way with no problem. The only problem is with the Autotext.

It is no huge deal if I never find the answer. I am just one of those people who needs to know why and will search until an answer is found.

I do appreciate everyone’s input.

At least it is comforting to know that I am not going crazy and others can duplicate my dilemma.

Yes, personally I use Alt + Shift + D a lot. However, I do believe that it puts a date that will change as the days go by, right, because the date is @Date, which changes from day to day?

The problem is that I sometimes teach some beginner courses in Word and one of the things that is in some of the text is the Autotext for the date, however, if the language is set to English (Canadian) it is so unpredictable and I look so stupid when I have no idea how to fix it except to try going to English (US), which sometimes works but not all of the time.

Tried everything that everybody stated. It still doesn’t work. However, read on. Perhaps somebody can solve the puzzle.

My regional setting is English Canadian.
My short date setting is dd/MM/yy.
My long date setting is MMMM d, yyyy.

In Word my default language is set to English (Canada).

In my Autotext, I have the box checked about the show autocomplete tip for autotext and dates.

For date and time, the language is set to English (Canada).

My default date format is @ “MMMM d, yyyy”.

HOWEVER (YES, I AM SHOUTING), I have a style called date. This style appears as “Normal +”. I can set it so it goes to “Normal + English (US)”. However, I can not set it so it becomes “Normal + English (Canada)”.

Now the funny part. When I set it to “Normal + English (US)” the Autocomplete for the date works. I type F E B, then February is suggested and I hit enter. I hit the space bar and today’s date comes up. I change the language to English (Canada) and it still works.

HOWEVER (I AM SHOUTING AGAIN), when I create a new document, even though I have put Date + English (US) on the normal template, it doesn’t work.

HELP!!!! I am going crazy.

Thank you for your devotion to this problem. Even though you haven’t discovered the solution, it is nice to know that I am not alone.

My long date is MMMM d, yyyy. My short date is dd/mm/yy.
My regional settings are set to English (Canadian). The default date format I am using in Word is February 11, 2001 – English Canadian. I have set and reset the autotext checkbox. The only way I seem to be able to get the thing to work is if I set it to English (US). Even then it works some of the time but not all of the time.

What am I doing wrong?

Tried both of these. Did not work.

I love the humour! But back to the original question. If I am not getting the date, regardless of the language, how can I get it to work.

For example, I type F E B R, up comes February and I hit enter to put the word in my text. I hit the space bar and expect to see today’s date. What I get is 01. Anybody have any idea of what is happening and how to fix it?

When I click on the button I want the Find dialog box to come up with the field I want in the “Look in” textbox, regardless what field I was in in the form. That way I can enter the criterium and click on find next and it will find the record I want, which in my example was somebody with a certain last name.

Many thanks to both of you.

Bart, what version of Access do you have? I have 2000 and when you hit F1 the help you receive is not too great (in my opinion) and when you hit the Help button it takes you to something that gives you general help on the expression builder. I know that the F1 key and the Help button were useful in earlier versions of Access.

Sorry for being so ignorant, but if I don’t ask questions, I guess I’ll never know.

1. What is ISAM?
2. The problem is that when asked to select an index, there are no options that I see. I guess I am wondering why there are no options and how I could create one in the original dbase database.
3. I am right in understanding that if you don’t select an index, I can not add a record to the linked database? I can only use the information.
4. The option to select an index does not appear if I am linking to an Excel table. Why not? Does this mean that I can not add a record to the Excel table? (I will try this and find out.)

Hopefully, you don’t mind all of my questions. I am one of those poor souls who has a thirst to know stuff, but has to be fed strained food because if it is too complex, I don’t understand it.

Thanks.

John

Thanks for your assistance.

I went into my dbf file using Paradox, created several secondary indexes, yet when I went to link there was still no option. I guess my question is how do I create an index that I can select when requested? At least then I will know why I get this request. Also, you suggested that I am probably getting the original table in the order it was created when I cancel. Sounds reasonable, but I sensed some doubt in your reply. Are you sure?

If you want the table I am fooling around with, I have attached it to this note. Perhaps you can create an index and send it back so when I link to the dbase file I will have an index when requested.

Thanks to both of you for replying. And a special thank you to Phil (love your two-colour signature) for allowing me to solve this problem in Word without going to Excel.