Re: Error 2465 after upgrading 2000 to 2002.

• Previous message: Richard Crum: "Database replication"
• In reply to: Mr Petti: "Error 2465 after upgrading 2000 to 2002."
• Messages sorted by: [ date ] [ thread ]

Date: Sun, 2 Jan 2005 11:37:31 -0800

Hi, Mr. Petti.

I can think of two reasons for this.

1.) You have installed Office XP SP-3, and your code is attempting an
operation that affects the current record, such as deleting the current
record from the main form, but there is at least one bound subform embedded
in the bound main form. This is a confirmed bug in SP-3.

2.) A form's record source has been changed, and at least one of the
controls on the form is being referred to in VBA code by its control source,
not the control's name, but that control source isn't one of the fields in
the form's new record source.

If your problem is caused by reason #1, then you have several choices. You
can get rid of Office XP SP-3 so that Office XP SP-2 is the highest service
pack installed, or upgrade to Office Access 2003, or wait for Office XP SP-4
to be published (no guarantees that SP-4 is going to be published, though).
Or you may be able to change the code to avoid the current problem, but
we'll need more information about the operation affecting the current record
and the code where this error is occurring before we can offer help. (Note:
I'm heading off away from my computer for a good part of the day, so if you
need immediate help, somebody else is going to have to help you. I'll be
back later tonight, and I'll check the newsgroup then.)

If your problem is caused by reason #2, then you need to investigate which
control is the offender and delete the control if it's no longer needed, or
reassign the control's control source to an actual field in the form's
current record source.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Mr Petti" <Mr Petti@discussions.microsoft.com> wrote in message
news:669A9487-46E1-4E53-B069-0A2847EF0A07@microsoft.com...
> After upgrading to 2002 from 2000 i am getting numerious error 2465 in my
> visual basic code. Cannot Find the field "|" referred to in your
expression.
> Usually the coded does not even refere to a field, however it referes to a
> different form than the one the code is located. Worked alright in 2000
>
> I suspect a syntax error, however have tried many methods

• Previous message: Richard Crum: "Database replication"
• In reply to: Mr Petti: "Error 2465 after upgrading 2000 to 2002."
• Messages sorted by: [ date ] [ thread ]