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!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Access VB code, how can I prompt the user to enter text?

Status
Not open for further replies.

F15

Programmer
Nov 21, 2002
7
US
Using Access VB code, I would like to prompt the user to enter a number string which I will use several ways. First, I will use that string to delete any records matching the string, and then locate a file to import new data. What is the VB code to create the user interface box and how do I capture what the user has typed?
 
First, you have to decide if it's numeric or string.

Assuming it's text, do this:

Function RespondToMe()
Dim strResponse As String

strResponse = InputBox("Enter the string.")
MsgBox strResponse

End Function

The message box is just there to hold the place of what you'll do with the response.

jeremy
=============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

Take a look at the Developer's section of the site for some helpful fundamentals.
 
Thank you very much. I figured that it should be quite simple but I just couldn't find it in my reference material. I really appreciate your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top