Recent content by INFOS

Code Send me please what exactly did you wrote in "on key press" event - the code. Thanks!

It's not that Yes I did - it's not that.

How? There is no way to capture escape key - at all! Autokeys doesn't support escape key (and I need escape key on other places in my application). And you can not stop "escape key break" neather with keydown event nor with keypress event!

Same thing Escape button stops sql code same as saved query.

reply That's exactly what happens. Is there a way to block "escape" button until this code ends or to use "rollback" somehow?

yes Yes it is. And don't tell me to use autokeys. First, there is no autokeys symbol for "escape" button ("Esc" does not work) and even if it works that causes me another problems...

It's not that Now, code is correct but this still does not work: Dim wsp As Workspace Dim fInTrans As Boolean On Error GoTo C4Err fInTrans = False Set wsp = DBEngine.Workspaces(0) wsp.BeginTrans fInTrans = True DoCmd.OpenQuery "query1" DoCmd.OpenQuery "query2" DoCmd.OpenQuery "query3"...

WHAT IS WRONG WITH THIS CODE: Dim wsp As Workspace Dim fInTrans As Boolean On Error GoTo C4Err fInTrans = False Set wsp = DBEngine.Workspaces(0) wsp.BeginTrans fInTrans = True DoCmd.OpenQuery "query1" DoCmd.OpenQuery "query2" DoCmd.OpenQuery "query3" DoCmd.OpenQuery "query4"...

WHAT IS WRONG WITH THIS CODE: Dim wsp As Workspace Dim fInTrans As Boolean On Error GoTo C4Err fInTrans = False Set wsp = DBEngine.Workspaces(0) wsp.BeginTrans fInTrans = True DoCmd.OpenQuery "query1" DoCmd.OpenQuery "query2" DoCmd.OpenQuery "query3" DoCmd.OpenQuery "query4"...

WHAT IS WRONG WITH THIS CODE: Dim wsp As Workspace Dim fInTrans As Boolean On Error GoTo C4Err fInTrans = False Set wsp = DBEngine.Workspaces(0) wsp.BeginTrans fInTrans = True DoCmd.OpenQuery "query1" DoCmd.OpenQuery "query2" DoCmd.OpenQuery "query3" DoCmd.OpenQuery "query4"...

I want to run 10 big queries (append/update/delete) one after another. If error happens before they all finish (if user press escape button) - I want to discard all record changes made by any of those queryes. I suppose begin/end transaction method is the right way to do that. Can you give me an...

Does anyone knows what is ".sad" extension? Is that a database file (as it appears in windows explorer description)? Can I import data from a ".sad" file to access?

Reply Form is active but it does'nt helps. Escape key stops the query running.

Blocking escape not only on a form ? I did not put my question right. I want to run a query on a form. That query works with big amount of data and it needs a few minutes to end. I need to block "escape" key while query runs - becouse "escape" is stoping my query in the middle. If I block this...

Is there a way to block "Escape" key in a form - to be no reaction at all when I press "Esc"?