Susan Geller
sgeller at cce.umn.edu
Mon Jul 28 14:44:15 CDT 2003
As an update, I noticed that an older version did not cause this problem and there were very few changes since that version. I redid the changes and now the file is fine. I don't know what happened or why but for the moment the crisis is over. --Susan -----Original Message----- From: Susan Geller Sent: Monday, July 28, 2003 12:07 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Invalid Reference to the Property Form/Report All machines have been recently reimaged to include MDAC 2.7 sp1. I ran com check to be sure and we get the same message which is: "More than one version of MDAC matches your computer's configuration. One of these versions is 2.7 sp1 (WinXP). Select a specific version of MDAC from the Component Checker --Choose Analysis Type Dialog Box". I did that and both machines come back clear when I check MDAC 2.7 sp1 (WinXP). So, I think all MDACs are consistent between computers. I also tried Brett's suggestion of adding a ".Form" in the string and that doesn't help. I'm truly baffled. --Susan -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Monday, July 28, 2003 11:13 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Invalid Reference to the Property Form/Report Having inconsistent versions of ADO between machines can cause all sorts of bizarre problems. Have you made sure that the latest MDAC installer has been run on all the machines? Charlotte Foust -----Original Message----- From: Susan Geller [mailto:sgeller at cce.umn.edu] Sent: Monday, July 28, 2003 7:48 AM To: accessd at databaseadvisors.com Subject: [AccessD] Invalid Reference to the Property Form/Report I have an application and I'm testing the new release and suddenly getting an error in a place where I did not get one in an older version. And, I'm not getting it on the development machine, only on test machines. On a report, in the Private Sub PageHeaderSection_Format code, I have: Dim ctl As Control Dim strDescr As String Set ctl = Forms!frmWiz!SubCrit!lstTerm strDescr = BuildReportHeaderString(ctl, 1) The code runs fine when the report first opens in preview mode. But, when I try to preview page 2 or any subsequent pages, I get this message: "You entered an expression that has an invalid reference to the property Form/Report". When I step through the code, the error is in setting ctl. I tried getting rid of the ctl reference and instead used just: strDescr = BuildReportHeaderString(Forms!frmWiz!subCrit!lstTerm, 1) But I get the same error message at this line. References are ADO 2.7 library. I am at a total loss. --Susan Susan B. Geller Office of Information Systems College of Continuing Education University of Minnesota 306 Wesbrook Hall 77 Pleasant Street SE Minneapolis, MN 55455 Phone: 612-626-4785 Fax: 612-625-2568 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com