By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,022 Members | 856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,022 IT Pros & Developers. It's quick & easy.

Updating Records from a query results.

P: 72
Hello again,

Problem: I created a query to pull a set of records by workorder number. It works like a champ. However, I need the user to update/edit the records if need be. I am displaying the query results in a form. However, when I try to change an entry in any of the fields, I get a "ding" and nothing changes. The records are there for display (it seems) and nothing can be done to edit them. Everything I've read tells me it should be doable, but I am doing something wrong. I have set all properties for users to able to Allow Edits, Allow Deletions and Allow additions under Data Properties for the form.

So, where am I missing the boat?

The database resides in Network Drive with Novell controlling user rights. My network guy says that is nothing on his end. Alledgedly :).
Mar 12 '07 #1
Share this Question
Share on Google+
9 Replies


Rabbit
Expert Mod 10K+
P: 12,359
You can't make changes to a calculated field. If the query is pulling the data straight from a table, then you can make a change to that, which will reflect itself in the table.
Mar 12 '07 #2

P: 72
You can't make changes to a calculated field. If the query is pulling the data straight from a table, then you can make a change to that, which will reflect itself in the table.
I'll double check my query, but I am pretty sure it is straight from the table. By calculated you mean if the query is pulling data from another query or table, correct?
Mar 13 '07 #3

Rabbit
Expert Mod 10K+
P: 12,359
No, I mean if the field has some sort of operation performed on it such as addition or concatenation.
Mar 13 '07 #4

P: 72
Okay, I know I dont have any math in the fields. However, I may be concatenating. Off to check.
Mar 13 '07 #5

Rabbit
Expert Mod 10K+
P: 12,359
Remember I said such as, check if you use any functions as well.
Mar 13 '07 #6

NeoPa
Expert Mod 15k+
P: 31,429
An easy way to check if a query is updatable is to open it and, if it is updatable, there will be a record slot at the end (marked *) for entering a new record. If this is not there then your query is not updatable.
Mar 13 '07 #7

P: 72
Thxs for your help gents. I was concatenating one field. Thxs for quick tip Neopa.
Apr 2 '07 #8

Rabbit
Expert Mod 10K+
P: 12,359
Not a problem.
Apr 2 '07 #9

NeoPa
Expert Mod 15k+
P: 31,429
Thxs for your help gents. I was concatenating one field. Thxs for quick tip Neopa.
You're welcome Rotor.
Now let me see if I can respond to your other thread before going to bed.
Apr 3 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.