Search results

Hey thanks a lot The_Doc_Man, I seem to obviously lack some more conceptual background - which doesnt surprise me as my vba knowledge is more or less a collection of bits and pieces found by google or in forums - tied together until it gave me a result :) Im always happy to get some critics, as...

Thanks a lot for the further explanation. I think I understand the queries now much better. :)

Okay Thanks a lot. At the moment I am not 100% sure what you mean, but I realized I should read a bit more on the functioning of Currentdb.QueryDefs. Thanks and have a great day.

Hi thanks for you reply? Do you mean like that: Set vba_query = db.OpenRecordset("SELECT " & col_var & ".A FROM " & table_var & " WHERE " & table_var & ".B=2") ? This would actually work for the simple example i have drawn to illustrate the issue, but would not be applicable for the problem...

Hi Uncle Gizmo, thanks for your reply - ok let me draw an example. In MS Access (outside of the VBA world) - would create and save down two queries: Query1: SELECT A,B FROM Table1 WHERE A=1 (save this query as Object Query1) Query1: SELECT Query1.A FROM Query1 WHERE Query1.B=2 (ok, I...

Hi, so far I preferred to use separate (non VBA) SQL queries instead of huge nested queries. (except for Joins, or simpler WHERE IN statements) Not only do I think nested queries with more than two tables are hard to understand (after a while) I also had problems when I use them...