Hello,
How would I print out a listing of the queries that are in a database?
I would like to have a spreadsheet style listing with the columns of:
Query Name, Description, Modified Date, Created Date.
Thanks.
JBESr 4 1544
jbesr1230 wrote: Hello, How would I print out a listing of the queries that are in a
database? I would like to have a spreadsheet style listing with the columns of: Query Name, Description, Modified Date, Created Date. Thanks. JBESr
Look at the MsysObjects Table (Click on tools> options and show system
objects)
Queries are shown as type "5" in the "type" column. you might see some
other temp queries that begin with the ~ character, but you can filter
those out
Vinni
Thanks. Is there any way to have the Description included in the
table? Or is there a query I could run against the MsysObjects Table?
I don't know what table would have the Descriptions.
JBESr
You could run a query against MsysObjects. You can treat it like any
other table except that it is read only.
I do not know where the descriptions are stored.. anyone else know?
Dim obj As AccessObject, dbs As Object
Set dbs = Application.Cur rentData
' Search for AccessObject objects in AllQueries collection
For Each obj In dbs.AllQueries
'Properties available - may not all be applicable in this context
' obj.Name
' obj.CurrentView
' obj.DateCreated
' obj.DateModifie d
' obj.FullName
' obj.IsLoaded
' obj.Parent
' obj.Properties (Index)
' obj.Type
Next obj
--
/ Sean the Mc /
"Opinions are like flatulence - everyone loves the sound of their own, but
anyone else's usually just stinks !"
-anonymous
"jbesr1230" <jb*******@hotm ail.com> wrote in message
news:11******** *************@g 14g2000cwa.goog legroups.com... Hello, How would I print out a listing of the queries that are in a database? I would like to have a spreadsheet style listing with the columns of: Query Name, Description, Modified Date, Created Date. Thanks. JBESr This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Andy Hall |
last post by:
Hi,
I have just started using MySQL from MSSQL 7. One feature of MSSQL that I
need to replicate is the following:
SELECT product_id, name, description
FROM products
WHERE product_id NOT IN (SELECT product_id FROM sales WHERE customer_id =
10)
|
by: Tristan Miller |
last post by:
Greetings.
I have an XML file listing various information about text glyphs (Unicode
value, HTML entity name, SGML entity name, etc.). All glyphs have a
Unicode value, but not all of them have HTML or SGML entity names.
I want to print out a list of these glyphs, using the HTML entity name if
it is available; otherwise the Unicode value should be printed. The
trouble is that I don't know how I can print only one or the other.
|
by: italiak |
last post by:
Hello everyone-
I have these 500 queries in access. They all do the same thing (append
data from big database to a table) and have similar condition. I was
wondering if there is a way I can create a macro to modify the content
of these queries.
If the modify macro is not possible then I can delete the queries and
try to create a macro which can create queries from scratch.
Any help is appreciated.
|
by: sofakingfree |
last post by:
I could have sworn that Access 95/97 printed the query name as the
header when you print out queries. It doesn't do that with version
2003. Is there some option I'm missing? Any help would be
appreciated.
|
by: Zlatko Matić |
last post by:
Hi everybody!
Recently I was struggling with client/server issues in MS Access/PostgreSQL
combination.
Although Access is intuitive and easy to use desktop database solution, many
problems appear when someone is trying to use it as front-end for real
server database systems such as PostgreSQL or MySQL.
One of these problems is regarding pass-through queries and parameters.
I wanted to have all the code on client, while executing it on...
| |
by: Jeff Magouirk |
last post by:
Dear All,
I would like to list all of the tables in my Access database. But I do not
know how to do this unless I look at all of the tables at once. After I
have a listing is there anywhat to put that into a table?
Thanks in advance.
Jeff Magouirk
|
by: ARC |
last post by:
Hello all,
So I'm knee deep in this import utility program, and am coming up with all
sorts of "gotcha's!".
1st off. On a "Find Duplicates Query", does anyone have a good solution for
renaming the duplicate records? My thinking was to take the results of the
duplicate query, and somehow have it number each line where there is a
duplicate (tried a groups query, but "count" won't work), then do an update
query to change the duplicate to...
|
by: jt2 |
last post by:
Hello Perl Gurus!
I'm quite a perl neophyte so I'm looking for help understanding why print doesn't print correctly. This may be a totally stupid error....
He is my program. What it is doing is parsing a file of comma seperated values and trying to extract the address field every time the clock field transitions from a zero to a one.
#! /usr/bin/perl
|
by: bhavinnaik |
last post by:
Hi I am new to the IT enviro...although i've used QSL query for a while now but on simple or single queries.
Here is the problem...
I've got two queries looking at a set of tables to extract the Costed and Invoiced data from the same database. I've tried to use a JOIN but it keeps failing. I've got multiple fields that needs to be linked.
Any suggestions. I've attached the query to make it easier
Declare @IDateFrom DateTime,
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |