Grouping query titles or color coding them

[Guest]

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.

 

[Guest]

That would be nice, but there are no such facilities available. About the
only thing you can do is create a naming convention that will group them
together when sorted.

 

[Guest]

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

 

[Guest]

Doh!
I just remembers. Groups!
In the database window on the lower left, will be Groups. A group named
Favorites is the default; however, you can establish groups there. That is
sort of like in folders.

Sorry I forgot about them. I don't use them, so I didn't think of them right
off.

 

[Guest]

Learn something new every day, really new that is!

 

[Guest]

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.

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

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.

 

[Guest]

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.

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.

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

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.

 

[Guest]

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

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.

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.

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



:

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.