Search:

It would appear that I would give adequate information, I want the ListView or ListBox to be on a separate form so that when a user selects a field in the ListView or ListBox it populates the text...

Thank you will try it and give feedback tomorrow.

Hi again folks

I was wondering how do I import custom controls from a sample project and use them in my project?

Good Day Folks
I have a form which searches the database for student info and displays it one student at a time on the form, the form only has 3 text boxes, txtIdNumber, txtFName and txtLName. Now I...

Thank you, I will try it tonite and let you know how it works.

The project is about 9 MB compressed, I am editing someone else project cause it comes with all these cool custom controls, is there anyway I can send it to you.
The numbers have no decimal places,...

Yes it is a number, yet for some reason if I don't put the single quotes around it it doesn't work, I use the numbers 10 - 30, so it contained any number in that range, yet most likely it contained...

IDNumber is Number


Dim searchText As String
searchText = InputBox("Please Enter The Student ID To Search For")

I replaced the original cmdSearch with this and it works:


Dim BookMark1 As Variant
'Mark your place in case no match is found
BookMark1 = Rs.Bookmark
'Move to top of table to...

The old project does include the ADO references, but the new one doesn't, so I added it to the new one and still no luck. The error always points to this line Rs.Open strSQL, cn, adOpenKeyset,...

Option Explicit
Private cn As ADODB.Connection 'this is the connection object
Private Rs As ADODB.Recordset 'this is the recordset object

I still get the same error, the older project has its...

My apologies for reviving this yet I need to know, say I already have a main form on my application and I want to set it up so that, the login form runs first, then if validated launches my main form...

Good day against folks. I have managed to create a project with only two forms and it works quiet fine. Now I have an older project which I want to add the new form to, so I go to my old project and...

Thank you it works, I just realised how easy it is to assign the criteria to a variable:


Dim strSQL As String
Dim searchText As String
searchText = txtSearch.Text

strSQL = "SELECT * FROM...

Good day folks, I have been following the ADO tutorial and I have come up against a problem. This code works:


strSQL = "SELECT * FROM Students"
If txtSearch.Text <> "" Then
strSQL...