Access 2002 hasproperty won't compile in 2007 replcemnt function?

's Computer Specifications

I'm trying to use the Function LockBoundControls which is a public function
and posted on several help sites. It uses
If HasProperty(ctl, "ControlSource") Then

which won't compile in Access 2007 but gives me no problem in ver 2002. Any
suggestions on how to port this code?

's Computer Specifications

I tested the code form Allen Browne's site and had no problem with it.

http://allenbrowne.com/ser-56.html

--
Regards,

OssieMac

"TybeeDi" wrote:

> I'm trying to use the Function LockBoundControls which is a public function
> and posted on several help sites. It uses
> If HasProperty(ctl, "ControlSource") Then
>
> which won't compile in Access 2007 but gives me no problem in ver 2002. Any
> suggestions on how to port this code?

's Computer Specifications

I meant to include "what error are you getting when compiling"?

--
Regards,

OssieMac

"OssieMac" wrote:

> I tested the code form Allen Browne's site and had no problem with it.
>
> http://allenbrowne.com/ser-56.html
>
>
> --
> Regards,
>
> OssieMac
>
>
> "TybeeDi" wrote:
>
> > I'm trying to use the Function LockBoundControls which is a public function
> > and posted on several help sites. It uses
> > If HasProperty(ctl, "ControlSource") Then
> >
> > which won't compile in Access 2007 but gives me no problem in ver 2002. Any
> > suggestions on how to port this code?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2002/2003 Error during VBA compile	=?Utf-8?B?QmlsbA==?=	Microsoft Access VBA Modules	1	22nd Sep 2006 10:21 PM
Compile error in hidden module - Trying to Open in Access 2002 a file which was built in Access 2003	Dick	Microsoft Access Security	3	23rd Feb 2006 11:26 PM
access 97 to 2002, security and compile problem	=?Utf-8?B?eHl5?=	Microsoft Access	0	7th Apr 2004 03:56 PM
convert access 97 to 2002, security and compile problem	=?Utf-8?B?eHl5?=	Microsoft Access	1	7th Apr 2004 12:15 AM
convert access 97 to 2002, security and compile problem	=?Utf-8?B?eHl5?=	Microsoft Access	0	6th Apr 2004 09:46 PM