Hi there,
I have a database with what seems like a trillion (ok, 50) interlinked
queries.
I want to print out, from a code subroutine, the SQL query definitions.
Is this even possible? I've looked and looked and am not getting
anywhere.
Rob. 5 1258
This won't format very well, but it demonstrates what you asked for:
Public Function ShowAllQueries()
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Set db = CurrentDb()
For Each qdf In db.QueryDefs
Debug.Print qdf.Name, qdf.SQL
Next
End Function
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"dkintheuk" <rm*******@firenet.uk.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com... I have a database with what seems like a trillion (ok, 50) interlinked queries.
I want to print out, from a code subroutine, the SQL query definitions.
Is this even possible? I've looked and looked and am not getting anywhere.
Rob.
Yet again i am extremely grateful for the help i get on this board. I
can handle formatting and this is yet another of those ones i should
have sussed out for myself.
Many thanks,
Rob.
If you don't need it to be ran from a code subroutine then it is
simpler to use the Documenter tool from the tools menu (Tools - Analyze
- Documenter). This tool will give you the option to print the SQL,
query properties, parameters, relationships, indexes, and fields
properties for all or selected objects.
One of the reports that my CSD Tools add-in creates will do
exactly this. It will print out the SQL of each query and will
save several trees over the built-in Documentor.
You can find the add-in here on my site: http://home.bendbroadband.com/conrad.../csdtools.html
Yes, it is free, but you must agree to my terms.
;-)
--
Jeff Conrad
Access Junkie http://home.bendbroadband.com/conrad...essjunkie.html http://www.access.qbuilt.com/html/articles.html
"dkintheuk" wrote in message:
news:11**********************@g43g2000cwa.googlegr oups.com... Hi there,
I have a database with what seems like a trillion (ok, 50) interlinked queries.
I want to print out, from a code subroutine, the SQL query definitions.
Is this even possible? I've looked and looked and am not getting anywhere.
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
On 27 Jun 2005 12:14:54 -0700, "jv" <ju***********@hotmail.comwrote:
>If you don't need it to be ran from a code subroutine then it is simpler to use the Documenter tool from the tools menu (Tools - Analyze - Documenter). This tool will give you the option to print the SQL, query properties, parameters, relationships, indexes, and fields properties for all or selected objects.
My experience has been that Documenter wastes a lot of paper. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Kevin Thorpe |
last post by:
I think I know the answer to this, but suggestions welcomed.
I have to store lots of information. An electricity reading every half
hour for hundreds of meters for several years.
The ways I...
|
by: Michele Locati |
last post by:
Hi to everybody
I've a little problem that I can't solve. An hour of Google search
didn't help.
I should set dinamically via JavaScript the height of an object when I
print the HTML page.
...
|
by: yossi.kreinin |
last post by:
Hi!
When are multiple definitions of global variables with the same name
considered legal in C, and how is it different from C++? It appears
that in terms of assembly language, some C...
|
by: Newbie |
last post by:
In searching the web for a method to print out macro definitions, I
found this code from Allen Browne to print out query definitions. Is
there a similar way to print out macros?
Public Function...
|
by: katysei |
last post by:
I have to print several large structs to print the screen.
I was wondering if thers a tool to do so automaticly
struct A
{
int i;
char * s;
}
|
by: zouyongbin |
last post by:
Stanley B Lippman in his "C++ Primer" that a definition like this
should not appear in a header file:
int ix;
The inclusion of any of these definitions in two or more files of the
same...
|
by: td0g03 |
last post by:
Hello, I just have a few questions. The first one be how would you print a pattern. I could use the if else, but I remember my teacher talking about something like
for(i=1;i<=size;i)
...
|
by: =?Utf-8?B?QnJhc3NpY2FOaWdyYQ==?= |
last post by:
Greetings,
I have a web application that prints a form using PrintDocument on the
server. Currently it is set up to print to the default printer (on the
server).
My users would like to be...
|
by: totomalas |
last post by:
I have developed a report in Access 2007 that runs on three queries, each promting an input from the user...this report is used for a meeting and it should be printed nine times...what I do now is...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |