Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 11th, 2003, 03:14 PM
Authorized User
 
Join Date: Oct 2003
Location: Bovard, Pa, USA.
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



Reply With Quote
  #2 (permalink)  
Old November 11th, 2003, 03:32 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #3 (permalink)  
Old November 11th, 2003, 03:55 PM
Authorized User
 
Join Date: Oct 2003
Location: Bovard, Pa, USA.
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

Reply With Quote
  #4 (permalink)  
Old November 11th, 2003, 04:01 PM
Authorized User
 
Join Date: Oct 2003
Location: Bovard, Pa, USA.
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

Reply With Quote
  #5 (permalink)  
Old November 11th, 2003, 04:17 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

How are you setting KeyPreview to no?



Sal
Reply With Quote
  #6 (permalink)  
Old November 11th, 2003, 04:22 PM
Authorized User
 
Join Date: Oct 2003
Location: Bovard, Pa, USA.
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

Reply With Quote
  #7 (permalink)  
Old November 11th, 2003, 04:25 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

and then



Sal
Reply With Quote
  #8 (permalink)  
Old November 11th, 2003, 04:35 PM
Authorized User
 
Join Date: Oct 2003
Location: Bovard, Pa, USA.
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry!

Click Properties.

Select "All" tab.

Select "No" on Key Preview

Later,

Bob

Reply With Quote
  #9 (permalink)  
Old November 11th, 2003, 04:46 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
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
Reply With Quote
  #10 (permalink)  
Old November 11th, 2003, 05:08 PM
Authorized User
 
Join Date: Oct 2003
Location: Bovard, Pa, USA.
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


Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:26 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.