var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am new to Access and am trying programatically to access the results of a query I defined in the query builder for Access. I have the query built and it works, but how can I grab the results into variable that I can use in the code.
your query returns a set of records --- a "recordset"
try searching this forum or your access help system (if it works!!!) for "recordset".
for a simple example (including me bumbling about fixing blindingly stupid errors) see
you would need to substitute the name of your canned query along the lines of:
set reci = dabs.openrecordset("NameOfMyCannedQuery")
Last edited by izyrider; 04-28-03 at 14:40.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors