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

Write conflict

P: n/a
Dear reader,

I have two Forms they are both working with dada from the same tables.

By typing in some changes in Form-B the changes are also visible in Form-A.

There is no record lock set.

In the same two forms there are sub Forms. These sub Forms using the same
table and same record and field but it is another table as in the main form.
By changing the content of the field in Form-A and than in Form-B a form
pups up "Write conflict", with the message "The record has been changed by
another user since you started editing it. If you save the record, you will
overwrite the changes the other user made."

In this situation it is not another user but it is the same user only
another Form.

How can I force that the changes made in the current Form are the valid one?

And there is no longer a write conflict.

Thanks for any help.

Kind regards,

Simon van Beek

Feb 12 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
"Simon" <S.******@HCCnet.nl> schreef in bericht news:43**********************@dreader29.news.xs4al l.nl...
Dear reader,



I have two Forms they are both working with dada from the same tables.

By typing in some changes in Form-B the changes are also visible in Form-A.

There is no record lock set.

In the same two forms there are sub Forms. These sub Forms using the same
table and same record and field but it is another table as in the main form.
By changing the content of the field in Form-A and than in Form-B a form
pups up "Write conflict", with the message "The record has been changed by
another user since you started editing it. If you save the record, you will
overwrite the changes the other user made."

In this situation it is not another user but it is the same user only
another Form.



How can I force that the changes made in the current Form are the valid one?

And there is no longer a write conflict.



Thanks for any help.

Kind regards,

Simon van Beek


So you are editing Form-A, and without saving you are editing the very same record in Form-B ?
Why ??

If you *really* need to do things this way, maybe you can save the record after 'any' field edit in Form-A (and perhaps requery the Form-B).
Same for the other way around.

Arno R
Feb 12 '06 #2

P: n/a
Arno,

Of course I need to save the record after any field edit in Form-A but the
question is how?

What is the VBA code or Docmd instruction and which event is the richt one
to do this?

Regards,

Simon



"Arno R" <ar***********@tiscali.nl> schreef in bericht
news:43**********************@text.nova.planet.nl. ..
"Simon" <S.******@HCCnet.nl> schreef in bericht
news:43**********************@dreader29.news.xs4al l.nl...
Dear reader,

I have two Forms they are both working with dada from the same tables.

By typing in some changes in Form-B the changes are also visible in Form-A.
There is no record lock set.

In the same two forms there are sub Forms. These sub Forms using the same
table and same record and field but it is another table as in the main form. By changing the content of the field in Form-A and than in Form-B a form
pups up "Write conflict", with the message "The record has been changed by
another user since you started editing it. If you save the record, you will overwrite the changes the other user made."

In this situation it is not another user but it is the same user only
another Form.

How can I force that the changes made in the current Form are the valid one?
And there is no longer a write conflict.

Thanks for any help.

Kind regards,

Simon van Beek


So you are editing Form-A, and without saving you are editing the very same
record in Form-B ?
Why ??

If you *really* need to do things this way, maybe you can save the record
after 'any' field edit in Form-A (and perhaps requery the Form-B).
Same for the other way around.

Arno R
Feb 12 '06 #3

P: n/a
Well, the good news is that Access 12 is going to take and use DNA
samples so that it can differentiate between another user and the same
idiot.
I suppose Access gives you the opportunity of saying, "Yes, save my
changes?" So why don't you?
As an alternative you could buy one of those disk-wiping programs, use
it, reinstall Windows and Access, do some reading on DB design, have a
look at Northwind which is pathetic but a big step up from what you
describe and start over. I know, I'm mean and rude and I'm terribly
sorry. But when you post nonsense like this it's like the common law.
Unless it's challenged, someone cites it as a rationale for something
else. Yes, I know, I just have no appreciation for your special needs
and the complexity of the situation. Yeah, yeah, sure, sure, whatever!

Feb 12 '06 #4

P: n/a
Simon wrote:
Dear reader,

I have two Forms they are both working with dada from the same tables.

By typing in some changes in Form-B the changes are also visible in Form-A.

There is no record lock set.

In the same two forms there are sub Forms. These sub Forms using the same
table and same record and field but it is another table as in the main form.
By changing the content of the field in Form-A and than in Form-B a form
pups up "Write conflict", with the message "The record has been changed by
another user since you started editing it. If you save the record, you will
overwrite the changes the other user made."

In this situation it is not another user but it is the same user only
another Form.

How can I force that the changes made in the current Form are the valid one?

And there is no longer a write conflict.

Thanks for any help.

Kind regards,

Simon van Beek

Can't remember the cause, there may be many. Are you updating a field
in the AfterUpdate event of the form and not the BeforeUpdate event of
the form? Check that out.
Feb 12 '06 #5

P: n/a

"Simon" <S.******@HCCnet.nl> schreef in bericht news:43***********************@dreader24.news.xs4a ll.nl...
Arno,



Of course I need to save the record after any field edit in Form-A but the
question is how?

What is the VBA code or Docmd instruction and which event is the richt one
to do this?


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
or simply Me.Dirty =false
Use the afterupdate event of your fields.

But we would like to know WHY ???

Arno R
Feb 12 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.