Date Error with Windows 7

All my Dates in my friends access db are erroring now that my friend has
windows 7 Installed, Has anyone heard about this???

--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3

On Tue, 27 Apr 2010 06:11:32 +1200, "Bob Vance" wrote:

All my Dates in my friends access db are erroring now that my friend has
windows 7 Installed, Has anyone heard about this???

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

It may be that the .DLL files have different names or a different location in
Windows 7.
--

John W. Vinson [MVP]

Anytime I see a problem with the Date() function, I have a knee-jerk reaction
about references. Go to the following web page for information on checking
references:

http://www.mvps.org/access/bugs/bugs0001.htm
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Bob Vance" wrote:

All my Dates in my friends access db are erroring now that my friend has
windows 7 Installed, Has anyone heard about this???

--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3


.

Thanks John, My db on my machine is fine with XP, My db on my friends
machine is Runtime Windows 7 will that make a difference??
Regadrs Bob

"John W. Vinson" wrote in message
...
On Tue, 27 Apr 2010 06:11:32 +1200, "Bob Vance"
wrote:

All my Dates in my friends access db are erroring now that my friend has
windows 7 Installed, Has anyone heard about this???

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
.DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

It may be that the .DLL files have different names or a different location
in
Windows 7.
--

John W. Vinson [MVP]

Going by my friends screen shoots of my db, It is erroring
Function is not available in Expressions in query expression
Format([HorseDate],"dd-mmm-yy".
12 errors and they all finish with a dot and not a bracket is this normal???
Regards Bob

"John W. Vinson" wrote in message
...
On Tue, 27 Apr 2010 06:11:32 +1200, "Bob Vance"
wrote:

All my Dates in my friends access db are erroring now that my friend has
windows 7 Installed, Has anyone heard about this???

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
.DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

It may be that the .DLL files have different names or a different location
in
Windows 7.
--

John W. Vinson [MVP]

On Tue, 27 Apr 2010 10:58:53 +1200, "Bob Vance" wrote:

Going by my friends screen shoots of my db, It is erroring
Function is not available in Expressions in query expression
Format([HorseDate],"dd-mmm-yy".
12 errors and they all finish with a dot and not a bracket is this normal???
Regards Bob

I have no idea; I don't have Win7 and have no immediate intention to install
it.
--

John W. Vinson [MVP]

Thanks John but what happens when you buy a new machine that has win7 pre
loaded
Regards Bob

"John W. Vinson" wrote in message
...
On Tue, 27 Apr 2010 10:58:53 +1200, "Bob Vance"
wrote:

Going by my friends screen shoots of my db, It is erroring
Function is not available in Expressions in query expression
Format([HorseDate],"dd-mmm-yy".
12 errors and they all finish with a dot and not a bracket is this
normal???
Regards Bob

I have no idea; I don't have Win7 and have no immediate intention to
install
it.
--

John W. Vinson [MVP]

On Tue, 27 Apr 2010 21:24:48 +1200, "Bob Vance" wrote:

Thanks John but what happens when you buy a new machine that has win7 pre
loaded

I'll cross that bridge when I get to it.

Sorry if my response sounded like criticism of you - that wasn't the intent at
all! I'm simply saying that "I Don't Know" and can't give you any advice,
because I don't have Win7 and cannot do any testing. Apologies if it came
across as anything other than that!
--

John W. Vinson [MVP]

John W. Vinson wrote in
:

On Tue, 27 Apr 2010 10:58:53 +1200, "Bob Vance"
wrote:

Going by my friends screen shoots of my db, It is erroring
Function is not available in Expressions in query expression
Format([HorseDate],"dd-mmm-yy".
12 errors and they all finish with a dot and not a bracket is this
normal??? Regards Bob

I have no idea; I don't have Win7 and have no immediate intention
to install it.

Windows 7 does not cause any more reference problems than any other
version of Windows.

If everyone would avoid adding any references other than the base
three (Access, VBA and DAO), they'd not run into these problems.
Late binding allows the use of all sorts of external libraries
without exposing the app to the broken reference problem.

I can't see why anyone would ever add references to anything other
than those basic three, except perhaps naivete, or laziness.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

John W. Vinson wrote in
:

On Tue, 27 Apr 2010 21:24:48 +1200, "Bob Vance"
wrote:

Thanks John but what happens when you buy a new machine that has
win7 pre loaded

I'll cross that bridge when I get to it.

Sorry if my response sounded like criticism of you - that wasn't
the intent at all! I'm simply saying that "I Don't Know" and can't
give you any advice, because I don't have Win7 and cannot do any
testing. Apologies if it came across as anything other than that!

If you have an MSDN subscription, I highly recommend that you
download and install Win7. It's the best version of Windows since
Windows 2000, by a longshot, and I'd say it's better than Win2K, as
well. I really love it and am finding my clients do, too.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/