[AccessD] enumerating all properties in all forms

Heenan, Lambert Lambert.Heenan at AIG.com
Thu Feb 17 15:39:02 CST 2005


Is it because none of the forms is open?

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent:	Thursday, February 17, 2005 2:44 PM
> To:	'Access Developers discussion and problem solving'
> Subject:	[AccessD] enumerating all properties in all forms
> 
> The following procedure seems to totally skip the second For Each loop. No
> error, it just skips it, as if there are no properties in the Properties
> collection, which may be the case. I realize we're dealing with different
> collections and I may not be referencing things right. Any help?
>  
> Thanks!
> Susan H. 
>  
>  
> Public Function EnumAllFormProp()
>   'Print the name and setting for
>   'each property in every form.
>   Dim obj As Access.AccessObject
>   Dim prp As Access.AccessObjectProperty
>   For Each obj In CurrentProject.AllForms
>     Debug.Print obj.Name
>     For Each prp In obj.Properties
>       Debug.Print prp.Name
>       Debug.Print prp.Value
>     Next
>   Next
> End Function
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list