• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Access

A

Abhinav Shori

Member
I have:
strSQL = "select strAnalystName from Analyst where strSystemName=""" & GetNetUser() & """;"

in access... getnetuser() is a function to get username, I can use Environ$ as well.

the result of the above query should be 1 column.

How would I display it in a msgbox?
if there are more than 1 rows, how would I refer to the each element?

Thanks in advance.
 
Abhinav

Have you considered that this is an Excel centric web site and forum

You will have a lot more success asking this question in an Access site

In regards to your question, If the query returns an Array of results which i assume it will why load it into a Text Box

Why not load it into a ListBox or ComboBox?
 
You must log in or register to reply here.
Back
Top