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 derfloh 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
Joined
Jun 21, 2005
Messages
58
Location
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 Question
Publisher Automation from Access Frustration
Replies
3
Views
4K
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Converting from 32bit to 64 bit. After converting, database takes significantly longer to open
Replies
14
Views
3K
dhookom
dhookom
Moss100
  • Locked
  • Question Question
Vba code I can call from a query to reformat text
Replies
8
Views
909
Moss100
Moss100
Moss100
  • Locked
  • Question Question
Remove everything including the comma from the last comma of a string.
Replies
10
Views
2K
Andrzejek
Andrzejek
Zyborg
  • Locked
  • Question Question
Using a variable as reference to a form
Replies
5
Views
1K
Zyborg
Zyborg

Part and Inventory Search

Sponsor

Back
Top