Hi I have a database of one table with headings as shown

DONOR COURSE TITLE START DATE END DATE MIN/DEPT ANNOUNCED TO DATE RECEIVED BY HRD DONOR DEADLINE DATE FORWARDED NOMINEES BENEFICIARIES-MALE BENEFICIARIES-FEMALE NUMBER ACCEPTED REASONS FOR NON-ACCEPTANCE DATE OF ENTRY NATIONAL COUNTY

The table is in access. I would like to have a search function that is able to give me results of one or more of the headings.

Recommended Answers

All 2 Replies

Please post the code that you are working on.

You'll have to set up your program to use Active X Data Objects (ADO) : usually Microsoft Active X Data 2.X. You can use Data Access Objects (DAO). But ADO is more up to date. Not as fast. But more up to date. Do this in the References section of your IDE.

Then you have to declare and instantiate your Data Objects,

Dim rst as Recordset
Dim cn as Connection

'
Private Sub Form_Load()
     Dim strSequel as String
     ' Instantiate your objects
     strSequel = "Select TableName.Donor, TableName.Course FROM TableName WHERE TableName.Donor = 'George';"
     Set rst = new Recordset
     Set cn = New Connection

     With cn
          .Provider = "Name of your Data Provider"
          .Open   ' Fill in appropriate Values
     End With
     rst.Open "c:\Database Name.mdb", strSequel, "etc"       ' Fill in appropriate values.

End Sub
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.