By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

Run-time error '3085': Undefined function 'Date' in Expression

P: 23
I created a database with a separate front-end that is installed on each computer and linked to a back-end server. After installing the file on several computers, I realized I was getting this error: Run-time error '3085': Undefined function 'Date' in Expression. I did some research and found out that it's an issue with my references. So, I was able to fix it. But my concern is if I make changes to the front-end and need to update everyone's computer, will this happen with each new install? Is there a way to ensure the references are located in the same place on each computer using the database or have I just dont something wrong? Any help would be great.

Thank you,
CC
Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, there.

Access has References collection of Reference class objects. You'll find where sufficient methods and properties to detect and remove/repair broken reference.

The mechanism of reparing depends on what a broken reference is referencing. Sure, if this is an Access database, DLL/executable or ActiveX control you should include them in installation package. If this is type library of other application (like Office applications) there is almost nothing to do but to install a required application or warn a user and delete the broken reference to make at least others working.

Regards,
Fish
Dec 12 '07 #2

P: 23
Well, I found tutorials to help with this error, and what I did to fix the problem was log into the database on the individual computers, uncheck a select reference and then reinstall it, and it seems to work.
Dec 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.