microsoft office pro update key Sorting Nav Pane O

[xingqiuda762]

a short while ago had some issues from end users who chosen to type their DBC from the description field and desired in order to do the exact same thing with the 2007 navigation pane. If you use this scenario,microsoft windows 7 home basic x86, and you've tried in 2007,microsoft windows 7 64bit key, you'll know that the navigation pane doesn't have a type from the description discipline. One way to work around this is to create a query that does it for you. sample that lists the user Query objects from the database along with their descriptions. Note because the Description property is not stored as a area in MSysObjects,microsoft office Home And Student 2010 64 bit key, you need some accompanying VBA logic to retrieve the description property from the property bag. this function in VBA: Function stDesc(stQryName As String) As String
On Error Resume Next
stDesc = CurrentDb.QueryDefs(stQryName).Properties("Descrip tion")
End Function run this query: MSysObjects.Name,microsoft office pro update key, stDesc([Name]) AS Description
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~*") AND ((MSysObjects.Type)=5))
ORDER BY stDesc([Name]);