Darrell Burns
dhb at flsi.com
Fri Jun 17 19:04:00 CDT 2011
I actually did find the culprit, Doug. When the app starts up it runs a subroutine that opens each form in design mode to determine its recordsource. This works just fine in an accdb but, of course, an accde doesn't allow it. Now that I've reprogrammed that whole module, it works fine in an accde, but now I've got something holding me up in the runtime version. A form that's normally opened from a Switchboard button won't open. This time, no error message. I took your advice and installed MZTools and added line numbers. Now how do I display the offending line # in my Error message? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, June 17, 2011 10:50 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] The command you specified is not available in an .accde database If you use MZ tools put add line numbers to the routines that run on start, and put the line number of the line that fails in your error message. This will give you the routine and line that fails. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns Sent: Friday, June 17, 2011 9:43 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] The command you specified is not available in an .accde database Hello. I have an A2007 app that starts up with a Login that opens a switchboard. It works fine as an a accdb, but when I saved it as an accde I get the following error message: "The expression On Open you entered as the event property setting produced the following error: The command you specified is not available in an .mde, .accde, or .ade database." I can't put a trace on it because it's an accde. Could it possibly be complaining about this command..."Set CurrProj = Application.CurrentProject"? -- 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