Automatic Date Doesn't Work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm converting a large number of desktops to Office 2007. I've discovered a
problem that appears on all our installations. The auto date date completion
doesn't work. I've followed the instructions on Help exactly, have had
others try it to no avail. I wonder if something is missing in my install or
if it's a bug? It a feature our staff uses heavily and the only way I've
gotten around it not being there is to create a macro to insert the current
date. But that isn't a good solution. Has anyone else had this problem and
how is it resolved?
 
Interesting. Most people are irritated by it. A macro attached to a keyboard
shortcut or QAT button offers much more control.

If you type 2007 do you get a tool tip prompt? If you do, it is working
correctly. If not

Press Alt+F11 to display the Visual Basic Editor. In the Immediate window,
which can be displayed by pressing Ctrl+G, type the following:

Application.DisplayAutoCompleteTips = True

and press Enter.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
OK, here's the deal. I created the macro or did the Visual Basic script, and
now October 12, 2007 will appear as auto complete. However, to answer your
question typing 2007 does not give me a tool tip even though I have the
Application.DisplayAutoCompleteTips sent to True.

My big question is why doesn't it work as intended, on all my installed
base, especially since help explains how it works by default, but ours
doesn't.

Also what is a QAT key? I haven't heard that terminology and I'm a very
seasoned Word technician. What am I missing?
 
QAT (Quick Access Toolbar) .

I don't know why it isn't working for you. I suspect the level of
autocomplete support is dictated by the regional language settings of
Windows and/or the current language at the cursor. If you wish to follow my
previous suggestion and insert the date by macro then

Sub InsertUSFormatDate()
With Selection
.InsertDateTime DateTimeFormat:="MMMM" & Chr(160) & _
"d," & Chr(160) & "yyyy", InsertAsField:=False
End With
End Sub

attached to a QAT button or keyboard shortcut will do the trick


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Thanks, Graham. I understand how to make that macro, and I will if that's a
last resort, but think you are missing my point just a bit. I have a large
installed base and hate to go to each PC and create that Macro. I fully
believe it is Microsoft's responsibility to make a program work out of the
box as intended and this doesn't.

If I only had one or two PC's that needed that macro, no big deal, but when
it's every PC on which Office 2007 is installed then it's a different matter.
In the best of worlds, when MS help tells you how to do somthing it should
work. Can't you or someone get to an Office tech on this? I don't want to
put a $259.00 charge on my own personal credit card just to report this
problem.

If you can tell me some way I can globally put a keyboard macro in the
normal template of 60 PC's then I'll be some what satisfied even though I
believe MS should know about this one and solve it or tell me how to solve
it. Thanks much, Judy
 
I neither work for nor speak for Microsoft - I don't know what else to tell
you apart from what has already been discussed.
Insert > date & time works out of the box?
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
Graham thanks. I know you don't work for Microsoft, but I sure wished I new
how to talk to someone at Microsoft about this. It is somthing I'd like to
report as not working as intended and don't know where to report it.

Do you have any suggestions on how I can globally install a macro to many
PC's? That is without visiting each PC individually?
 
Judy, I'm with you on this. Where does one go to report bugs to Microsoft?
I'm retired from 45 years in IT, from Business Analyst all the way back to
machine language coding, assembler, and BASIC.
I no longer get paid to fix bugs but I do want my software to work as
advertised.
When I first installed Word 2007 I loaded in a text file that was created in
Word 2000 and updated daily right up to the end of the year (2007). The date
insertion function seemed to work.
I then started a new file for the 2008 year and it seemed that the date
insertion worked for a week or so and then just quit.
Now get this:
I just now went back to that earlier file and typed in (as the example in
the Help file shows) febr
The tip popped up saying to press enter. I did and February was completed.
I then hit the space bar and I got a space. That's all.
BUT... I then hit the backspace twice, typed in the y for the end of
February and I got the tip asking me to hit enter for the rest of the date,
and it worked!
How's that for a clue for the MS programmers to work on?
I don't even want to write a macro so I will just continue typing.
Frank
 
FWIW, Microsoft does know about this issue.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
 
I thought I did. What did I do wrong?
Thanks


Beth Melton said:
FWIW, Microsoft does know about this issue.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Click to expand...
 
I'm sorry, I'm not following you and it looks like you weren't following me.
:-)

My comment was that Microsoft does know about the AutoComplete issue for
dates in Word. (You asked about reporting it to Microsoft.)

Oh! Wait, I think you were referring to my standard signature? To post
follow-up questions to the newsgroup? It's part of my signature that is
added automatically. Some newsreaders include a "Reply Author" command and
it's there as a reminder to use "Reply Group" instead.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
 
I do find myself reading the "Please post" line in every one of your
messages -- could you move it below the dividing line that demarcates
your .sig from your message?
 
The reason it's not already below the line is because each time I've tried
moving it folks don't read it and I end up with a slew of follow-up
questions in my Inbox.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton

I do find myself reading the "Please post" line in every one of your
messages -- could you move it below the dividing line that demarcates
your .sig from your message?
 
I decided to go ahead and change my signature completely. I felt it was more
important to include a link that may help folks understand that MVPs are not
Microsoft employees. (I'm personally a little tired of being treated like
one! They couldn't pay me enough to work in PSS -- all of the ranting that
you have to take because you're being paid to listen? Nope, not for me.
;-) )

How about we make a deal? I'll keep my new signature and in return, could
you start posting your replies to the person in which you are actually
responding? The reasons for this request are:

1) These are threaded discussion groups and the majority of those who follow
these newsgroups use a tree view, not a linear view. (btw, Google Groups has
a tree view option.)

2) The protocol for at least the last 10 years has been threaded discussions
in these newsgroups. (I'm sure it's been longer but 10 years is about how
long I've been hanging out here. :-) )

3) The majority of the posters use Microsoft's web interface or Windows Mail
to access the newsgroups. Both have a subscription option that can be used
to notify them of replies to their posts. This is a "per post" option so if
you post your comments intended for the original poster (OP) on someone's
reply, the OP may not see your newly added information.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

I do find myself reading the "Please post" line in every one of your
messages -- could you move it below the dividing line that demarcates
your .sig from your message?
 
In an unrelated post, you mentioned this:
3) The majority of the posters use Microsoft's web interface or Windows
Mail to access the newsgroups. Both have a subscription option that can be
used to notify them of replies to their posts. This is a "per post" option
so if you post your comments intended for the original poster (OP) on
someone's reply, the OP may not see your newly added information.
Click to expand...

So, I would like to know how to activate that 'subscription option' in
Windows Mail, as I think it could be useful in posting, but I don't know how
to ask for such replies to my newsgroup posts. How do I do that in Windows
Mail? Thanks.
 
Thanks for that, I had not been aware of that 'Show Replies' setting -- now
that I look at it, it also has a shortcut toggle of Ctrl+H which will be
handy. That's why I browse these newsgroups, for little nuggets like that
:-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic date correction 1
Excel Macro for deleting Rows containing dates greater than "today" 0
Date changing automatically 1
I want the date to auto complete when I start to type 3
Word 2007 - autodate disable/enable?!?! 2
Automatic Date Insertion 1
Macro Stoped Working 2
auto date complete feature doesn't work 1

Back
Top