ACCESS FEED: RE: [MS_AccessPros] View Object Properties

Senin, 12 Agustus 2013

RE: [MS_AccessPros] View Object Properties

Jim-

The Description property is not a built-in property. If you have not entered a Description in all objects, you will get a property not defined error when you try to reference an object's Description that does not have one. However, the On Error Resume Next should take care of that. With the error trap, you will get a blank return for objects that have no Description defined.

Note that you can do the same sort of code for Tables using TableDef, but to get the Description property of a Form or Report, you'll have to modify the code to open each object in Design view, grab the property, then close the object.

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 Jim Wagner
Sent: Tuesday, August 13, 2013 1:52 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] View Object Properties

Duane,

I did it in the order listed on the blog

I did not create a module. I just did that and it worked.

Thank You

Jim Wagner
________________________________

________________________________
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>
Sent: Monday, August 12, 2013 4:33 PM
Subject: 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
>
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links