Error 2486: You can't carry out this action

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 29 Mar 2005 05:49 GMT

I am getting this error, #2486, "You can't carry out this action at the
present time" when trying to close forms or go to other forms after I
update a number of records in my database via code.
I can't tell exactly what is locking it up.

Any ideas as to what might cause this?

Steve

Reply to this Message

JaRa - 29 Mar 2005 10:19 GMT

Can you close the forms during the update of data?

- Raoul

> I am getting this error, #2486, "You can't carry out this action at the
> present time" when trying to close forms or go to other forms after I
[quoted text clipped - 4 lines]
>
> Steve

Reply to this Message

Steve - 30 Mar 2005 02:44 GMT

The actual update takes just a few seconds. It is _after_ that that the
forms/buttons are locked. I have to close Access and open it again in
order to move to the next task. Inconvenient, to say the least...

Steve

> Can you close the forms during the update of data?
>
[quoted text clipped - 8 lines]
>>
>>Steve

Reply to this Message

JaRa - 30 Mar 2005 08:55 GMT

Can you give us the code please?

- Raoul

> The actual update takes just a few seconds. It is _after_ that that the
> forms/buttons are locked. I have to close Access and open it again in
[quoted text clipped - 14 lines]
> >>
> >>Steve

Reply to this Message

Mauricio Silva - 30 Mar 2005 21:45 GMT

I was going thru the same problem.

In my case I had a form/subform structure. I have 2 fields in my linkfields
(Fiscal year and department) and I also have a third field (business) which
is optional. When selected I was filtering using: Child1.form.filter =
"business = ""My Business"""

After changing the filtering options a few times, I was getting the error
2486.

I fixed it by changing dynamically the RecordSource of the subform when I
select the third filter, as below and keeping the LinkFields:

Child1.Form.RecordSource = "SELECT * FROM [BUDGET DATA]" & _
iif(ComboBusiness = "- ALL", "", " WHERE Business =
""" & ComboBusiness & """")

I hope it helps

Take care

Mauricio Silva

> The actual update takes just a few seconds. It is _after_ that that the
> forms/buttons are locked. I have to close Access and open it again in
[quoted text clipped - 14 lines]
> >>
> >>Steve

Reply to this Message