B
Bee
Hello,
I am in the process of converting an old SQL 6.5 Back end /Access 2000 front
end database to SQL 2005 BE/Access 2003 FE system. There are lot of macros
in the old system. They are kind of spaghetti code - Form calls macro -
macro calls report -- or form calls macro - macro calls second form etc.. .
in stead of calling other forms/reports directly. Text boxes are named
text10, text12 etc.. etc..
Anyways, now when I open one of the main forms and click on any of the
command buttons, I get an error message that says 'Can't find macro or
macrogroup named "."' I have 3 command buttons on this form. This
happens only the first time when I click on ANY of the buttons, I get this
message and then the code that is attached to the button is executed. If I
click on the same button again, it works fine. I am at a loss here.
Same thing happens when I click on the next/previous record buttons.
I tried deleting the command buttons and adding them again. Same thing.
I tried creating a new form and copied the controls section by section. (Lot
of code attached to the form - so took the easy way and copied things onto a
blank form). First it worked and then started getting the same message.
Please help.
Thank you in advance.
Bharathi.
I am in the process of converting an old SQL 6.5 Back end /Access 2000 front
end database to SQL 2005 BE/Access 2003 FE system. There are lot of macros
in the old system. They are kind of spaghetti code - Form calls macro -
macro calls report -- or form calls macro - macro calls second form etc.. .
in stead of calling other forms/reports directly. Text boxes are named
text10, text12 etc.. etc..
Anyways, now when I open one of the main forms and click on any of the
command buttons, I get an error message that says 'Can't find macro or
macrogroup named "."' I have 3 command buttons on this form. This
happens only the first time when I click on ANY of the buttons, I get this
message and then the code that is attached to the button is executed. If I
click on the same button again, it works fine. I am at a loss here.
Same thing happens when I click on the next/previous record buttons.
I tried deleting the command buttons and adding them again. Same thing.
I tried creating a new form and copied the controls section by section. (Lot
of code attached to the form - so took the easy way and copied things onto a
blank form). First it worked and then started getting the same message.
Please help.
Thank you in advance.
Bharathi.