Search results

  1. A

    using input from combobox to decide which column to select in a query

    Thank you for your help. But I want the code in VBA that will help me execute the sql. The dynamic sql i can write and call it, say, s (as string). Now i am unable to run it through vba. I am only able to find codes on docmd (update, delete or make table queries).
  2. A

    using input from combobox to decide which column to select in a query

    That was my first thought. But the data cannot be managed like that (or it will include a lot more complications). If only I can figure out to run a select statement through VBA, this will be done. Can you help me with that code?
  3. A

    using input from combobox to decide which column to select in a query

    Hi, I have setup an Access database to run a report each month. However, the calculations are a little complex and will change with each month. What I have done is created a form which asks the user to put in the month number. So, now I have for example, two tables T1 and T2. Both of them...
Back
Top Bottom