Ask Experts Questions for FREE Help !
Ask
    wilpeter's Avatar
    wilpeter Posts: 2, Reputation: 1
    New Member
     
    #1

    Feb 12, 2012, 01:48 PM
    Automation object, not contained?
    Version 2002 of Access. I have a Menu form (not connected to a table). It mostly contains macro buttons, but one field should reflect the last assigned autonumber in a receipt table (called tblTaxReceiptNumbers, fieldname TaxReceiptNo) I have a query called qryLastReceiptNo that displays one field TaxReceiptNo sorted Descending with Top Values =1 that wonderfully gives me the number; however I can't display it in my menu field. I get the dialog/error "The object doesn't...etc." I've tried the SetValue in a macro with the two properties identified... same result. Everything else seems to work. Pressing Ctrl G and looking in References shows VB for Apps; Access 10.0 object library; OLE Automation; and MS ActiveX Data Objects 2.1 Library. Anything else I should be checking?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Feb 15, 2012, 07:52 PM
    Use a DLookup to pull the value from your query or a DMax to pull the value from the table. Use the expression as the ControlSource of the text control.
    wilpeter's Avatar
    wilpeter Posts: 2, Reputation: 1
    New Member
     
    #3

    Feb 21, 2012, 11:40 AM
    Thanks for your response. I've tried both these expressions in the Control Source property of the table's field Lastest:
    DMax([TblReceiptNumbers]![TaxReceiptNo])
    DLookup([qryLastReceiptNo]![TaxReceiptNo])
    and each provides the same result, which is #Name?
    Am I correctly interpreting your suggesion?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Feb 21, 2012, 02:40 PM
    Yes, but not implementing it properly. First a table doesn't have controlsources, so you must be referring to a form.

    You needed to lookup the correct syntax for a DMAX. Thje syntax is:

    DMax("[fieldname]","tablename")

    So if TaxReceiptNo is your field and TblReceiptNumbers your table then use:

    =DMax("[TaxReceiptNo]","TblReceiptNumbers")

    as the controlsource. Or use:

    =DLookup("[TaxReceiptNo]","qryLastReceiptNo")

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Object doesn't contain automation object [ 1 Answers ]

Scrolling through Northwind Database sample. 'Opening the "Customer Phone List" Form. When I click on the alphabets below, I receive an information that the "The object doesn't contain the Automation object 'RecordsetClone.'" Please can you explain why and can you help me out? I want to design...

The object doesn't contain the Automation object '|.' [ 1 Answers ]

Hello, And thank you for taking this question. I currently support a small Access system and ran into the error mentioned in the title. I believe that the issue is system-specific because I ran the system from my desktop and printed fine. The issue centers around the cmdPrint command function. ...

Word Automation [ 1 Answers ]

Hi friends My name is Ramesh. And I need help regarding Word Automation through ASP.NET. I am trying to generate a Word Document stored on the Server. My code is:- Word.Application wApp=new Word.ApplicationClass(); Word.Document wDoc; wApp.Visible=true; wApp.Caption="Demo Questionnaire...

Automation object [ 1 Answers ]

I wonder if you could help me? I started recentley working in a company. I am at the moment working on some listings of data bases in Access 2000. I was trying to make e customers phone list with the form similar to the one at Northwind Example. Everything went well with the table, form...


View more questions Search