Macro doesn't exist

This is a discussion on Macro doesn't exist within the ADO DAO RDO RDS forums in Framework and Interface Programming category; I'm trying to use the MS help for Enumerating records on a datasheet ( http://support.microsoft.com/kb/294202 ). I've taken this macro and replicated it for my use (and in my particular case, following the directions for subform use.) Everytime I mouse over the newly created command button I get the error "Microsoft Access Can't find the Macro 'SelRecord([subformname].form,"move") I thought that perhaps it was something wrong with the way I was referencing the subform so I decided to follow the KB directions to do this in the Northwind database. But I followed directions to use the functions/macro there (and this time ...

Go Back   Application Development Forum > Framework and Interface Programming > ADO DAO RDO RDS

Object Mix

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 09-08-2008, 12:28 AM
thereames
Guest
 
Default Macro doesn't exist

I'm trying to use the MS help for Enumerating records on a datasheet
(http://support.microsoft.com/kb/294202). I've taken this macro and
replicated it for my use (and in my particular case, following the
directions for subform use.)

Everytime I mouse over the newly created command button I get the
error "Microsoft Access Can't find the Macro
'SelRecord([subformname].form,"move")

I thought that perhaps it was something wrong with the way I was
referencing the subform so I decided to follow the KB directions to do
this in the Northwind database. But I followed directions to use the
functions/macro there (and this time without trying to use a subform
even) and I get the exact same error.

I have double checked my References to be sure DAO 3.6 is referenced
already, which it is.

Thoughts?
Reply With Quote
  #2  
Old 09-08-2008, 02:12 AM
John W. Vinson
Guest
 
Default Re: Macro doesn't exist

On Sun, 7 Sep 2008 21:28:16 -0700 (PDT), thereames <thereames@gmail.com>
wrote:

>Everytime I mouse over the newly created command button I get the
>error "Microsoft Access Can't find the Macro
>'SelRecord([subformname].form,"move")


Preface it with an = sign: The command button's click event property should
read

=SelRecord([subformname].form,"move")

I'm assuming that SelRecord is stored as a Function rather than a Sub.

--

John W. Vinson [MVP]
Reply With Quote
  #3  
Old 09-09-2008, 12:12 AM
thereames
Guest
 
Default Re: Macro doesn't exist

You got it. Thanks for helping me with my overlook!
Reply With Quote
Reply


Thread Tools
Display Modes


All times are GMT -5. The time now is 04:01 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.