|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 13th, 2003, 08:32 AM
|
|||
|
|||
Checking & Comparing Values
I'm using Microsoft Access but I need help with some of the VB programming code. I have a form that the user enters a last name, phone number, and password. (Then they click the cmdEnter button.)
Under the Private Sub for the cmdEnter_Click (I'm guessing that's where it should go) I want the program to go to the customer table (the fields in that table are Last_Name, EmployeeID, and Password) and to check and make sure the variables they entered match up with a row in the customer table. If it does, another form opens (I have the code for that already). If it doesn't match, this label will appear: (lblSomething.Visible = True) to let them know they need to re-renter. I really need help with this so thanks in advance to anyone who helps get me on the right track!!!! 
|
|
#2
August 13th, 2003, 10:35 AM
|
|||
|
|||
|
do you know how to connect to a database? get a recordset? do you know any SQL?
__________________
Programmer's Corner
|
|
#3
August 13th, 2003, 01:13 PM
|
|||
|
|||
|
I can connect to a database through the ADO method. I know a little SQL - unfortunately the stuff I use isn't formatted quite right for Access.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Checking & Comparing Values |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
