C
chuffy
Can i set a table field to gets its value from a public module variable in
access?
access?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Ofer
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
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
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"
function GetVar()
GetVar=MyPubVar
end function
and the SQL in a query
"Select *.MyTable, GetVar() as MyVar from MyTable"
C
chuffy
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"