VB Error in Gross Payroll Counting, Error Message Real time Error 91 Object Variable or WTIH Block

When vb makes a reference to an object, if a new instance is not created, a with error occurs.

Your ** problem is estimated to be that the record in the database is empty, that is, there is no record, although you set the connection string, data source query conditions, but the query result is empty, so the result set is an empty object, and you refer to its method" Of course, this error will appear. Workaround:

1. Increase. 2. Determine whether it is an empty object before referencing.

3. Try adding a few records to the database.

Looked at your addition:

It should indeed be an error that the result set is empty, check whether your table name is correct, and change the table name to English if it is not possible.

Added: The error should be in your Chinese table name "Teacher Information Form". It is best not to use Chinese in SQL to make the program have good compatibility, and change the table name to English after trying, which should be solved. (just miswritten).

private sub form_load()= "provider=;data source=" + "Data Teacher Salary Management. mdb;persist security info=false" 'Set the database path.

select * from Teacher Information Sheet"

end sub

You deleted adodc1

Try again.

You don't need to change the other properties of adodc1 when you add it again.

Connect directly with **. The name of the Jianyi table was changed to English.

I have a simple database join in my space.

If you look at the commandType property of the adodc1 control, change it to 8.

object variable or with

The 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 set in the following **

statement, 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 the object.

This object is the correct object, but it is not set because in the object library, in.

References dialog box is not selected.

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 the with statement.

There is a problem with this sentence, it needs to be checked: set mrc = executesql(txtsql, msgtext).

The recordset is not open or closed, or is not delivered correctly.

dim mrc as

This sentence simply declares such an object, does not generate entities for this variable, and does not allocate memory space.

You can use implicit declarations.

dim mrc as new

Or display a statement.

dim mrc as

set mrc = new

Error 1: The position of for is incorrect.

Mistake 2: A sentence was dropped.

Error 3, the LIKE in the SQL language mining hole sentence must match % to make sense Error 4, there is a problem with the data number in the SQL statement, how can there be a space in the middle, it must be wrong.

modulus provider=; data source=;persist security info=false"

select the actual torque value from cheliang2 where data number like'%k & withering"

for k = 1 to 10

ri(k) ="Actual torque value").valuenext k

First, check whether the state of conn in ExecuteSQL has been opened normally.

Second: Please check whether the conectionstring can be connected to the database correctly.

Halo set mrc = executesql(txtsql, msgtext).

with msglist

rows = 1

end with 'Attention Here!'

Do while not debugging this line turns yellow, prompting a real-time error 91 The object variable or with block variable is not set.

rows = .rows + 1

Add before the sentence that started to make mistakes""with""In my experience, this error prompt is due to data controls not being used"refresh"caused.

Do you mean that this program prompts a "real-time error" when it runs? One of the most likely reasons is that there is no data in your database, and you make the pointer of the data control point to the last record (this will happen, test it with the F8 key to see if it is a problem with this sentence, and if so, then this is almost the reason). To solve the problem, it is very simple, just enter a few relevant records in the database.

The error of 91 is that the --object variable or with block variable is not set.

Are you not referencing database objects?

I don't know if it's if you're copying incomplete or if it's really a bug, the first line is missing a p

ublic rutype as integer

It should be. public rutype as integer