Macro Error: Can't Find the Macro

[rdw1260]

I'm using Access 2003. I downloaded the Issues template. When I open Edit
Contacts and attempt to select a report by double clicking a specific report
for that contact I get an error message that "Issues can't find the macro
1stReports: On Dbl Click in macro group View Reports Macros." Below is the
macro that appears to be the problem. The command "On Click" works properly.
The command "On Dbl Click" does not work. I do not understand why this is not
working, the only difference is that you double click rather than click.
===============================================
Macro Name: cmdOpenReport : On Click
Action: OpenReport
Report Name: =[Forms]![View Reports]![lstReports]
View: Print Preview
Window Mode: Normal

Macro Name: lstReports : On Dbl Click
Action: OpenReport
Report Name: =[Forms]![View Reports]![lstReports]
View: Print Preview
Window Mode: Normal
===============================================

Thanks for any responses

 

[Steve Schapel]

Bob,

I am not sure exactly, but I personally would not the Dbl Click event of
a listbox - it just seems a little risky, since clicking on a listblx
item is so central to its functionality. After Update is always a good
one for comboboxes and listboxes.

Do I also understand that you have used a : as part of the name of the
macro? If so, there's another dicey thing I would change.

I notice in your macro it is lstReports whereas in the error message you
quoted, it says 1stReports. I don't know whether the mixup with the 1
and l is a typo?

 

[rdw1260]

Steve:

I think you found the error. I will correct the lstReports to 1stReports and
see if that's the error. I will let you know. Very, very good catch. I looked
for that type of error and still did not see it.

Thanks,
--
Bob

Bob,

I am not sure exactly, but I personally would not the Dbl Click event of
a listbox - it just seems a little risky, since clicking on a listblx
item is so central to its functionality. After Update is always a good
one for comboboxes and listboxes.

Do I also understand that you have used a : as part of the name of the
macro? If so, there's another dicey thing I would change.

I notice in your macro it is lstReports whereas in the error message you
quoted, it says 1stReports. I don't know whether the mixup with the 1
and l is a typo?

--
Steve Schapel, Microsoft Access MVP

I'm using Access 2003. I downloaded the Issues template. When I open Edit
Contacts and attempt to select a report by double clicking a specific report
for that contact I get an error message that "Issues can't find the macro
1stReports: On Dbl Click in macro group View Reports Macros." Below is the
macro that appears to be the problem. The command "On Click" works properly.
The command "On Dbl Click" does not work. I do not understand why this is not
working, the only difference is that you double click rather than click.
===============================================
Macro Name: cmdOpenReport : On Click
Action: OpenReport
Report Name: =[Forms]![View Reports]![lstReports]
View: Print Preview
Window Mode: Normal

Macro Name: lstReports : On Dbl Click
Action: OpenReport
Report Name: =[Forms]![View Reports]![lstReports]
View: Print Preview
Window Mode: Normal
===============================================

Thanks for any responses

 

[rdw1260]

Steve:

It worked when I changed the name to 1stReports.

Thanks,
--
Bob

Steve:

I think you found the error. I will correct the lstReports to 1stReports and
see if that's the error. I will let you know. Very, very good catch. I looked
for that type of error and still did not see it.

Thanks,
--
Bob

Bob,

I am not sure exactly, but I personally would not the Dbl Click event of
a listbox - it just seems a little risky, since clicking on a listblx
item is so central to its functionality. After Update is always a good
one for comboboxes and listboxes.

Do I also understand that you have used a : as part of the name of the
macro? If so, there's another dicey thing I would change.

I notice in your macro it is lstReports whereas in the error message you
quoted, it says 1stReports. I don't know whether the mixup with the 1
and l is a typo?

--
Steve Schapel, Microsoft Access MVP

I'm using Access 2003. I downloaded the Issues template. When I open Edit
Contacts and attempt to select a report by double clicking a specific report
for that contact I get an error message that "Issues can't find the macro
1stReports: On Dbl Click in macro group View Reports Macros." Below is the
macro that appears to be the problem. The command "On Click" works properly.
The command "On Dbl Click" does not work. I do not understand why this is not
working, the only difference is that you double click rather than click.
===============================================
Macro Name: cmdOpenReport : On Click
Action: OpenReport
Report Name: =[Forms]![View Reports]![lstReports]
View: Print Preview
Window Mode: Normal

Macro Name: lstReports : On Dbl Click
Action: OpenReport
Report Name: =[Forms]![View Reports]![lstReports]
View: Print Preview
Window Mode: Normal
===============================================

Thanks for any responses