Recent content by Maxis37

A clue I forgot to you mention. I just happened to have this record that we can DUPLICATE the issue with over and over. But in the real world, it's not always the 280th character. There might be 3000 characters in one record TOPIC field and it fails on the last character, or 50 characters in...

Okay.... created copy of the table, deleted original table, renamed copy of table, refreshed link of new table, and still get FAILURE in both the versions. Version 1 FE 2003 BE 2003 on Windows 7 / OFFICE 2010 platform. Version 2 FE 2010 BE 2010 on Windows 7 / 2010 platform. :( I'm very...

Okay - i created a front-end and back-end in Access 2010 format. Same failure. Now I'm going to try copying the table per SpikePL's suggestion.

I've done several compact and repairs thinking initially that the record was corrupt. But you can update the record and put more than the 280 characters and it saves it just fine. You can put less than the 279 characters and it saves it just fine. It's just one it ends with a character in the...

Okay - yet another CLUE! I can NOT update the back-end to Access 2010 at this time; the back-end has to remain Access 2003 because of interface/compatibility issues to other databases it interacts with. HOWEVER, I did update the front-end to Access 2010 with new Access 2010 references on the...

OK SpikePL - ANOTHER CLUE! You may be on to something here. I moved the Front-end and Back-end to a REMOTE PC that still has XP and OFFICE 2003 installed. I wish I could post the database, but it's not allowed where I work. GUESS WHAT! NO ERROR! So what does that mean? Why does Win7/Office...

Additional Information after creating new database and doing import. ANOTHER CLUE to the Mystery! If I simply hit the "end" key in the TOPIC field which puts the cursor on the last character of the string (in other words, we do NOT use the ZOOM Dialog BOX - Shift F2), it accepts the 280th...

Just did it - created new database, imported all objects. Same results! :(

We have a record called a CCR with only five fields in it. You can have many CCR's to one parent. One of the fields in the CCR record is a MEMO field called TOPIC. The user can hit Shift-F2 and the ZOOM Dialog Box comes up and they enter text. Everything's great so far. But every so often a CCR...

In MS ACCESS 2003 the database will automatically create a copy of the back-end and add "_Backup.mdb" to the name of the file if the database crashes. What does MS ACCESS 2010 do for a .mdb back-end? What does MS ACCESS 2010 do for a .accdb back-end? Does it append the word "Backup", or "Copy"...

i've got some homework to do... thanks for the hints

we're all getting old... i thought i remembered something too, but for the life of me... i'm sure someone has done it BEFORE selecting ENABLE MACRO... slowly but surely.. maybe i'll luck out and someone WILL remember :)

i'll try that on monday when i get to work... i'm not sure application.version works in the autoexec macro... i know it does in vba, i'll have think about the ACTION to use in the autoexec macro to do application.version.... hmmmm

the vba will NOT run BEFORE the user selects ENABLE MACRO button.... we need code that will tell if its a win XP/access2003 user or a WIN 7/access 2010... almost anything (including the vba) works for the XP/access2003 users, but the Win 7/access 2010 users and the whole "trusted site" issue...

the vba will NOT run BEFORE the user selects ENABLE MACRO button.... we need code that will tell if its a win XP/access2003 user or a WIN 7/access 2010... almost anything (including the vba) works for the XP/access2003 users, but the Win 7/access 2010 users and the whole "trusted site" issue...