Setting references in runtime application

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2000 application that periodically causes me grief. In certain report controls where I use the Format function, some workstations display #Name? on the report while other workstations function as they are supposed to.

I have the startup options set to not allow special keys. The application also uses a custom menu so I have unselected the Allow Built-in Toolbars before distributing the application. I have seen other newsgroup postings suggesting that a reference problem could cause this situation. How do I check the references when the application does not allow access to the VB editor because special keys is disabled? This is an application that is distributed to a customer base so it is not possible to physically visit each workstation to check the references. Can this be done in code

Is there any other reason I would be getting this error on some workstations and not others

Thank you for any suggestions
Jea
 
I don't understand what I'm doing wrong. While trying to determine what is causing the #Name? error I have run into a situation that is really confusing me

I do not have the problem mentioned above on my development workstation. However, one of my beta users has the problem on his laptop. So I am using his laptop to troubleshoot the cause. We are both running Access 2000 and Win2K. If I remove the Format function from the expression in the problem control of the report on the laptop the data displays correctly (but not in the format I want). The expression is as follows

=IIf(IsNull([qry_T4Combo.RcrdTime]),Format([qry_T1Combo.Begin],"Medium Time") & " - " & Format([qry_T1Combo.End],"Medium Time"),Format([qry_T4Combo.Begin],"Medium Time") & " - " & Format([qry_T4Combo.End],"Medium Time")

However, if I then try to put the expression back to the original on the laptop I get an error message "The function you entered can't be used in this expression." Why am I able to use the Format function on my PC but not on the laptop

Again, any help is greatly appreciated
Jean
 
Hi Jean,

If I understand correctly that you encountered the following error message
when you use Format function in your user's laptop.

"The function you entered can't be used in this expression."

If I have misunderstood, please feel free to let me know.

Based on my experience, this error is always caused by the reference
problem. Please check the reference of the Access database in the laptop.
(In the VBA environment, Tools -> References)
a. Check to see if there is any missing reference.
b. Check to see if there is any strange reference added in the list.

In the meantime, please apply the latest version of MDAC on the laptop.
Microsoft Data Access Components (MDAC) 2.8
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-
b037-185d0506396c&DisplayLang=en

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Hi Jean,

This article shows you how to use a Visual Basic for Applications procedure
to loop through the References collection and retrieve the properties of
each reference.

209849 ACC2000: How to Loop Through References to View Their Properties
http://support.microsoft.com/?id=209849

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Thanks for the responses

As I previously stated, I understand how to look at the references through the VB editor, however, my original posting asked how to do this in a runtime application where the VB editor is not accessible

I found the following article for Access 97. Will this also work for Access 2000
http://support.microsoft.com/?id=19437

Thanks again
Jea
 
Hi Jean,

Thanks for your feedback. The problem described in the article KB194374 is
similiar with yours. You can try these suggestions in Access 2000. Also, do
you see my previous response with the KB 209849, which will show you how to
use a Visual Basic for Applications procedure to loop through the
References collection and retrieve the properties of each reference. You
can try it to check the reference before the suggestions in KB 194374.

209849 ACC2000: How to Loop Through References to View Their Properties
http://support.microsoft.com/?id=209849

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Back
Top