How do I extract the value of Computer Description for use in a variable?

Posted on 2008-11-12
Last Modified: 2012-08-13
I was hoping to use Environ("Username") to extract a name that I could use in VBA generated messages but the value is not consistently used to name the user accross all computers on the network. However the value that is of use is that of Computer Descriptions (Control Panel>System in the Computer Name tab). I am therefore looking for a way of either changing the value of Environ("Username")  (without affecting the user's network access) or how do I read in the value of Computer Description into my VBA? Can anyone help me?
Question by:Rob4077
    LVL 8

    Accepted Solution

    computer description is stored in the following registry key
    simpelst way to read the registry is using the windows scription host see

    Author Comment

    Thank you very much. That appears to do the trick!

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    755 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

    25 Experts available now in Live!

    Get 1:1 Help Now