Search results

Thanks Colin, was in no way meant to be a dig; but a token of gratitude for the valuable lessons on your site, & as stated in tutorials they were all designed to be solvable. Very grateful for the info.

Thanks @Minty, good news that SQL Queries are more powerful as I'm working on a bit of a pig at the moment. I'm not sure if I should try to upload to Azure & see how i go from there. I imagine this will slow me down massively as I'm so new to it & learning Access was hard enough (still know very...

Can anyone recommend a good book exposing common pitfalls...? I'm a complete novice in both Access & Azure. Seems that using an ODBC connection in MS Access exposes passwords... in the registry.... Also as I still have not finished my application which I am planning to sell as an .accde & Azure...

Agree completely, I'm very grateful for the help & guidance Pat gave me & time taken from her day to generously explain things I could not have understood without her. I cannot count how many times I fail to understand something & load my old threads to rediscover the answer. Now a considerable...

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...