[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 677
  • Last Modified:

Access Message Box using dlookup

Hate to seem like I'm slacking on reasching end, but I'm looking for a function what would display a tabel value using a message box. I have a table called, tlbVerisonServer and with column called "VersionNumber" (numeric value).

I just want a fucntion that would procdure a message that says, "Current database version is "Version Number" (the actually table value"). I really don't hate to ask someone to do all the work, but I'm curious to see how setup would be. I want to do some things in my database for learning and testing purposes.

Thanks  
0
Buckeye4Life
Asked:
Buckeye4Life
1 Solution
 
Rey Obrero (Capricorn1)Commented:

i don't know where you want to call the message box, but here it is


msgbox "Current database version is " & Dlookup("VersionNumber","tlbVerisonServer")
0
 
Buckeye4LifeAuthor Commented:
Thank You. I was thinking I would have to open a recordset and everything.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now