UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> How To Store/manage Queries, Access 2016    
 
   
lex
post Aug 21 2019, 08:45 AM
Post#1



Posts: 752
Joined: 20-October 05



I seem to remember (I believe) Crystal (haven't seen her on much recently, and hope she's OK) posted recommendations on how to store/manage either code or queries. Does anyone remember that? If you have to work with a lot of tables, how do you manage your queries? By memory?

Thanks for your thoughts.

Lex
Go to the top of the page
 
orange999
post Aug 21 2019, 09:12 AM
Post#2



Posts: 1,947
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


Lex,
Not sure if this is what you were thinking, but it is a step closer to info from Crystal.

--------------------
Good luck with your project!
Go to the top of the page
 
lex
post Aug 21 2019, 09:56 AM
Post#3



Posts: 752
Joined: 20-October 05



Thanks orange999, but I have table external to Access (Oracle) that I'm querying and was wondering of a way to organize queries in general. I'm going to try Crystals link, though!
Go to the top of the page
 
GroverParkGeorge
post Aug 21 2019, 10:07 AM
Post#4


UA Admin
Posts: 35,683
Joined: 20-June 02
From: Newcastle, WA


It might help if we had a more detailed idea of what you need to "manage".

Once you create a query and save it, you can use it in a form or report as the recordsource or in a combo or list box as the rowsource.

Once that's done, of course, it's pretty much done, so "managing" such queries probably would be a low-frequency task.

Is there something else you have in mind?

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 
orange999
post Aug 21 2019, 02:18 PM
Post#5



Posts: 1,947
Joined: 10-February 08
From: Ottawa, Ont, Canada; West Palm Beach, FL


This link should lead you to Crystal's Analyzer.
It may have a component for non-Access info--uncertain/untested.

--------------------
Good luck with your project!
Go to the top of the page
 
lex
post Aug 21 2019, 05:50 PM
Post#6



Posts: 752
Joined: 20-October 05



Thanks both George and orange999. Sorry if I wasn't more clear. I guess what I'm looking for is an easy way to learn of all the queries that I have , what tables they use, send what's the business need. Just some initial thoughts and how I might manage large sets of queries.


orange999, I have not looked at the new link that you provided but will tomorrow. Again thank you to both!
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    20th September 2019 - 01:23 PM