Search results

Thanks @jwcolby54, I was basing my experience on the most recent .pdf on this post. I see a lot of references to GitHub but have not found a link to it. My humble feedback is the second e.g. insinuates that the code will run, & is detailed in it's step by step process. But there are no...

Thanks for the book @jwcolby54, enjoying it. Obv's in the interest of constructive feedback I'd agree with @Gasman here. Up to p28 & as @Gasman mentioned p27 says that we are able to step through & fire the after_update events; which of course we haven't hooked up the main frm yet... & are not...

Thanks Pete Thanks Pete

Thanks for this, I'm close to finishing Andrew Couch's 'Access 2010 VBA Programming Inside Out'; an excellent book! But I still have not fully grasped events fully as the e.g's in the book were hooked into native Access events. So I'm unclear if all clsEvents need to be hooked or they can be...

Thanks @Edgar, really helpful input. As there are so few items in HeaderTypesT & UnitsT & they will not change to minimize storage I avoided Autonumber & believe this is a rare exception. Cannot believe I did not think of this. I have spent 12 hours a day; over a week trying to recursively...

Sorry Pat, do you mean a subroutine/ function looping through with code?

Thanks Pete, not to hijack the thread & simplifying but in the interest of publicly shaming myself - I read it as being able to use a var to refer to a recordset - imagine you have several similar recordsets: r1 r2 r3... You want to save space in your code by avoiding huge blocks everywhere. So...

I'm trying to do the exact same thing. Was very clear in post-01 what you were after; dynamically creating a recordset, surprised at the confusion.

Wow what an awesome class. I'm just coming to the end of my first watch & had to say thanks.

No need for apologies, yes that's pretty much exactly what I'm doing. Thanks, yes that's why I want a deeper sense of sorting. Ideally relating to the inherent 'level' of each item. Thanks Pat, yes that's pretty much exactly what I'm after. A sort & group based on 'level type' sort of thing...

Another video; hopefully clearer. Ultimately the topic is creating the schema & queries to display a multi-level list. like in Microsoft Word. Tenders & all records will be copied as to avoid reinventing the wheel each time. @Pat Hartman - it sounds like I'm not massively wrong with the...

Thanks Pat, I always try to hit Like to show my appreciation to anyone who helps me. A belated response as googling BOM brought me no results so unsure what that BOM is & I struggle to convey what my issue is when i don't really know the subject; so appreciate i am unclear - apologies. You have...

Video linked for explanation. I have 7 different HeaderTypes. Which I need to be displayed in a continuous form; similar to grouping on a report. Do not be fooled by the apparent sorted order of the BillTemsF. It appears sorted because correctly because BillHeadersAndItemsT ID has been created...

External good sir.

Out of interest how long until a user can post links? I think it is a good measure & is required, quite frustrating sometimes, I'm 50 or so posts in & still unable to link :eek:.

I'm just a learner but I believe queries greatly outperform dLookup; especially as it scales. I think you'd be better off using an update query. I don't know much about them but I believe an update query will only save/ act on the fields in which it makes changes so be forewarned to save as a...

To state the obvs it' snot worth effort repairing an 8 year old machine & my experience of most repair shops have not been fruitful & my own endeavours to repair electronics have failed miserably most of the time with very few success'. BUT it's probably all about the challenge for you...

Thank you very much.

Thanks @cheekybuddha , very helpful. Believe me not wanting to run, just trying to grasp the basics but spinning out of control lol.

Thanks @cheekybuddha, it works in PostgreSQL - direct from tutorial mentioned in specific area of Multiple Rows & Multiple Fields area of subqueries Youtube techTFQ titled "Subquery in SQL | Complete SQL Subqueries Tutorial". Thanks for your input on the qry. I just cannot see how I can learn...