Access Message Box using dlookup

Posted on 2008-11-11
Last Modified: 2012-05-05
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.

Question by:Buckeye4Life
    LVL 119

    Accepted Solution


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

    msgbox "Current database version is " & Dlookup("VersionNumber","tlbVerisonServer")

    Author Closing Comment

    Thank You. I was thinking I would have to open a recordset and everything.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now