I've been running an Access2000 database for a couple years on a Win2k
machine fine. We tried to copy the database over to another machine that
already had Access2000 installed. When we tried to run it, we got an error
on the following piece of VBA code embedded in a form:
------------------------
With Me
.AgeMax = DateDiff("yyyy", Me.dteDateOfBirthMin, Date)
.AgeMin = DateDiff("yyyy", Me.dteDateOfBirthMax, Date)
End With
------------------------
Note AgeMax, AgeMin, dteDateOf BirthMin, dteDateOf BirthMax are controls on
the form.
The program chokes on the "Date" argument, claiming it is undefined.
Being the experienced Windows user I am, I immediately shut down and restart
the computer (this often solves such unusual problems). But it didn't solve
it this time.
So I click References in the "Tools" menu (design view for this module), and
it says the file "utility.mda" is missing. I assume this is where the Date
function is, or should be. So I click the Browse button and manually click
my way through the appropriate directories until I find the utility.mda
program. I double click it to tell Access where to find it. It tells me it
can't copy that file because a file with the same name already exists at
that location!!!!
Being the experienced Windows user I am, I shut down and restart Access.
Still doesn't work. So I restart the computer again. Still doesn't work. The
clock is running and my client is wondering why I'm having so much trouble
with a program they've been using on another machine for two years with no
trouble.
HELP!!!
Mike Metzger