error message help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which is linked to a query. this query, in turn, populates a
table. I will show a few of the field names of the table that is being
populated for example's sake below:

Name Emp_id Year Jan JanHrs Feb FebHrs
Mar MarHrs
Jon Doe 21 2004 4 180 3
150 4 160

The fields Jan, Feb, & Mar are populated through the form. JanHrs, FebHrs,
and MarHrs are populated through Update queries once Jan, Feb, or Mar has
been updated. Whenever I do this though, I get the following 'Write
Conflict' error:

***********************************************************
This record has been changed by another user since you started editing it.
If you save the changes, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.
************************************************************

Do you know of what can be causing it and what I can do to get rid of it?

In need of some help,
Chad
 
I have a form which is linked to a query. this query, in turn, populates a
table. I will show a few of the field names of the table that is being
populated for example's sake below:

Name Emp_id Year Jan JanHrs Feb FebHrs
Mar MarHrs
Jon Doe 21 2004 4 180 3
150 4 160

The fields Jan, Feb, & Mar are populated through the form. JanHrs, FebHrs,
and MarHrs are populated through Update queries once Jan, Feb, or Mar has
been updated.
Click to expand...

You might want to reconsider your table design. Storing data - month
names - in fieldnames is "committing spreadsheet upon a database", a
venial sin. Might it be preferable to use two tables, the second one
(tblHours maybe) with fields WorkYear (don't use Year, it's a reserved
word), WorkMonth, TotalHours and EmployeeID, linked to your employee
table by the ID?
Whenever I do this though, I get the following 'Write
Conflict' error:

***********************************************************
This record has been changed by another user since you started editing it.
If you save the changes, you will overwrite the changes the other user made.

Copying the changes to the clipboard will let you look at the values the
other user entered, and then paste your changes back in if you decide to make
changes.
************************************************************

Do you know of what can be causing it and what I can do to get rid of it?
Click to expand...

The error is arising because you have the same record open for editing
on the form, and (presumably, though you don't say) open for editing
by the Update queries. Access locks the record when the Form opens it,
making it unavailable for the update query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top