update VBA from query

  • Thread starter trevorC via AccessMonster.com
  • Start date
T

trevorC via AccessMonster.com

Hi all,

Is it possible to update a vba code variable from a query called from the VBA
code.

EG
docmd.openquery "testquery" ' has one filed that returns a number
get returned value from query to use here
T = return from query

If so how do do this.

regards
Trevor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
How to Change criteria on a saved query using VBA 0
Display weeks from a Milestone 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Running parameter queries from VBA, suppressing parameter prompts 5
update tables by VBA 1
Problem with SET & REF function 0
VBA Export to PDF 0

Top