ACCESS FEED: RE: [MS_AccessPros] View Object Properties

Senin, 12 Agustus 2013

RE: [MS_AccessPros] View Object Properties

Did you "First, add this function in VBA:" and make sure you didn't name the module the same as the function?

Duane Hookom MVP
MS Access

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: luvmymelody@yahoo.com
> Date: Mon, 12 Aug 2013 15:27:50 -0700
> Subject: Re: [MS_AccessPros] View Object Properties
>
> John,
>
> After a lot of research on what you said, I found this on the access blog, but I get an Undefined function 'stDesc' in expression error
>
> http://blogs.office.com/b/microsoft-access/archive/2007/10/03/sorting-nav-pane-objects-by-description.aspx
>
>
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: John Viescas <JohnV@msn.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Monday, August 12, 2013 2:02 PM
> Subject: RE: [MS_AccessPros] View Object Properties
>
>
>
>
> Jim-
>
> You won't find object properties in any of the system tables. To get to the
> properties, you either have to walk through DAO TableDefs or QueryDefs or
> open Forms and Reports in at least Design view from either Documents or the
> AllForms or AllReports collections.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
> Sent: Monday, August 12, 2013 6:23 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] View Object Properties
>
> Is there a system table that shows the Object Properties? I went through all
> of the System objects and did not see any. I am rebuilding a database object
> by object to delete any legacy objects. So I am writing legacy in the object
> properties. But I would like to write a query based on the object properties
> to get a list of the legacy objects, but I cannot find the system table with
> that information in it.
>
> Thank You
>
> Jim Wagner
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>