VB, always real time error 91, what to do, urgent!

The object variable or with block variable is not set (Error 91).

There are two steps to creating an object variable. First, you must first declare an object variable. The object variable must then be assigned a correct reference using a set statement.

Again, with....The end with block must first be initialized with the with statement entry point. There are the following causes and workarounds for this error:

The object variable you are trying to use has not been assigned with a reference to the correct object.

Specify or reassign a reference to an object variable. For example, if you omit the set statement in the following **, then referencing myobject will produce an error:

dim myobject as object 'Create an object variable.

set myobject = sheets(1) 'Create a correct object reference.

mycount = 'The count value is assigned to mycount.

The object variable you are trying to use has been set to nothing.

set myobject = nothing 'Dispose of this object.

mycount = 'A freed object is referenced.

Then specify the reference to the object variable. For example, use a new set statement to set a new reference to an object.

This object is the correct object, but it is not set because it is not selected in the References dialog box in the object library.

In the Add Reference dialog box, select an object library.

The whereabouts of the goto statement inside the with block.

Don't jump into the with block. Make sure the block uses the with statement entry point to perform initialization.

When the Set Next Statement command is selected, a line is specified within the with block.

The with block must be initialized with a with statement.

Not a data type.

Delete this sentence and see if it is displayed in text1 to know whether the database is connected or not, if not, connect the database first, and then add this sentence and then test.

Check whether the database is connected and whether the data table is opened.

To access the database, use adodb

I have a wrapped class here.

**Please take a screenshot of the content.

It should be that the database is not connected, or the **format is wrong.

The previous sentence does not return an object, first check whether the strsql string is correctly solved, and add a sentence strsql in front of it to see if there is an error.

Check whether ExecuteSQL (strsql) is executed correctly.

dim t as data 'Maybe it's a mistake here, it's dim t as date. There are other data that need to be changed.

It's wrong here, data is a database access object of the god, so it will prompt that there is no source of annihilation and there is an object crack.

Is the initial one empty? Take an empty string to run the error caused by cdate, right?

The adodc control doesn't load any dataset objects, you close it, of course, something went wrong, and it's related to the opening.

This error indicates that your database is not connected properly. Use breakpoint debugging to see if there is a problem with the connection. After connecting, you can addnew in the record set.,Also,See if you need to update it after addnew.。

Using the data control?

You need to associate the database first, so that the recorset object contained in the data control can be initialized correctly, and then you can add the record (addnew) normally, otherwise you need to add the data to **?

Set the database property (database file) and recordsource property (table name) of the data control

The data1 object is not created to be new.

You shouldn't have set the RecordSource or RecordSet attributes, but you should have to select a table in the database for it in addition to the join.

It seems like the recordset variable is not defined.

Your strsql variable doesn't have a SQL statement assigned!