What the hell happened to my database?

[N J]

Hi,

Please take a look at http://webmonky.myby.co.uk/error.JPG . This is the
second time this has happened. All I did was run command ...

CurrentDb.Execute "Update tblDownload Set OrderType = """ & "REFUNDED" & """
Where ID = " & Me.Text43 & ";", dbfailonerror
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

....and access seems to make data turn into chinese charactors and put
letters in different order (or even replace them with another random letter,
such as TOWN should read london, but it reads nlondo instead., also the
AutoNumber has changed from 33628111 to 545587303, although I have a form
that looks up AutoNumber 33628111, and it brings up 545587303, so it must
still be referenced. Anyone any idea what and why this happened?

Also I need my AutoNumbers to return to 8 digits because its causing
problems with other things I'd rather not go into...

Thanks

NK

[Larry Linson]

It is a puzzler.

Just so I don't have to go research it, what _is_ it that you expect of:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

I'd say it is "Save Record" or "Refresh", but I'd question why you'd want a
Save Record after an action query... that could be the problem. To be
honest, I just haven't used DoMenuItem to any extent since DoCmd.RunCommand
became available because the RunCommand is so much easier and more intuitive
and I forget whether the list item is 0-based or 1-based.

Larry Linson
Microsoft Access MVP

"N J" <bl*************@blueyonder.co.uk> wrote in message
news:Bn*******************@fe2.news.blueyonder.co. uk...

Hi,

Please take a look at http://webmonky.myby.co.uk/error.JPG . This is the
second time this has happened. All I did was run command ...

CurrentDb.Execute "Update tblDownload Set OrderType = """ & "REFUNDED" & """ Where ID = " & Me.Text43 & ";", dbfailonerror
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

...and access seems to make data turn into chinese charactors and put
letters in different order (or even replace them with another random letter, such as TOWN should read london, but it reads nlondo instead., also the
AutoNumber has changed from 33628111 to 545587303, although I have a form
that looks up AutoNumber 33628111, and it brings up 545587303, so it must
still be referenced. Anyone any idea what and why this happened?

Also I need my AutoNumbers to return to 8 digits because its causing
problems with other things I'd rather not go into...

Thanks

NK

[BillCo]

My guess:

According to your jpeg, DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5,
, acMenuVer70 will do spell check.
(activates 6th item on the form bar)

You have your language set to chinese and the chinese spellcheck doesnt
like your english.

Double check your system settings and make sure that you are point at
the right control.