ACCESS FEED: Re: [MS_AccessPros] Help on Error 2448

Kamis, 13 Agustus 2015

Re: [MS_AccessPros] Help on Error 2448

Thanks John and Duane,

There was one calculated control in the form header with was hidden behind the tab control search boxes. As soon as I deleted the control from the form header, the error 2448 message disappeared.

Regards,

Kumar

---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Kumar-

Error 2448 is "Can't assign a value to this object." Is one of your controls not updatable?

When you get the error, select Debug (I don't see any On Error code), go to the Debug window (CTRL+G), and type:

?ctl.Name

.. and press Enter.

That should tell you the control that is causing the problem.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Aug 12, 2015, at 7:59 PM, Duane Hookom duanehookom@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Kumar,

Which lines generates the error? Did you try set a break in the code and step through it line by line? This should be automatic when your code is generating an error.

Duane Hookom, MVP
MS Access

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Wed, 12 Aug 2015 10:32:53 -0700
Subject: [MS_AccessPros] Help on Error 2448

Dear Group,
                 I am using the below mentioned coding to reset the search unbound text boxes, combo boxes in the form Header of my search form. The same coding is working fine in other databases, but in this particular database, it is giving error 2448. I do not know why this is appearing and how to avoid it. Please help.
-----------------------------------------------------------------------------
      Dim ctl As Control

      For Each ctl In Me.Section(acHeader).Controls
        Select Case ctl.ControlType
        Case acTextBox, acComboBox
            ctl.Value = Null
        Case acCheckBox
            ctl.Value = False
        End Select
    Next


    Me.FilterOn = False

-------------------------------------------------------
Kind Regards,
Kumar