We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

MS Access Missing Date function error  2002 vs 2003

jjpharmd
jjpharmd asked
on
Medium Priority
298 Views
Last Modified: 2008-03-10
I have seen a couple of similar questions, but I am hoping there might be a simple solution to my particular version.

I have a database on a laptop with office 2003.  I have synchronized it with my desktop running office XP (2002) without a problem for some time.  I recently added some vba code that uses the Date function in conjuction with Outlook automation from Access.  When I synced it, the desktop running 2002 crashed trying to boot the switchboard with Missing date function message.  

Can I use the Microsoft Outlook 11.0 reference library from the laptop on the desktop running 2002?  Or will that crash something else.  

Comment
Watch Question

the message that Date is Missing, indicates that you have a 'Broken Reference' in your application.  Open the Database in design mode, go to ANY code page (a page that has VBA code), and then click on Tools/References from the menu bar.  You will probably find at least one Reference marked as 'MISSING'


If that is the case, make not of the Missing Reference, and UNCHECK it.  then Click the Ok button.

Once again, open Tools/References  and now search the the alphabetical list of COM references for the one that was previously 'MISSING', or one that is close (if you have a problem with this step, simply post back here what was MISSING, and I will try tompoint you in the reight direction) and then select it, by clicking the checkbox next to the Reference, then click the OK buttons again.  That should solve the problem.

AW

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
thank you.
if that resolved your issue, then please close this question.

Glad to be of assistance.

AW
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.