Robert Gracie
Subscriptions at servicexp.com
Sat Apr 17 12:03:54 CDT 2004
I think the problem is in the line below (Corrected) in the MergeSysVars method. The .Value must be added. mcolSysVars.Add Item:=!SV_VarValue.Value, Key:=!SV_VarName.Value Robert Gracie www.servicexp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Hecht Sent: Friday, April 16, 2004 11:24 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Help with sysvar demo John, It is your sysvar demo. Did you get the e mail I sent you privately? JOE HECHT LOS ANGELES CA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby Sent: Friday, April 16, 2004 7:45 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Help with sysvar demo Is that from my site or DatabaseAdvisors? Or somewhere else? John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Joe Hecht Sent: Friday, April 16, 2004 9:25 PM To: AccessD Subject: [AccessD] Help with sysvar demo I opened a copy of the sysvar 2k mdb and built the additional tables. When I try to open frmSysVar I get the error " Compile Error: User defined type: Not defined. Dim mdb as DAO.Database I checked and I do have the dao reference marked. It is XP in 2000 format Any thoughts apreciated JOE HECHT LOS ANGELES CA -- _______________________________________________ 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