 |
| Access VBA Discuss using VBA for Access programming. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|

November 11th, 2003, 03:14 PM
|
|
Authorized User
|
|
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Macros
Hi, All!
I have frmPopUp. Everytime I run Special Ticker Event in Access the form pops up letting me know if I have an appointment or other events that day.
I have frmSpecial_Events. It is a data-entry form. Its Record Source is tblSpecial_Events. There are no Macros attached or implemented in it. Everytime I open it now, to enter an appointment into tblSpecial_Events, I get "Special Ticker Event can't find the Macro'.' The macro (or its macro group) doesn't exist . . . . ."
I can still add data to the table. I don't understand the reason for the message.
The frmPopUp has a macro and event procedure
Any suggestions would be appreciated.
Thanks in advance,
Bob
|
|

November 11th, 2003, 03:32 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Do you have any code at all on your frmSpecial_Events form? The form is looking for something. You may have put some code on it at some point, and now the form is looking for it.
Open your form in design view, then click on the "code" button on the toolbar and see if there is any code.
if there is code paste it here.
Sal
|
|

November 11th, 2003, 03:55 PM
|
|
Authorized User
|
|
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Hi, Sal!
Thanks for responding!!
The only two things I did was set Key Preview to "No" and Data Entry to "Yes" in the form properties. That's why I'm really frustrated!
Thanks in advance,
Bob
|
|

November 11th, 2003, 04:01 PM
|
|
Authorized User
|
|
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Sal,
When I first created the form, when I would hit Tab the Navigation would stay at 1 of 1. And all of the textboxes would clear.
Now when I hit tab, I would get 2 of 2, the textboxes would clear and ". . . can't find macro" error message would come up.
Hope this helps,
Bob
|
|

November 11th, 2003, 04:17 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
How are you setting KeyPreview to no?
Sal
|
|

November 11th, 2003, 04:22 PM
|
|
Authorized User
|
|
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Sal,
Right click in the left corner,on the square, where the rulers meet.
Later,
Bob
|
|

November 11th, 2003, 04:25 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
and then
Sal
|
|

November 11th, 2003, 04:35 PM
|
|
Authorized User
|
|
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Sorry!
Click Properties.
Select "All" tab.
Select "No" on Key Preview
Later,
Bob
|
|

November 11th, 2003, 04:46 PM
|
|
Friend of Wrox
|
|
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Quote:
|
quote:When I first created the form, when I would hit Tab the Navigation would stay at 1 of 1. And all of the textboxes would clear.
|
What exactly was 1 of 1. The page number? what changes have you made to it.
Sal
|
|

November 11th, 2003, 05:08 PM
|
|
Authorized User
|
|
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
I would open up the frmSpecial_Events. "Special Ticker Event can't find the Macro'.' The macro (or its macro group) doesn't exist . . . . ." would come up.
I would fill in all of the textboxes, hitting Tab each time.
After filling in the last textbox, I would hit Tab. The insertion point would be in the 1st textbox and the Record Navigation would be 1 of 1. No matter how many records I would enter, the Record Navigation would always say 1 of 1.
Now I get the "Special Ticker Event can't find the Macro'.' The macro (or its macro group) doesn't exist . . . . ." everytime I hit the Tab key after the last textbox and when I 1st open the form up.
Bob
|
|
 |