Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

return value from a select value into code

Status
Not open for further replies.
jmob

jmob

Programmer
Jun 21, 2005
58
US
I'm trying to return a value from a select statement into my code to use.
Something like Dim String as runSql(Select ..) ??? I couldnt' find what I was looking for. Any help or references would be appriciated. Thanks.
 
Sort by date Sort by votes
Use DLookup instead


The early bird gets the worm, but the second mouse gets the cheese.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
3K
dhookom
dhookom
breezett93
  • Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open 1
Replies
14
Views
569
dhookom
dhookom
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
501
Moss100
Moss100
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
918
Andrzejek
Andrzejek
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
616
Zyborg
Zyborg

Part and Inventory Search

Sponsor

Back
Top