Write Conflict Popup

[LDMueller]

Good morning,

I have Access 2003. I have a problem which I'm going to simplify in order
to explain it. I have three forms named frmNewTickets, frmOpenTickets, and
frmAllTickets.

All forms use the same tables, but the Record Source for each use different
Queries because they filter different information. All of these forms have
the same buttons which pointed to two other forms. One being frmUpdateTicket
and frmReassignTicket.

My problem is when doing it this way, I get a "Write Conflict" popup which
states "This 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. Copying the changes to the clipboard will let yo look at the
values the other user entered, and then paste your changes back in if you
decide to make changes. I then have to choose from three buttons, Save
Record, Copy to Clipboard, or Drop Changes.

Many times, I'm the only person in the database. What I've done to work
around this is I made a duplicate copies of the form and renaming them as
follows:

The Form frmOpenTickets has a Command Buttons named "Update" which points to
frmUpdateTicket and another Command Button named "Reassign" which points to
frmReassignTicket.

The Form frmAllTickets has a Command Buttons named "Update" which point to
frmUpdateTicket1 and another Command Button named "Reassign" which points to
frmReassignTicket1.

This way no form will use the same form (if that makes sense).

I have also tried adding the following ...
If Me.Dirty then Me.Dirty=False 'then your code to open other forms.
behind my buttons that open subsequent forms. This works some of the time,
but not all of the time.

This is a simplified explanation of what I'm doing, however I have multiple
forms with multiple buttons and having to copy and maintain duplicate forms
with different names seems like a lot of work and I'm hoping there is a
better way to handle this.

Any insight would be greatly appreciated. And I'd really like to know if it
is okay to have several form with command buttons which point to the same
form or if this is improper design.

Thanks!

 

[tina]

your problem isn't that the primary forms are sharing secondary forms, the
problem is that the forms are bound to the same table(s). think of the forms
as similar to skins on a media player; changing skins changes the look, but
the underlying media player itself is the same. a table bound to different
forms, even when filtered by different queries, is still the same table.

if you're the only one using the db, or if your users each have their own
copy of the frontend "half" of a shared database, then - as MVP Joan Wild
suggested on April 11 - it's quite possible that you don't need three forms,
but one only. why don't you tell us what you're doing in each of the three
forms, and how your process requires moving from one form to another;
perhaps someone can suggest solutions that involve building and maintaining
one form only.

hth

 

[LDMueller]

Thank you for your response. My single database is shared by many people. I
just noted I get the message when I'm the only one in it at the time. I also
get the MS Access message "Could not update; currently locked by another
session on this machine".

Here's the reason I have three forms.
frmNewTickets - When this form opens, it runs an Append Query which pulls
data from Outlook. The Default View on this form is a Single Form.

frmOpenTickets - When this form opens, it's Query filters to not include
Closed Tickets and prompt in case you want to filter by Ticket Owner. The
Default View on this form is a Single Form.

frmAllTickets - When this form opens, it's Query filters prompt in case you
want to filter by Ticket Owner. The Default View on this form is a
Continuous Forms. Once this form is open, you can click on another button to
select a single ticket (which is another form with the Default View is Single
Form).

Once each one of these forms are opened (and the user clicks on a single
ticket for the frmAllTickets form) the forms have the same buttons (e.g.
Close Ticket, Reassign Ticket, Update Ticket, etc.) depending on what they
want to do. Having the different buttons determines the text the ends up in
the Problem Field. As different things are done on a ticket, details are
added to the beginning of the field so it looks similar what's below. Each
item starting with "-----" was produced with a click of a button on my forms.

Ticket Closed
----- MCG - 04/17/2007 2:13:35 PM (Status: Closed) -----
Details of what was done.

----- Reassigned from LDM to MCG - 04/18/2007 12:02:39 PM (Status:
Pending) -----
Details of what was done.

----- Ticket #12058 was assigned to LDM by KLF - 04/17/2007 12:46:37 PM
(Status: Pending) -----
Details of what was done.

----- Original Message From John Doe - 04/17/2007 12:45:52 PM -----
Details of original request

Thanks!

 

[tina]

from the information you've posted, it sounds like this *can* be handled in
a single form, probably using a tab control and one subform.

if you're working in a version of Access between A97 and A2003, you can
email me a *compacted* copy of your database (with proprietary data removed)
and i'll work up a demo form solution to send back to you, so you can review
it.

if you'd like to do this, then click the following link to my website and
follow the instructions in the Tip to decode my email address - also
changing the 2 in the address to a 1.

http://home.att.net/~california.db/tips.html#aTip11

mention the newsgroups in the email's subject line, so i don't delete it as
spam; and pls don't post my real email address here in the newsgroups.

hth

 

[LDMueller]

Hello Tina,

I was just checking... Did you receive the database I emailed you?

Thanks, LD

 

[tina]

no, hon, i didn't. all i've gotten at that email address is "bulk mail",
since i posted the webpage link a week ago. want to go back to the page and
doublecheck how you decoded it? alternately, you can post your email address
here for me to send you an email. but if you do that, *make sure you
disguise it* as the webpage Tip suggests, and tell me how to decode it in
the same post.

hth

 

[LDMueller]

Hi Tina,

Although I'm reasonable sure I decoded your email address, I'm going to give
you mine so you can email me.

lREmMuelCleratenHnigerdotcom
(remove all the capital letters and convert the "at" and "dot" to symbols)

 

[tina]

okay, just emailed you, LD.

Hi Tina,

Although I'm reasonable sure I decoded your email address, I'm going to give
you mine so you can email me.

lREmMuelCleratenHnigerdotcom
(remove all the capital letters and convert the "at" and "dot" to symbols)

 

[LDMueller]

Tina,

Let's try this one. I think I goofed on the other one.

lPdmuRelleratsAenniAgerdotcom
(remove all the capital letters and convert the "at" and "dot" to symbols)

Thanks!

 

[tina]

yes, the email i sent bounced back to me. i've just emailed to the new
address posted below.

 

[LDMueller]

Hi Tina,

Just wondering if you had a chance to look at my database.

Thanks!