Wrox Programmer Forums
|
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
 
Old November 11th, 2003, 03:14 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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



 
Old November 11th, 2003, 03:32 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old November 11th, 2003, 03:55 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old November 11th, 2003, 04:01 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old November 11th, 2003, 04:17 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

How are you setting KeyPreview to no?



Sal
 
Old November 11th, 2003, 04:22 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sal,

Right click in the left corner,on the square, where the rulers meet.

Later,

Bob

 
Old November 11th, 2003, 04:25 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

and then



Sal
 
Old November 11th, 2003, 04:35 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry!

Click Properties.

Select "All" tab.

Select "No" on Key Preview

Later,

Bob

 
Old November 11th, 2003, 04:46 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

 
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.
Quote:
What exactly was 1 of 1. The page number? what changes have you made to it.



Sal
 
Old November 11th, 2003, 05:08 PM
Authorized User
 
Join Date: Oct 2003
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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







Similar Threads
Thread Thread Starter Forum Replies Last Post
Hotkeys in macros HaileyJ Access 2 September 10th, 2007 03:13 AM
Macros vs VB ophelia VB Databases Basics 1 July 9th, 2007 04:05 PM
Pause between macros paul20091968 Access VBA 2 April 6th, 2007 01:40 AM
Distributing Macros Larry Landis Word VBA 1 March 31st, 2006 02:29 PM
Enable - Macros alannoble26 Excel VBA 2 November 28th, 2005 09:08 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.