General :: Access Object Property Description

Dec 14, 2012

I'm working on a query that lists all the queries in an Access database, and I would like the query to show the object description which is displayed when you right-click an object and display the object's properties. For queries, this is a text box just below the query name in the properties window.

So far, all I have is:

Code:
SELECT ID, Name FROM mSysObjects;

I would like to have something like:

Code:
SELECT ID, Name, Description FROM mSysObjects;

View Replies


ADVERTISEMENT

Fetching A Reports Description Property

Jul 5, 2005

I have list box of reports in a form and when selected i want to write the reports description propterty to a textbox.

I modified an example i found posted someplace (can't recall where) and it worked great - just like this (see below).

Then I put it into another database (exact same tables, form and and queries) and if there is a description in the query property it will always give me the error "Type mismatch".

Why?
The only difference I can see is that the working example db had the following References selected:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Oject Library
... in that order.

My database where it is not working has selected:
Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft DAO 3.6 Object Library

Is there a better way to fetch this property?
Or is there a setting I need to change - keeping in mind that changing these settings may cause the rest of my db to fail now...

Thanks A lot for any help you can give.




Function ReportDescription(ReportName As Variant) As String
On Error GoTo Err_ReportDescription
Dim db As Database
Dim con As Container
Dim doc As Document
Dim prp As Property
Set db = CurrentDb()
Set con = db.Containers("Reports")
Set doc = con.Documents(ReportName)
Set prp = doc.Properties("description")

ReportDescription = prp.Value
Exit_ReportDescription:
Exit Function

Err_ReportDescription:
If Err.Number = 3270 Then
ReportDescription = "There is no description for this Report"
Resume Exit_ReportDescription
Else
MsgBox Err.Description
Resume Exit_ReportDescription
End If
End Function

Private Sub lstReports_Click()
Me!txtReportDesc = ReportDescription("rpt" & Me!lstReports)
'Me!txtReportDesc = ReportDescription(Me!lstReports)
End Sub

View 1 Replies View Related

Tables :: Adding Description To A Field - Property Value Is Too Large Error Message

Oct 18, 2012

I keep getting the "Property Value is too large" when I add a description to a field in an existing table.

The same error was resolved on another table by cutting four fields then saving then pasting them back into the table and saving again.

I tried importing the entire DB into a new file, this I still get the error message "Property Value is too large" ...

View 1 Replies View Related

General :: Access 2013 - Sort Database Window By Description?

Oct 10, 2013

Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances.

Most functionality appears to be working ok...

Many of my database objects, especially queries, were given meaningful descriptions.

For example, a number of queries might have been described as "Accounts Data Validation".

When I wanted to run validation of the Accounts data, I would simply sort the database queries window by description, then scroll to the relevant section and run all of the tagged queries in turn.

However, having migrated to Access 2013, although the descriptions are still shown, I can no longer sort by them !

Medium term, I could probably assign different database objects to "Groups", but we are talking hundreds, perhaps even thousands of different objects and that would be a laborious and extremely tedious process.

Any way of sorting the database window by description in Access 2013 ?

View 3 Replies View Related

Object Does Not Support This Property Or Method.

Apr 13, 2007

Hi,

I want to disable a button right after click it. Because I could not disable a control that has got the focus, i tried to shift the focus to another control; however, all controls that I tried to shift the focus to don't support the method (SetFocus = true).

I want to do this on a subform's control, but I keep getting this error:
Object does not support this property or method.

Any susggestions will be very much appreciated.

B:)

View 3 Replies View Related

Object Doesnt Support This Property....

Dec 1, 2005

This error appears when a preview or print button is used. The form has been opened with this.....

DoCmd.OpenForm stDocName, , , , acFormAdd, acWindowNormal

But when I try to preview it gets the error.......
"Object doesnt support this property........."

Same error occurs when the form is opened with.....
DoCmd.OpenForm stDocName, , , , acFormReadOnly, acWindowNormal, stLinkCriteria

The preview button is this.........

Private Sub cmdPreviewRptWO_Click()
On Error GoTo Err_cmdPreviewRptWO_Click

Dim stDocName As String
stDocName = "rptWorkOrderCurrent"

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport stDocName, acPreview

Exit_cmdPreviewRptWO_Click:
Exit Sub


The really strange thing is I have 2 forms both coding the same..... One doesnt give the error!!

I think the error occurs when it is trying to save before previewing...But it has to save to view the report.

Anyone have the answer?? :confused:

View 8 Replies View Related

Object Doesn't Support This Property Or Method

Feb 27, 2006

Using the following function to update records and receive this error: "Object doesn't support this property or method"

Code:Public Function edit_users()On Error GoTo user_errorDim StrSQL As String, strUser As String, uid As String, section As String, chkAdmin As IntegerDim fname As String, lname As Stringuid = Forms![ctrlpanel]![subEditUsers].Form!cmbUseridsection = Forms![ctrlpanel]![subEditUsers].Form!cmbSectionfname = Forms![ctrlpanel]![subEditUsers].Form!txtFnamelname = Forms![ctrlpanel]![subEditUsers].Form!txtLnamechkAdmin = Forms![ctrlpanel]![subEditUsers].Forms!chkAdminIf uid = "" Or section = "" Or fname = "" Or lname = "" ThenMsgBox "You have left one or more fields blank.", vbOKOnly, "Edit User Error"GoTo user_exitEnd IfStrSQL = "UPDATE users SET [section] = '" & section & "', [fname] = '" & fname & "', [lname] = '" & lname & "', admin = '" & chkAdmin & "' WHERE [userid] = '" & uid & "'"Call get_rs(StrSQL)user_exit:Exit Functionuser_error: MsgBox Err.DescriptionGoTo user_exit:End Function

Here is the connection get_rs:

Code:Public Function get_rs(StrSQL)Dim temp_rs As New ADODB.RecordsetSet temp_rs = New ADODB.Recordsettemp_rs.LockType = adLockOptimisticWith temp_rs .ActiveConnection = open_conn() .Open (StrSQL)End WithSet get_rs = temp_rsSet temp_rs = NothingEnd Function

Thanks

View 3 Replies View Related

General :: ACCESS Object References

Mar 3, 2014

I am cleaning up a database that has been around for some time and I wish to be able to check for references within REPORTS/VBA Module code/ Form Designs etc. anywhere there is likely to be a reference to either an Access TABLE or QUERY.... I know there is the 'Object Dependencies' function within Access that will go some way to telling you what relies on what, but this is simply not comprehensive enough in that it doesn't go down to Form design level where further references can hide...

Countless times I have checked and subsequently deleted tables that I considered redundant... only to find later on there was some SQL Source reference to a table or query buried in the design of a form that I had overlooked....

Any way to definitively check and to ensure that all traces of a specific table or query are accounted for...?

View 2 Replies View Related

General :: Combo Box Not Return Description To Table

Feb 20, 2015

My combo boxes are not returning the actual combo box values back to my table, instead in the table it is displaying the combo box data list number i.e 1,2,3,1,5,1 etc where it should be displaying a property address.

View 2 Replies View Related

Tables :: Using Access Table Description Attribute

Feb 18, 2013

I am using Access 2010. I have many tables that are downloaded from SAP into Access.

Within each table structure are the following standard Access attributes: Field Name Data Type Description

When I create a query I add the Field Name from the table nothing earth shattering here. But, in addition or instead of Field Name, I want to use the Description attribute. Mostly because the SAP field names are acromyms in German and are useless to the untrained eye. Please see attachment as an example.

Is there a way either using VBA or some special SQL language in any query I write to show me the Description instead of or in addition to the Field Name?

View 1 Replies View Related

Modules & VBA :: How To Access Description Inside Form Error Event

Jul 31, 2013

I'm trying to extract information from Err.Description within a form's Error event. Alas, Err.Description does not seem to be available from there.I have a form that normally displays in DataSheet view. If a trigger on the Oracle back-end raises an error, I want my Access app to be able to parse out Err.Description and deliver a more user-friendly message than ODBC's message. I want to get the info about the message from the error coming back from Oracle, not by matching up error codes.

If I change the form to Single-Form view and put a Save button on it, I can capture Err.Description in the command button's Clicked() event, and then parse out what I need.So if I must display this form in Datasheet view, where can I trap the ODBC error and display my user-friendly message?

View 5 Replies View Related

General :: Property Sheet Locked?

Jan 22, 2014

I am unable to use property sheet in access. Its viewable but no changes are allowed.

View 1 Replies View Related

General :: Can't Change Required Field Property

Jul 16, 2013

I am trying to change a field to be required. I know where it is...

(Navigation Pane > Design View > Select field I want required > Properties Pane > General Tab > set Required property to Yes)

But I don't see that General Tab at the bottom of my page.

The closest thing I have to properties is on the right-hand side. It opens when I right-click, then hit Properties. It displays...

Format | Data | Event | Other | All... but that's it...

[URL]

View 4 Replies View Related

General :: Control Source In Property Sheet

Aug 3, 2012

My question is in Access 2010 I am currently in the property sheet at a combo list i just added to a form to be more precise with the data the user will look for. My question is I know I have to be in Control source in order for the combo box to select the data that I entered from the table. When i click the arrow the drop list is empty and then when I click the elipses (three dots) it takes me into expression builder, so i am confused on what I should do to select the field I want the combo box to focus on.

View 2 Replies View Related

General :: Add Existing Fields And Property Sheet - Buttons Not Working

Sep 1, 2014

I have a problem with two buttons, add existing fields and property sheet

When i click them they do nothing at all, so i cannot do what i need to do?

View 9 Replies View Related

General :: How To Update Yes / No Object

Aug 8, 2012

I'm relatively new to access. I probably use about one tenth of one percent of what it has to offer because I have trouble understanding it at this time. I need to know how to update a yes/no object.

View 2 Replies View Related

General :: Database Or Object Is Read Only?

Aug 25, 2012

Been using XP all this time, just got a new computer with Windows 7. Still using old Access 2000, not my call to update as this is the decision of the guy who owns the database.

Anyways, I opened Access for the first time, just a blank database so I can set up the user account. When I go to Tools > Security > User and Group Accounts and try to assign a password to Admin, I get the error message that it cannot update because the database is read only.

Where did this come from? I have never seen this message before, and the person who owns the database has a couple computers with Windows 7 that I have set this up on and did not run into this issue.

I realize that there can be some compatibility issues with Windows 7 and Access 2000 but it has worked on other Windows 7 computers, and not using the virtual XP mode.

View 13 Replies View Related

General :: Emailing With Send Object

Nov 23, 2012

I am using a command button to email an invoice to a customer using the sendobject function, whilst this almost works correctly it is adding an additional mailto:address along with the correct email address.

Example: CorrectEmailAddress and then#mailto:CorrectEmailAddress

The code I am using is:

On Error Resume Next
Dim Cusemail As String
Cusemail = Nz(DLookup("Email", "invoiceemailQ", "orderID=" & OrderID), "")
If Cusemail = "" Then
MsgBox "No email Address"
Exit Sub

[code]....

View 6 Replies View Related

General :: How To Get Size Of Each Object In Database

Aug 11, 2015

I have adopted someone elses database. It is a front end with about 100 linked tables/forms/reports/modules. The problem is that the database is really large. I would think by looking at the objects that it should be around 5mb tops, however after compacting it is still 63mb.

Is there a way (vba or otherwise) to look at each object and get its size in KB?

Once I can figure out which object is taking up too much space I can work on making them smaller.

View 6 Replies View Related

General :: Declare Reference As Object?

Sep 4, 2012

Is it possible to declare a reference as an object, this way we could avoid our issues with broken references? I would just try it, but it seems like there is a quite a lot of testing it would require.

View 11 Replies View Related

Access Query Property From Form?

Jun 9, 2005

I have a form that is to be used to browse through parts using various filters (like category, snippets of part number or description) to find particular components, and then draw information from those components onto the form to be used for other things.

Queries I seem to understand - I've made a query which I've embedded on the form which happily filters the parts using the combo-boxes and text boxes on the form.

What I can't figure out is how to access the information IN the query! There doesn't seem to be a "double-click" event, or a "highlighted row" property, that I can use to tell the query WHICH of the parts returned after filtering is the particular one Im interested in, to draw information from the row.

What I want is a command button that, once the desired part is selected, "sucks" the data out of the query into text boxes on the form.

I've tried something like -


Private Sub cmdSelect_Click()

Me.txtSelectedPartID = Me.qryPartFinder.PartID

End Sub

...but it tells me that the method or data member is not found. When I'm typing the code the auto-complete thingy happily finds "qryPartFinder" when I type "me", but none of the available properties in the list for qryPartFinder seem to be what I need.

How DO you access the data in a highlighted (and/or somehow selected) row?

TIA.

Col.

View 2 Replies View Related

General :: Save PDF Report Into A Table (OLE Object)

Jul 6, 2013

How could I save a PDF report into a table (OLE object).

I want to click on a button, then that button should save the file into a table which formatted as OLE object ??

View 3 Replies View Related

General :: Object Class Does Not Support Set Of Events

Aug 14, 2015

I have Access 2007 database.

I and trying to link to Outlook 2007 using the "External Data/More/Outlook Folder option and keep getting the "Object Class does not Support the Set of Events" error message.

I can link to a DBF and Paradox file without any problems.

I am running Office 2007 Professional and Access 2007 and Windows 10.

I have also done the following:

1. Removed Office 365
2. Decompiled the Access VBA code and corrected any issues
3. Compacted/Repaired the database

I have attached a screen shot of the references that I have selected.

This is a new setup as I recently purchased a new PC and Windows environment. I still have the old PC running Windows XP with the same configuration and it also experiences exactly the same error message.

View 6 Replies View Related

General :: Cannot Update - Database Or Object Is Read-only

Aug 24, 2013

I have 2 tables and from them I do a query called "Query_Dates". There, I created 4 calculated fields which compares fields of the two tables previously mentioned.

What I am trying to do is everytime the calculated fields are equal to "Diff", gets the value from the second table (ADHOC) and and puts it in the 1st table (Master_Table). In total there are 4 fields I would change depending on other 4 fields called (CheckRR, CheckQual, CheckProd, CheckCap).

The problem is that it gives me an error 3027, object is read-only.

Below, you can find the code.

Private Sub Comando27_Click()
Dim rst As DAO.Recordset
Dim rsd As DAO.Recordset
Dim supplierName As String
Set rsd = Application.CurrentDb.OpenRecordset("Query_Dates", dbOpenDynaset)
Set rst = Application.CurrentDb.OpenRecordset("Master_Table" , dbOpenDynaset)

[Code] .....

View 6 Replies View Related

General :: No Current Recordset / Canceled By Associated Object

Feb 6, 2013

My form respectively subform has a couple of problems related to the recordset as it is available in VBA.

The mainform contains material data, the subform contains the components of that material and a quantity, while the components are materials themselves. The subform's control source is an SQL statement created by the query builder.

Everything worked fine before i replaced the material-selecting combobox in the continuous subform by a textbox and a button. That button leads to another (dialog) form with some filtering options, which in turn returns the number of the selected material. This material gets inserted into the textbox. To this point it works fine.

But when i enter a quantity before i selected a Material, i get an error message after selecting the Material: This Action was Cancelled by an Associated Object. This happens while executing the following VBA Code on click of the material selection button (exact position commented in code):

Code:
Private Sub cbuSelectComponent_Click()
' Select component
Dim SQL As String
Dim rs As Recordset
DoCmd.OpenForm "Material Selector Dialog", , , , , acDialog, "Dialog"
If GLB_selected_mat = -1 Then 'cancel

[Code] ....

I've found the following Microsoft KB Article: [URL] ..... In their example code they use:

' Restore text box value to the original record contents
' in this case, that is NULL
datDataCtl.UpdateControls

I assume this is the relevant part, but i have no DataControl (what's that?) and neither found an UpdateControls method in the subform object.

The second error, "no current recordset", occures when i edit an existing component line in the subform that has been added right before (also using the same event and code as mentioned above). If i close the form after adding the component and open it again, it's no problem.

View 2 Replies View Related

General :: Name Object - Change Color And / Or Character

Aug 7, 2013

I have in my DB a lot of tables, queries and macro and every time I spent too much time by choose the right object.

Would be really useful give a color or change the character on each object. Is it possible?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved