Renaming queries

[abw]

I'm a fairly new access user. I often find that I end up with 50 or 60 queries and can't remember quite what they are. I'd like to be able to rename some old queries but when I do, subsequent queries that use them get messed up. Is there any way around this? Also, is there any way to organize my queries within the query tab, they arrange themselves alphabetically.

 

[kellan4459]

If you change the name of a query you will have to go back and change the query name in any field that points to or calls that query. As far as sorting the queries in the query window I'm not sure of any way to do that but one option you can use is creat a Form Called Queries and set up a bunch of command buttons that run the queries. This way you can rearrange them at any time.

 

[saintsman]

I usually give all my tables,queries etc a code so that other people will find it hard to fiddle (in also makes me a little more indespensable in these difficult times). To keep track I just keep a record in a book of what they all mean.

 

[pcs]

you can also add a description to each query, by right clicking on it in the database display window, select properties, then type in a description of the query. then right click on the db window and set it to Details. you should now see each query name and the description of it.

hth,
al

 

[Jack Cowley]

And you can invest a few bucks into Rick Fishers 'Find and Replace' program and change names with reckless abandon knowning that all instances of the change will be made throughtout your program. Download a trial copy at www.rickworld.com.

 

[jwindon]

You can also SORT your queries. Change the view in the database window to DETAILS. You can then sort by date.