Form seemed Read-Only

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emerlita@shaw.ca - 19 Apr 2007 21:56 GMT

I cannot do anything with the form i created. I cannot add, delete, or
modify a record. Is there something i missed here?

Reply to this Message

John W. Vinson - 20 Apr 2007 00:53 GMT

>I cannot do anything with the form i created. I cannot add, delete, or
>modify a record. Is there something i missed here?

Evidently. Of course we can't see the form, so it's hard to guess what.

The most common cause, though, is basing the form on a non-updateable Query.
What's the Recordsource of the form? If it's a query, try opening the query in
datasheet view: is there a blank new record at the bottom? can you edit data
in the datasheet?

If not, see the online help for "updateable" and/or post the SQL view of the
query here.

Other possibilities are that the Allow Edits and/or Allow Additions properties
of the form are set to No.

John W. Vinson [MVP]

Reply to this Message

emerlita@shaw.ca - 02 May 2007 20:47 GMT

On Apr 19, 5:53 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

> >I cannot do anything with the form i created. I cannot add, delete, or
> >modify a record. Is there something i missed here?
[quoted text clipped - 13 lines]
>
> John W. Vinson [MVP]

i want to paste a screenshot here so that i can show what im talking
about but i can't. is there any way to do this?

Reply to this Message

Douglas J. Steele - 02 May 2007 21:54 GMT

> On Apr 19, 5:53 pm, John W. Vinson
> <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
[quoted text clipped - 22 lines]
> i want to paste a screenshot here so that i can show what im talking
> about but i can't. is there any way to do this?

Binary attachments are strongly discouraged, but it shouldn't be necessary.

John asked what the recordset of the form was. Is it a query or a table? I'm
guessing it's a query, and that the query itself isn't updatable.

Signature

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

Reply to this Message

John W. Vinson - 02 May 2007 23:30 GMT

>i want to paste a screenshot here so that i can show what im talking
>about but i can't. is there any way to do this?

No. Binary attachments are NOT welcome in this text-only newsgroup!

Please describe the problem that you are having in words. I understand that
the Form is giving you an error that the form is not updateable. As I said,
this usually means that the Form is based on a Query that is itself not
updateable (or, sometimes, it's just that the Form's Allow Updates property is
set to No).

Open the Form in design view; look at its Properties (click the little square
at the upper left intersection of the rulers). On the Data tab the first line
is the Recordsource property. What is in that property? If it's a SQL string
copy and paste it to a message here; if it's the name of a Query open the
Query in SQL view and post that text here.

John W. Vinson [MVP]

Reply to this Message