Question Access 2013 - Sort Database Window by Description ?

[horatio_too]

Hi

Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances.

Thankfully, "most" functionality appears to be working ok (although other posts on that to follow in due course).

However, one thing, apparently simple, is causing a lot of pain !

Many of my database objects, especially queries, were given meaningful descriptions.

For example, a number of queries might have been described as "Accounts Data Validation".

When I wanted to run validation of the Accounts data, I would simply sort the database queries window by description, then scroll to the relevant section and run all of the tagged queries in turn.

However, having migrated to Access 2013, although the descriptions are still shown, I can no longer sort by them !

Medium term, I could probably assign different database objects to "Groups", but we are talking hundreds, perhaps even thousands of different objects and that would be a laborious and extremely tedious process.

As such, does anybody have a way of sorting the database window by description in Access 2013 ?

As always, I look forward to any guidance or feedback that anybody may be able to offer.

Kind regards

Horatio_too

 

[CJ_London]

I haven't got 2013, but in 2010 you right click on the query header then select sort by.

Another alternative would be to create a single form with a listbox (I'll call it QueryList) rowsource of:

SELECT NAME FROM MSysObjects WHERE Type=5 ORDER BY NAME

Then in the listbox afterupdate event you can put the following code:

Currentdb.Execute(Me.QueryList)

Then selecting a query on the list will run the query - this assumes these queries are all action queries (update, append, delete).

 

[horatio_too]

Hi CJ London

Many thanks for your swift reply.

Apologies for the delay in responding, but only just got back in front of a PC.

The sort options for the database window in Access 2013 are:-

- Name
- Type
- Created date
- Modified date

i.e. No "Description" !

Although it is a workaround rather than a fix, you have given me enough of a pointer to hopefully be back productive without too much effort.

Many thanks and hope that you have a good weekend.

Kind regards

Horatio_too

 

[CJ_London]

Sorry - missed that!

In that case you'll need a routine to parse through the querydefs to pick up the description (haven't checked but presume that is where it will be)