Search results for query: *

I am connecting to a Access 2000 database using a ado control. As each form is loaded I make my connection programatically and the Close each connect as I leave. Private Sub Form_Load() Dim FileFinder As String XDrive = txtExternalDrive.Text F2 = "*.*" F3 =...

One thing I forgot to mention. To use this type of ado connection you will need to declare these variables either in an Public Module or on the form itselft. Remember to Close the ado connection when you finsh one task and then re-open it when you begin another. If not, you will encounter...

Continued: Using another form I again made an ado connection to the table of interest. Athough I am not sure how to send you the form itself, if you read down through this code you can see the various cmd buttons that I used to ADD, Delete, or Update new users. I know this is alot of code...

Here is some code where I use an ado programatic connection. As the form loads it connects to the database and table that I am interested in. In the "PRIVATE SUB cmdOK_click" you can see I used the "Find" method to search for a name in the "Administrators" table...

Static intBadLogins As Integer Static intBadLoginsPass As Integer Dim Find As String '//Find Administrator ID Dim Pass As String '//Find Administrator Password On Error GoTo ErrorNoLan Find = txtUserID.Text If Find = "" Then...