Search results

  1. A

    sql sum as variable - how to?

    hello, i am trying to get a sum of specified fields as a variable. i tried to do that this way: Dim db As DAO.Database Set db = CurrentDb Dim rst_tmp As DAO.Recordset Set rst_tmp = db.OpenRecordset("SELECT field FROM table WHERE field=(SELECT SUM(field) FROM table HAVING condition_a='a' AND...
  2. A

    how to get a value from combobox

    Ok. this is a stupid question, but i am in a hurry and new to vba programming. I need to collect two parameters into my vba code-wanted to do it with dialog box, but thought that getting value from a form would be better - and this is the question, how do i access the value of combobox in any form?
Back
Top Bottom