Help with Error 2448

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cb - 04 Jun 2007 19:53 GMT

I am encountering this error when trying to assign a piece of equipment to a
patient record within our database. When I click on "debug", it takes me to a
highlighted yellow line within the code process: Me.Assignee_ID =
iNewAssigneeID
Any idea of what is happening? Also it appears that database is locked when
trying to add a "date" within a query to any number field.
Please help.

Reply to this Message

BruceM - 04 Jun 2007 20:59 GMT

You should post the entire code (or at least the part that defines
iNewAssigneeID). Without that there is no way to know why the code fails at
that line.
Regarding the second question, what do you mean by saying you are "trying to
add a "date" within a query to any number field"? How does the database
being "locked down" manifiest itself?

>I am encountering this error when trying to assign a piece of equipment to
>a
[quoted text clipped - 6 lines]
> trying to add a "date" within a query to any number field.
> Please help.

Reply to this Message

BruceM - 04 Jun 2007 21:02 GMT

I forgot to add: 2448 is that "you can't assign a value to this object".
Is Me.AssigneeID an autonumber field? If so, that is at least part of the
problem.

>I am encountering this error when trying to assign a piece of equipment to
>a
[quoted text clipped - 6 lines]
> trying to add a "date" within a query to any number field.
> Please help.

Reply to this Message