Recent content by azirion

Ok I figured out a work around!!! I noticed that every time I pressed the button the error window came up only if the field was already with the same text I was trying to assign. If I edited the field manually and changed records back and forth it worked perfect, but if I pressed the button...

I can do pretty much everything I want, edit, add, delete, directly on the table or trhough the form, as long as I dont use VBA.

I can´t use the Upsizing Wizard for MySql, if I chose "Use existing database" the moment I chose the ODBC connection an error pops up saying <Type mismatch>. And if I chose the option "create new database" there´s no option other than an SQL server.

Check this test out: I created a brand new little MySql database which holds only one table, and this one has only 3 fields: the ID field, the text field, and the timestamp field (using default current_timestamp). I linked the table on MS Access front end, using the ODBC 5.1 driver/connector...

:D tell me about it... :rolleyes: :( I don't know if I understood correctly by "live database", but if you mean to leave it behind the button´s code as it was? then yes... the same little window from hell pops up :(

Ohhh Gina Im so sad.... I thought everything was ok... but no... I deleted the line Me.Refresh as you said and so the popup didnt came up, so I thought the problem was solved with your code, but when I tried it out with the main program the problem still persists. :(:(:(

Gina!!!! if I could I would give you a HUGE Kiss!!! You hit the nail!!! Thank you very much!!! You resolved the puzzle no one could!! thank you...thank you... thank you!!! :D:D:D:D:D

Im sorry Gina if you feel Im not giving you enough information. The thing is that I simplified the code as much as possible to pinpoint the error and the message is still popping up. As I said before I am able to edit, add, erase everything I want in any field and it works just fine. The only...

I did a test: Created a new Access 2007 file (accdb) linked only one table to the mysql server via ODBC and created only one form based on that table. I added a button and wrote into it this simple code: field.setfocus field.text="whatever" me.refresh -->same with docmd.requery Results: The...

Thank you for replying. They are not based on the same table, each sub form is based on its own table, and the problem occurs when I click to open a sub form (doesn't matter which one). But this only happens when I run the code on this button (described above). If I edit the field manually...

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. My problem is that I try to make a simple button which I wrote VBA code with a simple command like field.setfocus and field.text=whatever to insert some...

Never mind, thanks I already have the answer...

Extra info: I did a search directly into the query table, with the search button on the Access main menu, and it came out with the same result... took forever

Hi I have a front end Access program on my local computer based on a MySql database stored on a server, using ODBC to connect. In the db I have like about 3000 records. I inserted a Search button on the form, which works fine if I should make a search using the Whole Field, it lasts like 4...