Search results

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

Think I've ran into another flaw between native SQL & Access SQL. Access will not allow Multiple Row & Multiple field subqueries. Reluctantly I may have to quit the native SQL tutorials on Youtube techTFQ as it seems near unrecognizable in Access. A multiple row, multiple column subquery seems...

Thanks people., much appreciated.

Thanks @plog, interesting that the prompt from Access is incorrect; should have warned me about the join statement not 'FROM clause'. Grateful for the input on Alias' shorthand only in FROM clause.

Thanks @The_Doc_Man, I do not blame you for not downloading. Pasting in Notepad & Word I can't see any unexpected phantoms. I didn't have a primary key in one of the four tbl's as one of the tbl's didn't have an obvious PK (not related to this query). Putting a PK in said table (unrelated to...

A brilliant SQL resource on Youtube tachTFQ (great teacher) - BUT exactly how different is native SQL compared to ACCESS SQL? Richard Prost does not indicate a great difference & I would have thought semantically it would be near identical. Seems to have different datatypes, ∴ data-sizes...