Too many Queries...

[Rich_Lovina]

Help, I have eight pages of queries in my database...
Is there any way to group them, apart from using different forms so they are VB Code queries, specific clients queries, etc.

All I can think of is buidling a form or forms to nest them??

Grateful any ideas

 

[FilipT]

Querys in VB

You can write every Query in visuel basic, and use them that way where you want it (form, raport).
This is a little bit to complex to explain here, just experiment.
I write every db of mine with 0 querys, but make many querys in VB. If you have a query, you can see the SQL code behind it.
Just study that code and copy it in your vb aplication.
(You will have to change a few things here and there)

I learned it that way, and by reading a lot of forums here.

Hope to helped you a little bit with this.

 

[Rich_Lovina]

Thanks I understand that but its not what I'm asking. I am seeking to subject-group queries, so that as an over 50 yr old I don't keep having to sort thru c. 150 to find closely similar queries.

Anyone got a query tree?

 

[Rakier]

I use the properties of the query (right click the query icon for the query you want to set the properties of) to set a description to group them. When you view the info in the access window, you can then sort them by the description rather than the query name. You have to be viewing icons by details. This way, you can create groups in the display window.

HTH
Dan

 

[Rich_Lovina]

tHANKS i HAD USED THAT SOMETIMES TOO, and I suppose if there's no other way its not a bad idea.

 

[Rich_Lovina]

Thanks greatly Pat; I'll have a look at that...still so many aspects of Access that need further advancement. I'm still on Win 98, but figure almost time to move to 2K, as have Acc2K.

Have you looked at my data access page problem under asp, or have any views on it. The 'ineffective' result is sitting on my

www.bureauface.com/Comm_TitlesAcc.htm or

www.bureauface.com/CommTitlesACC1.htm

The query in the access page won't display to the page, and p'raps the website needs a 'watered-down' version of the database??
Hope the book is coming along??

 

[Jerry Stoner]

Dont know if this will help but...
I use my query names to group them. What I mean is of 100 queries say 10 are dealing with a certain module or subject. I name them something descriptive such as qryInv then something like qryInvLoc, qryInvQty, qryTrans then in the description spell out all abreviations. That way all queries that are similar will be together in the database window and in combobox row source dropdown etc.

 

[Rich_Lovina]

Thanks, yeh I'd been doing that too. Just a pity there was not a tree pattern for grouping.