var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Storing Query Result in a VBA Var
I have a query with only one field, one result that I want to stare in a VBA var.
It seems like this should be a piece of cake right?
Sounds like DLookup() might be in order...
you can do it quite easily from vba.
dim strSQL,text_var as string
dim db as database, rs as recordset
strSQL = " Select * from Table1;"
set db = currentdb()
set rs = db.OpenRecordSet(strSQL)
do until rs.eof
text_var = rs!field1
'execute whatever code you want here.