Runtime error '424'

[cid]

Object Required:
It has a problem with this code:

cn.ConnectionString = sConnectString

Downoad my zipped project for full details. For the error look at form4. Log in as default with no password. The goto file, Add Lunch Detentions. Then that will take you to form4. Try to seaarch for an ID Number and you will get my error.
Thank you for all of the help...

[Bruce Fox]

I think you forgot to post your Zip!



Bruce.

[cid]

zip

[Bruce Fox]

A couple of points (not neccessararly to fix your bug, however):

1. I didn't find a Reference to MS ActiveX Data Objects (ADO) Library

2. Use 'Option Explicit' at the top of ALL Forms/Modules (this will help pick up undefined variables etc)

3. Dim chk, chks, k, temp, lin, emp As String
(Currently chk, chks, k ... will be defined as Variant Data Types)

Should be:
Dim chk As String, chks As String, k As String, temp As String, lin As String, emp As String



Bruce.

[cid]

So you have nothing on my error. Will you please look at my search code on form4. If you can fix it or tell me what to do it would be a great help.

[Bruce Fox]

See note 1 above!