Rocky Smolin
rockysmolin at bchacc.com
Sun Jun 19 09:53:27 CDT 2011
Does MZ Tools have a function to locate unused objects like queries? Gotta
clean up an app.
TIA
Rocky
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Sunday, June 19, 2011 7:41 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] [Spam]8.31 Re: The command you specified is not
available in an .accde database
Yes, the lines must be numbered. MZ Tools is a free download and has
numbering capability built in
Jim
Sent from my iPhone
On Jun 19, 2011, at 9:34 AM, "Mark Simms" <marksimms at verizon.net> wrote:
> I take it that Erl is only enabled when line numbering is turned-on ?
> That is for both Excel and Access vba then ?
>
>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
>> bounces at databaseadvisors.com] On Behalf Of Darrell Burns
>> Sent: Saturday, June 18, 2011 9:59 PM
>> To: 'Access Developers discussion and problem solving'
>> Subject: Re: [AccessD] [Spam]8.31 Re: The command you specified is
>> not available in an .accde database
>>
>> Thanx Bill, I finally got the answer off another forum...it's "Erl".
>>
>> Here's how I use it now in my error handlers:
>> MsgBox "Error " & Err.Number & " (" & Err.Description & ") in
>> procedure GoToDirect of VBA Document Form_Asset_Master",
>> vbExclamation + vbOKOnly, "ERROR" + IIf(Erl > 0, " Line # " & Erl,
>> "")
>>
>> It's already helped me pinpoint a hidden bug.
>>
>> -Darrell
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
>> Benson
>> Sent: Saturday, June 18, 2011 11:34 AM
>> To: Access Developers discussion and problem solving
>> Subject: [Spam]8.31 Re: [AccessD] The command you specified is not
>> available in an .accde database
>>
>> Perhaps a property of the err object which you can examine in your
>> error handler section.
>>
>> Bill Benson
>> Owner
>> VBACreations, LLC
>> On Jun 17, 2011 8:05 PM, "Darrell Burns" <dhb at flsi.com> wrote:
>>> 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
>>>
>>> --
>>> 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
>
>
> --
> 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