Is there a way to group queries together like in folders?  Or is there a way 
to change the font color of the query titles.  WHEn you have so many queries 
to look through it takes so much time finding just the right one. I know that 
choosing the right title name helps but still if we could group them in some 
way or color code them.  Even if we could put a line after so many queries or 
something.

I see the Groups option in my data window.  But how do you use them.  I will 
look into the training center if they have anything on this.  But thanks a 
lot for the lightbulb idea.  

"scubadiver" wrote:

> 
> If you are thinking of something like Explorer then no.
> 
> Insert this SQL into a query. You may be able to do something with this in a 
> form in some way.
> 
> SELECT MsysObjects.Name AS [Query Name]
> FROM MsysObjects
> WHERE (((MsysObjects.Type)=5) AND ((Left$([Name],1))<>"~"))
> ORDER BY MsysObjects.Name;
> 
> Hope it helps
> 
> 
> -- 
> www.ae911truth.org
> 
> 
> 
> "Pat Hughes" wrote:
> 
> > Is there a way to group queries together like in folders?  Or is there a way 
> > to change the font color of the query titles.  WHEn you have so many queries 
> > to look through it takes so much time finding just the right one. I know that 
> > choosing the right title name helps but still if we could group them in some 
> > way or color code them.  Even if we could put a line after so many queries or 
> > something.

Pat,

Right click on the query (unfortunately in 2003 Access will only let you do 
this one object at a time) you want to add to the group.  The select the "Add 
to Group" and either select a group, or select "New Group" and enter a name.  
This doesn't actually move the query to the group, it just adds it.  All of 
your queries will still be under the Queries object.  The nice thing about 
grouping is that you can put any type of object in the group, and you can put 
the object in multiple groups.  So if you want to categorize all of your 
Employee related tables, forms, queries, reports, and code, you can add them 
all to the Employees group.

HTH
Dale

-- 
Email address is not valid.
Please reply to newsgroup only.


"Pat Hughes" wrote:

> I see the Groups option in my data window.  But how do you use them.  I will 
> look into the training center if they have anything on this.  But thanks a 
> lot for the lightbulb idea.  
> 
> "scubadiver" wrote:
> 
> > 
> > If you are thinking of something like Explorer then no.
> > 
> > Insert this SQL into a query. You may be able to do something with this in a 
> > form in some way.
> > 
> > SELECT MsysObjects.Name AS [Query Name]
> > FROM MsysObjects
> > WHERE (((MsysObjects.Type)=5) AND ((Left$([Name],1))<>"~"))
> > ORDER BY MsysObjects.Name;
> > 
> > Hope it helps
> > 
> > 
> > -- 
> > www.ae911truth.org
> > 
> > 
> > 
> > "Pat Hughes" wrote:
> > 
> > > Is there a way to group queries together like in folders?  Or is there a way 
> > > to change the font color of the query titles.  WHEn you have so many queries 
> > > to look through it takes so much time finding just the right one. I know that 
> > > choosing the right title name helps but still if we could group them in some 
> > > way or color code them.  Even if we could put a line after so many queries or 
> > > something.

Wow,
That was excellent.  Thank-you everyone so much.  :)

"Dale Fye" wrote:

> Pat,
> 
> Right click on the query (unfortunately in 2003 Access will only let you do 
> this one object at a time) you want to add to the group.  The select the "Add 
> to Group" and either select a group, or select "New Group" and enter a name.  
> This doesn't actually move the query to the group, it just adds it.  All of 
> your queries will still be under the Queries object.  The nice thing about 
> grouping is that you can put any type of object in the group, and you can put 
> the object in multiple groups.  So if you want to categorize all of your 
> Employee related tables, forms, queries, reports, and code, you can add them 
> all to the Employees group.
> 
> HTH
> Dale
> 
> -- 
> Email address is not valid.
> Please reply to newsgroup only.
> 
> 
> "Pat Hughes" wrote:
> 
> > I see the Groups option in my data window.  But how do you use them.  I will 
> > look into the training center if they have anything on this.  But thanks a 
> > lot for the lightbulb idea.  
> > 
> > "scubadiver" wrote:
> > 
> > > 
> > > If you are thinking of something like Explorer then no.
> > > 
> > > Insert this SQL into a query. You may be able to do something with this in a 
> > > form in some way.
> > > 
> > > SELECT MsysObjects.Name AS [Query Name]
> > > FROM MsysObjects
> > > WHERE (((MsysObjects.Type)=5) AND ((Left$([Name],1))<>"~"))
> > > ORDER BY MsysObjects.Name;
> > > 
> > > Hope it helps
> > > 
> > > 
> > > -- 
> > > www.ae911truth.org
> > > 
> > > 
> > > 
> > > "Pat Hughes" wrote:
> > > 
> > > > Is there a way to group queries together like in folders?  Or is there a way 
> > > > to change the font color of the query titles.  WHEn you have so many queries 
> > > > to look through it takes so much time finding just the right one. I know that 
> > > > choosing the right title name helps but still if we could group them in some 
> > > > way or color code them.  Even if we could put a line after so many queries or 
> > > > something.