Check your references. Go into the VB Editor, and select Tools | References.
Examine all of the selected references (they'll be at the top of the list).
If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.
If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
Peter B said:
Thanks - I have done all that and installed all SR up to no 3. I still
have the problem.
Any other ideas anyone?
Peter
Douglas J. Steele said:
I'm not sure Microsoft Update works with Office 2000, so you'll likely
have to go to
http://download.microsoft.com and search for service packs
in the Office family.
--
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
Peter B said:
Thanks - I will try that. Where can I find the Service Pack? I only
have the original CD.
Peter
"Mike Labosh" <mlabosh_at_hotmail_dot_com> wrote in message
I have MS Access 2000. I have recently installed it on a new computer
and
transferred my mbd files across. These work OK, including those using
SQL
Aggregate funtions. However if I set up a new database, I foind that
some
of these functions do not work. For instance, I get #Error messages
when
trying to use count([fieldname]) or Date(). Sum works OK. As far as
I
can
see all relevant parts of Access and MS office seem to be installed.
Here's what I would do:
1. Run the Office / Access Setup utility in "Repair" mode.
2. Reboot the computer
3. Reapply the latest service pack
4. Reboot the computer
5. Try again
--
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei
