Developer Forum

by **ZBC** » Sat, 03 Jan 2004 22:44:16

This is a multi-part message in MIME format.

I somehow mangaged to prevent any editing of a form.
.
The form's source in a query based on 3 tables.
I have determined the following:
The text boxes are set to 'Enabled - YES' and 'locked - NO'
The form's 'Allow Edits' is set to 'YES" and 'Record Locks is set
to 'No Locks'
I am able to highlight portions of the textbox ... but not change anything.

What else could be the problem?

Bob

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
I somehow mangaged to prevent any editing of a form. 
. 
The form's source in a query based on 3 tables. 
I have determined the following: 
The text boxes are set to 'Enabled - YES' and 'locked - NO' 
The form's 'Allow Edits' is set to 'YES" and 'Record Locks is set
to 'No Locks' 
I am able to highlight portions of the textbox ... but not change
anything. 
 
What else could be the problem? 
 
Bob 
</body>
</html>

by **Cheryl Fis** » Sat, 03 Jan 2004 22:56:09

The query that is the record source of your form is probably not updateable.
If the query is using aggregate functions (like Max(), Sum(), etc.) or has
totals this will be the case.

You can test this out by running the query as a query (away from your form)
to see if you can make changes to the result set.

I somehow mangaged to prevent any editing of a form.
.
The form's source in a query based on 3 tables.
I have determined the following:
The text boxes are set to 'Enabled - YES' and 'locked - NO'
The form's 'Allow Edits' is set to 'YES" and 'Record Locks is set to
'No Locks'
I am able to highlight portions of the textbox ... but not change anything.

What else could be the problem?

Bob

by **Rick Brand** » Sat, 03 Jan 2004 23:01:57

anything.

Most likely the query itself is not updateable. This is easily determined
by attempting to edit data directly in the query.

This is common with queries having multiple tables in them. There is a
help file topic that discusses this issue that you might want to take a
look at.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

by **ZBC** » Sun, 04 Jan 2004 01:08:31

This is a multi-part message in MIME format.

Apparently that is the problem ...
I have 3 tables with 2 one-to-many relationships.
Is there a way around this?

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Apparently that is the problem ... 
I have 3 tables with 2 one-to-many relationships. 
Is there a way around this? 
 
 

<blockquote type="cite"
cite="midbt3tkm$2f3db$ XXXX@XXXXX.COM ">

</pre>
<blockquote type="cite">
<pre wrap="">I somehow mangaged to prevent any editing of a form.
.
The form's source in a query based on 3 tables.
I have determined the following:
The text boxes are set to 'Enabled - YES' and 'locked - NO'
The form's 'Allow Edits' is set to 'YES" and 'Record Locks is set
to 'No Locks'
I am able to highlight portions of the textbox ... but not change
</pre>
</blockquote>
<pre wrap="">anything.
</pre>
<blockquote type="cite">
<pre wrap="">What else could be the problem?
</pre>
</blockquote>
<pre wrap="">
Most likely the query itself is not updateable. This is easily determined
by attempting to edit data directly in the query.

This is common with queries having multiple tables in them. There is a
help file topic that discusses this issue that you might want to take a
look at.

</pre>
</blockquote>
</body>
</html>

by **Rick Brand** » Sun, 04 Jan 2004 02:26:19

Access queries are editable as long as Access/Jet has no problem positively
identifying the exact rows in the base tables that the query is
referencing. As you build multi-table queries you can very easily end up
with output that displays what you want without having this positive link
to specific rows in all tables. At that point Access will make the query
read-only to avoid data corruption.

As stated before, there is a help topic that specifically addresses when a
query is updateable or why it is not. You need to read that and see what
applies to your specific situation. In some cases the query can be
modified a bit and again become editable. In other cases it cannot.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

by **ZBC** » Sun, 04 Jan 2004 04:27:38

his is a multi-part message in MIME format.

Rick,
I 'did' read (and print) the help files as you suggested ... sorry for
giving you the impression that I did not!
I was thinking that there may be a technique that is often used to work
around the issue ... maybe building a pyramid of Queries (no more than 2
tables at the bottom of the pyramid) or something simular might work? I
will try a few trial and error approaches.
Thanks for you help.
Bob

Rick Brandt wrote:

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Rick, 
I 'did' read (and print) the help files as you suggested ... sorry for
giving you the impression that I did not! 
I was thinking that there may be a technique that is often used to work
around the issue ... maybe building a pyramid of Queries (no more than
2 tables at the bottom of the pyramid) or something simular might
work? I will try a few trial and error approaches. 
Thanks for you help. 
Bob 
 
Rick Brandt wrote: 
<blockquote type="cite"
cite="midbt49js$37lq0$ XXXX@XXXXX.COM ">
<pre wrap="">"ZBC" <a class="moz-txt-link-rfc2396E" href="mailto: XXXX@XXXXX.COM ">< XXXX@XXXXX.COM ></a> wrote in message
<a class="moz-txt-link-freetext" href="news: XXXX@XXXXX.COM ">news: XXXX@XXXXX.COM </a>...
</pre>
<blockquote type="cite">
<pre wrap="">Apparently that is the problem ...
I have 3 tables with 2 one-to-many relationships.
Is there a way around this?
</pre>
</blockquote>
<pre wrap="">
Access queries are editable as long as Access/Jet has no problem positively
identifying the exact rows in the base tables that the query is
referencing. As you build multi-table queries you can very easily end up
with output that displays what you want without having this positive link
to specific rows in all tables. At that point Access will make the query
read-only to avoid data corruption.

As stated before, there is a help topic that specifically addresses when a
query is updateable or why it is not. You need to read that and see what
applies to your specific situation. In some cases the query can be
modified a bit and again become editable. In other cases it cannot.

</pre>
</blockquote>
</body>
</html>

by **Dirk Goldg** » Tue, 03 Feb 2004 04:22:53

Specifically, the title of the topic is "When can I update data from a
query?", under "Queries" -> "Opening, Viewing, and Running Queries".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Developer Forum

What can keep you from editing a form?

What can keep you from editing a form?

What can keep you from editing a form?

What can keep you from editing a form?

What can keep you from editing a form?

What can keep you from editing a form?

What can keep you from editing a form?

What can keep you from editing a form?