Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Warning msg --> The record has been changed by another user... (http://www.go4expert.com/forums/warning-msg-record-changed-user-t26673/)

azirion 12Sep2011 23:30

Warning msg --> The record has been changed by another user...
 
Hi

I'm using MS Access as a front end program, and I have a form based on a query which obtains the data from a MySql database on a server through ODBC driver.

My problem is that I try to make a simple button which I wrote VBA code with a simple command like:

field.setfocus
field.text = "whatever"

The idea is to insert some text into that field. At that point I dont have any problems. The warning message appears when I try to change to another record, or if I add a Me.Refresh line into that code.

I have no problem adding, editing or deleting fields. The only way this windows pops up is when I try to edit or add text to an existing field using VBA on a button.

Furthermore if I use this button on a new record it works fine, at this point if a go to the first record, it works once more, from that point on, every time I click the button the popup appears :(

...and yes I added the TIMESTAMP field on the table using CURRENT_TIMESTAMP as default.

I would really appreciate some help on this one.


All times are GMT +5.5. The time now is 23:44.