G Guest Apr 12, 2005 #1 Can i set a table field to gets its value from a public module variable in access?
O Ofer Apr 12, 2005 #2 You can create a query that include all the fields from the table + another field that based on a function that return tha value of the variable. "Select *.MyTable, GetVar() as MyVar from MyTable" function GetVar() GetVar=MyPubVar end function
You can create a query that include all the fields from the table + another field that based on a function that return tha value of the variable. "Select *.MyTable, GetVar() as MyVar from MyTable" function GetVar() GetVar=MyPubVar end function
O Ofer Apr 13, 2005 #3 The function is created in a module function GetVar() GetVar=MyPubVar end function and the SQL in a query "Select *.MyTable, GetVar() as MyVar from MyTable"
The function is created in a module function GetVar() GetVar=MyPubVar end function and the SQL in a query "Select *.MyTable, GetVar() as MyVar from MyTable"
G Guest Apr 15, 2005 #4 still can't get it work Ofer said: The function is created in a module function GetVar() GetVar=MyPubVar end function and the SQL in a query "Select *.MyTable, GetVar() as MyVar from MyTable" Click to expand...
still can't get it work Ofer said: The function is created in a module function GetVar() GetVar=MyPubVar end function and the SQL in a query "Select *.MyTable, GetVar() as MyVar from MyTable" Click to expand...
