Search results

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"?

Is there a way to see a number of current users of a database? Also is there a way to see number of users with same username? Thanks

What is wrong with this linked pictures in my database? I have made OLE field in a table and I want to insert pictures in that field with option "linked". But pictures are not exactly linked. First, they take a lot of space in a database, almost as inserted pictures (If inserted picture takes...

reply Yes, I know the shortcut - but I don't want to open database file directly (there's only tables in this file). I want to open application "app1" that has links to the database file and at the same time to lock the database file only for myself - and I'm going to approach those tables by...

If I have one access mdb file called "DATA" that contains tables and two access applications as mdb files: "app1" and "app2". Both applications has links to tables in access mdb file "DATA". Is there a way to open access file "DATA" exclusively when I open "app1" and open it shared when I run...

Reply for the docman - it is not it I did not find any "running sum" when I tryed with report wizard. It has only summing for every row but I need values of records before actuall row to be added to the value of the actuall row - and I need that for every row. So, I don't need this...