Search results

Sure, but as queries go it isn't that bad a query & quite a simple one. He certainly shouldn't be using a union query for the reasons mentioned & you've kindly indicated an elegant solution with logic he can follow in a simple standardized query; not even a sub-query... A few mere lines. :love...

Wherever possible avoid a union query & go via CheekyBuddha's logic. If you used a union query you would be loosing the ability to edit data later. You'd likely reference this query in different applications throughout your application only with diminished functionality (in not being able to...

Thanks John, very helpful. I was worried I'd have to convert all my recordsets to ADODB, but judging from your code that doesn't appear so :love:.

Do you have any advice to share? I'm considering Azure but I am terrified. This is concerning, is a Windows user account authentication safer?

I agree, I'm surprised that the consensus is to post a new thread, on the same subject; leading to superfluity & detriment to Search Engine Results Page (SERP) for users. Millions of results for the same topic, opposed to a single answer with high-calibre solutions.

It wouldn't it's just a heads up as it was such an inadequate OP & I have much of my own work to do was just trying to be helpful is all shooting back a quick response for you to investigate further incase you were under pressure is all. Trying to give back to the forum which has helped me so...

With Me![sfrmPosLineDetails Subform].Form.RecordsetClone This is sinister. You're opening the recordset with the option as dbOpenDynaset or dbOpenTable right? Not recordset clone, as that will not allow an edit/ save changes. Requery your form or your form's recordset after the update. If you...

I am guilty of this.

Thanks Colin, be interesting to see what happens. If it is bad practice (which is a very good chance) I pray I'm able to find the problem :eek:.

Reassuring & both terrifying in a single word :ROFLMAO:.

Thanks so much Colin, immediate fix; so grateful. I wonder what caused that. Is this type of thing usually caused by bad practice or can I rest assured that it's usually some sort of corruption which has now been rectified in decompiling?

I have Option Explicit & Option Compare in ALL code behind forms, modules & classes. But I receive no highlighted prompt where the error occurs. I thought I'd solved it a week ago but I keep receiving it on compiling. Pretty sure it's not reference related as I've not changed anything there...

Thanks isladogs, yeah I know what's going on. He got it to me real quick & is just to show how to hook the key-combination. I've got lots of other stuff going on & handling the deletion through my procedures. I never stipulated any of that. Thankfully Arnel used his intuition on creating a...

Yeah that's what Arnel did with the class; works great; I'm very grateful.

My thoughts exactly, as per OP it seemed that KeyUp provides a more generous time constraint & I got slightly better results; albeit not good results & spent all afternoon/ eve & most of this morning. Thank god Arnel saved me. Thanks Colin, at least it's a little reassuring that you also had...

Thanks, I do agree on a later test I got 46 for del key. But I tested countless times prior & got 42 for the delete key. Really strange, print is quite a different place on my keyboard so I'm pretty sure I wasn't mis-keying, really strange. I'd be thinking the same if I was reading this; donkey...

Thanks Arnel

Thanks, agreed but still yeilds no result sadly, mystified as to why the combination (not event) is not detected. Even if I nest the If's despite Keycode being 42 (well at least in my tests) does not catch: Private Sub Form_KeyUp(KeyCode As Integer, Shift As Integer) MsgBox "keycode: " &...

Thanks, I can't seem to detect it. Sure it detects the event firing, as it did without the parent having it's Key Preview property = True, & without the duplicate procedure (actually I didn't even have a subform in there; you kindly assumed correctly so thanks). But it does not detect the...

Thanks Arnel, I didn't have property set in parent frm, regardless the event was still firing but the multi-key combination not detected. I still cannot detect the multi-key combination. Maybe because the record is going in edit mode with depressed keys (pencil is indicated in selector).