473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Documenter include Query Property-Description (2003)

GuinessFan
In the query design, choose: View | Properties. There is a field 'Description'. I've run the documenter and listed query def items in DBO, but this description is not one of the items.

Does anyone know a way to use this in any sort of printout or document? I can find everything else using code from another post.
Jun 23 '08 #1
3 3340
ADezii
8,834 Expert 8TB
You can access the Description Property of a QueryDef Object in the following manner:
Expand|Select|Wrap|Line Numbers
  1. CurrentDb.QueryDefs("<Your Query Name>").Properties("Description").Value
Jun 23 '08 #2
That worked; thanks. Don't know why I was looping through all for the DAO.Property items for each querydef and the 'Description" wouldn't show up.
Jun 25 '08 #3
ADezii
8,834 Expert 8TB
That worked; thanks. Don't know why I was looping through all for the DAO.Property items for each querydef and the 'Description" wouldn't show up.
If you iterate through the Properties of a QueryDef Object, it will appear as illustrated in the code below, which lists the Properties of the Invoices Query of the Northwind Sample Database:
Expand|Select|Wrap|Line Numbers
  1. Dim qdf As DAO.QueryDef
  2. Dim prp As DAO.Property
  3. Dim intCounter As Integer
  4.  
  5. Set qdf = CurrentDb.QueryDefs("Invoices")
  6.  
  7. For Each prp In qdf.Properties
  8.   intCounter = intCounter + 1
  9.   Debug.Print "Query Property Number " & Format$(intCounter, "00") & _
  10.             " ==> " & prp.Name
  11. Next
  12.  
OUTPUT:
Expand|Select|Wrap|Line Numbers
  1. 'Notice Property #17
  2. Query Property Number 01 ==> Name
  3. Query Property Number 02 ==> DateCreated
  4. Query Property Number 03 ==> LastUpdated
  5. Query Property Number 04 ==> Type
  6. Query Property Number 05 ==> SQL
  7. Query Property Number 06 ==> Updatable
  8. Query Property Number 07 ==> Connect
  9. Query Property Number 08 ==> ReturnsRecords
  10. Query Property Number 09 ==> ODBCTimeout
  11. Query Property Number 10 ==> RecordsAffected
  12. Query Property Number 11 ==> MaxRecords
  13. Query Property Number 12 ==> StillExecuting
  14. Query Property Number 13 ==> CacheSize
  15. Query Property Number 14 ==> Prepare
  16. Query Property Number 15 ==> RecordLocks
  17. Query Property Number 16 ==> FilterOn
  18. Query Property Number 17 ==> Description
  19. Query Property Number 18 ==> OrderOn
  20. Query Property Number 19 ==> DatasheetGridlinesBehavior
  21. Query Property Number 20 ==> Filter
  22. Query Property Number 21 ==> OrderBy
  23. Query Property Number 22 ==> OrderByOn
  24. Query Property Number 23 ==> RecordsetType
  25. Query Property Number 24 ==> Orientation
  26. Query Property Number 25 ==> DOL
  27. Query Property Number 26 ==> GUID
Jun 26 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: charlie | last post by:
I was wondering if sql server 2000 has an auto documenter utility that can dump information about a database into a word, excel, or text file. I would not need anything to complicated just table,...
1
by: NOSPAM | last post by:
Hi, I am looking for an easy way to get all of the properties from a SQL 2000 database much like the documenter does in MS Access. Any ideas?
2
by: Chuck | last post by:
Is there any way to export the report that is generated when using the "Documenter" of Access XP to another file such as Word, PDF, etc. Thanks for any help, Chuck
15
by: Richard Hollenbeck | last post by:
I tried to ask this question before on the 14th of January but I never got a reply. I'm still struggling with the problem. I'll try to rephrase the question: I have a crosstab query with rows...
2
by: Lauren Quantrell | last post by:
The documenter function in MDBs doesn't appear in Access 2000 ADP's. Is there way to do this short of exporting all of my forms, reports and modules to an MDB and then running the documenter (which...
2
by: renequimoyog | last post by:
Hello every one I found a thread July 2005 on the TITLE but cant donwload the file found on the link. I was task to document a 40 table ER diagragm, but cant possible do report fo 40 tables for...
0
by: Carl Vondrick | last post by:
Hi everybody, So, I've decided that I need to find some formal PHP documenter program because I'm tired of just writing things down in text documents or sending emails to myself. I have found...
11
by: Petulant | last post by:
Hello~ Help Please~ I am new to Access, so am a little behind the learning curve. I have a query that I have been running for a while that has worked fine and now (with no changes) is throwing up...
1
by: ningjun.wang | last post by:
I need to include to static html files in my asp.net page. The order of include depend on query string. Here is the pseudo code mypage.aspx: <% string mode = Request; if (mode == "A") {...
1
by: anoldman | last post by:
While troubleshooting a mdb that won't convert into a linked(backend) set, I have discovered that the primary key column of the primary table shows a RowSource with type Table/Query. This is only...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.