Aaron,
Thanks for the detailed explanation. This is enough to get started.
Ranga,
There is something I don't understand. You now have quite a few clues and ideas, even full-blown code to work on and build into your own project. Yet, you just keep asking for more help and guidance. And your questions are far too general and hollow. I would expect specific questions on some part of the code or another, showing that you are involved and working on the problem. But I see hardly any sign that you made the effort to even understand what was freely given to you.
It was my understanding that you needed help with coding the JOIN part of the query builder. I provided just that, a working code to build a JOIN sequence of any number of tables. There was nothing special in the code, except maybe the logic behind it. With the coding skills you displayed in some of your attachments, it should be a childsplay to incorporate it into your project.
So why don't you get down to it? What is holding you back?
And what do you mean you've only coded macros in Excel. How could you develop those simple query builders you posted, without coding in Access?
Jimmy
Reply With Quote