Write Conflict

D

Dan @BCBS

When "CO4" is picked from the drop down a form pops up. The user enters some
comments and closes the pop up form. Then when the main form is closed a
window pops up "Write Conflict" ....Copy to Clipboard or Drop Changes.

How can I allow the updates without this message comming up??

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_Drugs"
If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then

stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub
 
M

Maurice

I think the mainform is still dirty when the popup is closed. Try setting the
mainform dirty to false before opening the popup.
 
D

Dan @BCBS

Please help me understand: The "On Dirty" is not a true/false??


Maurice said:
I think the mainform is still dirty when the popup is closed. Try setting the
mainform dirty to false before opening the popup.
--
Maurice Ausum


Dan @BCBS said:
When "CO4" is picked from the drop down a form pops up. The user enters some
comments and closes the pop up form. Then when the main form is closed a
window pops up "Write Conflict" ....Copy to Clipboard or Drop Changes.

How can I allow the updates without this message comming up??

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_Drugs"
If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then

stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub
Click to expand...
Click to expand...
 
S

Scott McDaniel

Please help me understand: The "On Dirty" is not a true/false??
Click to expand...

He means do this:

If Me.Dirty Then Me.Dirty=False

before showing your popup ... this forces Access to save your data, if needed
Maurice said:
I think the mainform is still dirty when the popup is closed. Try setting the
mainform dirty to false before opening the popup.
--
Maurice Ausum


Dan @BCBS said:
When "CO4" is picked from the drop down a form pops up. The user enters some
comments and closes the pop up form. Then when the main form is closed a
window pops up "Write Conflict" ....Copy to Clipboard or Drop Changes.

How can I allow the updates without this message comming up??

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_Drugs"
If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then

stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub
Click to expand...
Click to expand...
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
M

Maurice

Scott,

Thanks for the clarification.. that's exactly what I meant..
--
Maurice Ausum


Scott McDaniel said:
Please help me understand: The "On Dirty" is not a true/false??
Click to expand...

He means do this:

If Me.Dirty Then Me.Dirty=False

before showing your popup ... this forces Access to save your data, if needed
Maurice said:
I think the mainform is still dirty when the popup is closed. Try setting the
mainform dirty to false before opening the popup.
--
Maurice Ausum


:

When "CO4" is picked from the drop down a form pops up. The user enters some
comments and closes the pop up form. Then when the main form is closed a
window pops up "Write Conflict" ....Copy to Clipboard or Drop Changes.

How can I allow the updates without this message comming up??

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_Drugs"
If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then

stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub
Click to expand...
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...
 
D

Dan @BCBS

This is very useful information.

It does allow the user to enter data in the popup, but a new message pops up
when trying to move off the text box. "The data has been changed" Another
user edited this record and saved the changed before you attempeted to save...

Is there anything I can add to Not have this come up???

Thanks



Maurice said:
Scott,

Thanks for the clarification.. that's exactly what I meant..
--
Maurice Ausum


Scott McDaniel said:
Please help me understand: The "On Dirty" is not a true/false??
Click to expand...

He means do this:

If Me.Dirty Then Me.Dirty=False

before showing your popup ... this forces Access to save your data, if needed
:

I think the mainform is still dirty when the popup is closed. Try setting the
mainform dirty to false before opening the popup.
--
Maurice Ausum


:

When "CO4" is picked from the drop down a form pops up. The user enters some
comments and closes the pop up form. Then when the main form is closed a
window pops up "Write Conflict" ....Copy to Clipboard or Drop Changes.

How can I allow the updates without this message comming up??

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_Drugs"
If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then

stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub
Click to expand...

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...
Click to expand...
 
M

Maurice

Dan,

Where did you put the code? In the mainform before you call the popupform?
If you did put it there then if you still get the message there must be
something else going on.
--
Maurice Ausum


Dan @BCBS said:
This is very useful information.

It does allow the user to enter data in the popup, but a new message pops up
when trying to move off the text box. "The data has been changed" Another
user edited this record and saved the changed before you attempeted to save...

Is there anything I can add to Not have this come up???

Thanks



Maurice said:
Scott,

Thanks for the clarification.. that's exactly what I meant..
--
Maurice Ausum


Scott McDaniel said:
Please help me understand: The "On Dirty" is not a true/false??

He means do this:

If Me.Dirty Then Me.Dirty=False

before showing your popup ... this forces Access to save your data, if needed



:

I think the mainform is still dirty when the popup is closed. Try setting the
mainform dirty to false before opening the popup.
--
Maurice Ausum


:

When "CO4" is picked from the drop down a form pops up. The user enters some
comments and closes the pop up form. Then when the main form is closed a
window pops up "Write Conflict" ....Copy to Clipboard or Drop Changes.

How can I allow the updates without this message comming up??

Private Sub TR_PROBLEMCODESUFFIX_AfterUpdate()

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "f_Drugs"
If Me.TR_PROBLEMCODESUFFIX = "CO4" Or Me.TR_PROBLEMCODESUFFIX = "MS3" Then

stLinkCriteria = "[ICNNO]=" & "'" & Me![ICNNO] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If
End Sub

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Save 2
button VS drop down 2
If Statements 4
ADD Mode 4
Criteria when opening form 1
Add record and update List 5
Type Mismatch 3
Open based on two values 4

Top