Manipulating data in textbox with VBA code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FR - 29 Mar 2006 22:47 GMT

I am getting ERR 3326 "This recordset is not updatable" when trying to
manipulate data in controls on a form with VBA. The code is in a form module,
examples:

Forms!frmMembership!DateJoined = Date
Forms!frmMembership!DuesAcct = -Forms!frmMembership!CurrDues

What triggers ERR 3326?

Reply to this Message

Douglas J. Steele - 29 Mar 2006 23:41 GMT

What usually triggers it is the underlying recordset not being updatable.

Can you make changes not through VBA?

Assuming that the recordset is a query, is the query updatable?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I am getting ERR 3326 "This recordset is not updatable" when trying to
> manipulate data in controls on a form with VBA. The code is in a form
[quoted text clipped - 5 lines]
>
> What triggers ERR 3326?

Reply to this Message

FR - 30 Mar 2006 02:12 GMT

> What usually triggers it is the underlying recordset not being updatable.
>
[quoted text clipped - 13 lines]
>
> Thanks for your response. You were right of course. Some of the fields in the underlying query are not updatable. I guess I am more ignorant than I thought I was. How do you control whether a field or a query is updatable?

Reply to this Message

Douglas J Steele - 30 Mar 2006 11:50 GMT

See whether the following helps:
http://msdn.microsoft.com/library/en-us/off2000/html/acconDeterminingWhenCanUpda
teDataQueryS.asp

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>Thanks for your response. You were right of course. Some of the fields in the underlying query are not updatable. I guess I am more ignorant than I

thought I was. How do you control whether a field or a query is updatable?

Reply to this Message

FR - 01 Apr 2006 18:20 GMT

Thank you, the refernce solved that problem. Now I ran into another:

I have a form with all controls (textboxes) updatable manually. When I try
to manipulate data in them by VBA code, e.g.
Me.DateJoined = Date or
Me.MFirst = "Joe"
I get the following error message;
Runtime error:'-2147352567 (80020009)' You can't assign a value to this
object.
Or, if I append .Value to the object's name:
Runtime error:'2448' You can't assign a value to this object.
It almost seems like the evil spirits lurking inside VBA don't want me to
use it.

> See whether the following helps:
> http://msdn.microsoft.com/library/en-us/off2000/html/acconDeterminingWhenCanUpda
teDataQueryS.asp
>
> >Thanks for your response. You were right of course. Some of the fields in
> the underlying query are not updatable. I guess I am more ignorant than I
> thought I was. How do you control whether a field or a query is updatable?

Reply to this Message

Douglas J. Steele - 01 Apr 2006 20:10 GMT

What are Me.DateJoined and Me.MFirst: the names of text boxes on your form,
the names of fields in your underlying recordsource, or both?

If both, change the names of your text boxes, and try updating the text
boxes, not the fields.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Thank you, the refernce solved that problem. Now I ran into another:
>
[quoted text clipped - 18 lines]
>> thought I was. How do you control whether a field or a query is
>> updatable?

Reply to this Message