If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I print the details view
When viewing the database objects screen, I can click on view/details and
see a list of my queries, their description, creation date ... etc. How can I print the inormation shown in this view? I have been using Print-screen but that gives me a bitmap. I want a real printout or list to export. |
#2
|
|||
|
|||
Try the Menu Tools /Analyze / Documenter ...
-- HTH Van T. Dinh MVP (Access) "David" wrote in message . net... When viewing the database objects screen, I can click on view/details and see a list of my queries, their description, creation date ... etc. How can I print the inormation shown in this view? I have been using Print-screen but that gives me a bitmap. I want a real printout or list to export. |
#3
|
|||
|
|||
Tried that, gives way more than I want right now.
I just neet a printout that looks like the details view. "Van T. Dinh" wrote in message ... Try the Menu Tools /Analyze / Documenter ... -- HTH Van T. Dinh MVP (Access) "David" wrote in message . net... When viewing the database objects screen, I can click on view/details and see a list of my queries, their description, creation date ... etc. How can I print the inormation shown in this view? I have been using Print-screen but that gives me a bitmap. I want a real printout or list to export. |
#4
|
|||
|
|||
There is an "Options..." in the Dialog. Select only what you need.
-- HTH Van T. Dinh MVP (Access) "David" wrote in message . net... Tried that, gives way more than I want right now. I just neet a printout that looks like the details view. |
#5
|
|||
|
|||
"David" wrote: Tried that, gives way more than I want right now. I just neet a printout that looks like the details view. "Van T. Dinh" wrote in message ... Try the Menu Tools /Analyze / Documenter ... -- HTH Van T. Dinh MVP (Access) "David" wrote in message . net... When viewing the database objects screen, I can click on view/details and see a list of my queries, their description, creation date ... etc. How can I print the inormation shown in this view? I have been using Print-screen but that gives me a bitmap. I want a real printout or list to export. Hi David, In addition to Van's excellent advice, these are available through the QueryDef collection. For example, start a new Module. Save it as "modUtilities" Go into Tools/References and make sure DAO library is selected. Copy and paste the following code into the module. Click on "Save" Run Debug/Compile... to make sure code okay (there may be word wrapping). Then, in Immediate Window type in ?flistqueries("C:\queries.txt") and hit Enter key. This will save "everything you wanted to know" about *all* queries in your db in C:\queries.txt. Queries beginning with a "~sq_c" come from forms (and controls) or reports. You could add some code to ignore these. You could also comment out all code lines for values you don't want to see in text file. You also could create a table to hold these values and, instead of writing to text file, save them to the table. Note: property "Updateable" is *not* the same as "This query is updateable, i.e, can open it and edit field values." Good luck, Gary Walter '***start code*** Option Explicit Public Function fListQueries(pPath As String) As Boolean On Error GoTo Err_fListQueries Dim dbs As DAO.Database, qdf As DAO.QueryDef Dim param As DAO.Parameter Dim hfile As Long Const conPropNotFound As Integer = 3270 'First get a new file handle hfile = FreeFile Open pPath For Output As hfile Set dbs = CurrentDb ' Enumerate through QueryDefs collection. For Each qdf In dbs.QueryDefs With qdf Print #hfile, "--------------------" Print #hfile, "Name: " & .Name Print #hfile, "Description: " & .Properties("Description") Print #hfile, "Modified: " & .LastUpdated Print #hfile, "Created: " & .DateCreated Select Case .Type Case dbQAction Print #hfile, "Type: Action" Case dbQAppend Print #hfile, "Type: Append" Case dbQCompound Print #hfile, "Type: Compound" Case dbQCrosstab Print #hfile, "Type: Crosstab" Case dbQDDL Print #hfile, "Type: DDL" Case dbQDelete Print #hfile, "Type: Delete" Case dbQMakeTable Print #hfile, "Type: MakeTable" Case dbQProcedure Print #hfile, "Type: Procedure" Case dbQSelect Print #hfile, "Type: Select" Case dbQSetOperation Print #hfile, "Type: Set Operation" Case dbQSPTBulk Print #hfile, "Type: SPT Bulk" Case dbQSQLPassThrough Print #hfile, "Type: PassThrough" Case dbQUpdate Print #hfile, "Type: Update" Case Else Print #hfile, "Type: Unknown" End Select Print #hfile, "SQL: " & vbCrLf & vbCrLf & .SQL For Each param In .Parameters Print #hfile, "Parameter Name: " & param.Name Select Case param.Type Case dbBigInt Print #hfile, "Parameter Type: Big Integer" Case dbBinary Print #hfile, "Parameter Type: Binary" Case dbBoolean Print #hfile, "Parameter Type: Boolean" Case dbByte Print #hfile, "Parameter Type: Byte" Case dbChar Print #hfile, "Parameter Type: Char" Case dbCurrency Print #hfile, "Parameter Type: Currency" Case dbDate Print #hfile, "Parameter Type: Date/Time" Case dbDecimal Print #hfile, "Parameter Type: Decimal" Case dbDouble Print #hfile, "Parameter Type: Double" Case dbFloat Print #hfile, "Parameter Type: Float" Case dbGUID Print #hfile, "Parameter Type: GUID" Case dbInteger Print #hfile, "Parameter Type: Integer" Case dbLong Print #hfile, "Parameter Type: Long" Case dbLongBinary Print #hfile, "Parameter Type: Long Binary (OLE Object)" Case dbMemo Print #hfile, "Parameter Type: Memo" Case dbNumeric Print #hfile, "Parameter Type: Numeric" Case dbSingle Print #hfile, "Parameter Type: Single" Case dbText Print #hfile, "Parameter Type: Text" Case dbTime Print #hfile, "Parameter Type: Time" Case dbTimeStamp Print #hfile, "Parameter Type: Time Stamp" Case dbVarBinary Print #hfile, "Parameter Type: VarBinary" Case Else Print #hfile, "Parameter Type: Unknown" End Select Next param Print #hfile, "Updateable: " & .Updatable Print #hfile, "Connect: " & .Connect Print #hfile, "Returns Records: " & .ReturnsRecords End With NewQ: Next qdf Close hfile fListQueries = True Exit_fListQueries: Set qdf = Nothing Set dbs = Nothing Reset Exit Function Err_fListQueries: If Err = conPropNotFound Then Print #hfile, "Description:" Resume Next Else If Err = 3078 Or Err = 91 Then Print #hfile, "**This query has problems: " & vbCrLf & Err.Description Resume NewQ Else fListQueries = False MsgBox "Error Number: " & Err.Number & " " & Err.Description Resume Exit_fListQueries End If End If End Function '***end code*** |
#6
|
|||
|
|||
This works great. I can adapt.
Thanks "Gary Walter" wrote in message ... "David" wrote: Tried that, gives way more than I want right now. I just neet a printout that looks like the details view. "Van T. Dinh" wrote in message ... Try the Menu Tools /Analyze / Documenter ... -- HTH Van T. Dinh MVP (Access) "David" wrote in message . net... When viewing the database objects screen, I can click on view/details and see a list of my queries, their description, creation date ... etc. How can I print the inormation shown in this view? I have been using Print-screen but that gives me a bitmap. I want a real printout or list to export. Hi David, In addition to Van's excellent advice, these are available through the QueryDef collection. For example, start a new Module. Save it as "modUtilities" Go into Tools/References and make sure DAO library is selected. Copy and paste the following code into the module. Click on "Save" Run Debug/Compile... to make sure code okay (there may be word wrapping). Then, in Immediate Window type in ?flistqueries("C:\queries.txt") and hit Enter key. This will save "everything you wanted to know" about *all* queries in your db in C:\queries.txt. Queries beginning with a "~sq_c" come from forms (and controls) or reports. You could add some code to ignore these. You could also comment out all code lines for values you don't want to see in text file. You also could create a table to hold these values and, instead of writing to text file, save them to the table. Note: property "Updateable" is *not* the same as "This query is updateable, i.e, can open it and edit field values." Good luck, Gary Walter '***start code*** Option Explicit Public Function fListQueries(pPath As String) As Boolean On Error GoTo Err_fListQueries Dim dbs As DAO.Database, qdf As DAO.QueryDef Dim param As DAO.Parameter Dim hfile As Long Const conPropNotFound As Integer = 3270 'First get a new file handle hfile = FreeFile Open pPath For Output As hfile Set dbs = CurrentDb ' Enumerate through QueryDefs collection. For Each qdf In dbs.QueryDefs With qdf Print #hfile, "--------------------" Print #hfile, "Name: " & .Name Print #hfile, "Description: " & .Properties("Description") Print #hfile, "Modified: " & .LastUpdated Print #hfile, "Created: " & .DateCreated Select Case .Type Case dbQAction Print #hfile, "Type: Action" Case dbQAppend Print #hfile, "Type: Append" Case dbQCompound Print #hfile, "Type: Compound" Case dbQCrosstab Print #hfile, "Type: Crosstab" Case dbQDDL Print #hfile, "Type: DDL" Case dbQDelete Print #hfile, "Type: Delete" Case dbQMakeTable Print #hfile, "Type: MakeTable" Case dbQProcedure Print #hfile, "Type: Procedure" Case dbQSelect Print #hfile, "Type: Select" Case dbQSetOperation Print #hfile, "Type: Set Operation" Case dbQSPTBulk Print #hfile, "Type: SPT Bulk" Case dbQSQLPassThrough Print #hfile, "Type: PassThrough" Case dbQUpdate Print #hfile, "Type: Update" Case Else Print #hfile, "Type: Unknown" End Select Print #hfile, "SQL: " & vbCrLf & vbCrLf & .SQL For Each param In .Parameters Print #hfile, "Parameter Name: " & param.Name Select Case param.Type Case dbBigInt Print #hfile, "Parameter Type: Big Integer" Case dbBinary Print #hfile, "Parameter Type: Binary" Case dbBoolean Print #hfile, "Parameter Type: Boolean" Case dbByte Print #hfile, "Parameter Type: Byte" Case dbChar Print #hfile, "Parameter Type: Char" Case dbCurrency Print #hfile, "Parameter Type: Currency" Case dbDate Print #hfile, "Parameter Type: Date/Time" Case dbDecimal Print #hfile, "Parameter Type: Decimal" Case dbDouble Print #hfile, "Parameter Type: Double" Case dbFloat Print #hfile, "Parameter Type: Float" Case dbGUID Print #hfile, "Parameter Type: GUID" Case dbInteger Print #hfile, "Parameter Type: Integer" Case dbLong Print #hfile, "Parameter Type: Long" Case dbLongBinary Print #hfile, "Parameter Type: Long Binary (OLE Object)" Case dbMemo Print #hfile, "Parameter Type: Memo" Case dbNumeric Print #hfile, "Parameter Type: Numeric" Case dbSingle Print #hfile, "Parameter Type: Single" Case dbText Print #hfile, "Parameter Type: Text" Case dbTime Print #hfile, "Parameter Type: Time" Case dbTimeStamp Print #hfile, "Parameter Type: Time Stamp" Case dbVarBinary Print #hfile, "Parameter Type: VarBinary" Case Else Print #hfile, "Parameter Type: Unknown" End Select Next param Print #hfile, "Updateable: " & .Updatable Print #hfile, "Connect: " & .Connect Print #hfile, "Returns Records: " & .ReturnsRecords End With NewQ: Next qdf Close hfile fListQueries = True Exit_fListQueries: Set qdf = Nothing Set dbs = Nothing Reset Exit Function Err_fListQueries: If Err = conPropNotFound Then Print #hfile, "Description:" Resume Next Else If Err = 3078 Or Err = 91 Then Print #hfile, "**This query has problems: " & vbCrLf & Err.Description Resume NewQ Else fListQueries = False MsgBox "Error Number: " & Err.Number & " " & Err.Description Resume Exit_fListQueries End If End If End Function '***end code*** |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I am unable to view & print a complete doc. for labels. Only par. | Teereecee | General Discussion | 1 | August 27th, 2004 12:14 PM |
Outlook 2003 View Settings MADNESS | laura | General Discussion | 7 | August 20th, 2004 05:17 PM |
Page prints differently than shown in Print Preview | Suzanne S. Barnhill | Page Layout | 0 | July 22nd, 2004 03:42 PM |
Print Preview looks different than Normal View? | Lori | General Discussion | 2 | June 15th, 2004 06:48 PM |
Margin markers: how to remove in print layout view? | Page Layout | 2 | May 6th, 2004 01:11 PM |