Download VB code, run with the original data is no problem, but after replacing the ACCESS data, display the EOF, the problem of BOF, (after replacing data also retained the original file name, data length is more short)
Can you tell me how to solve

CodePudding user response:

Step through the VB code,

CodePudding user response:

Teach you a recruit:
The manual open Access data table, add a record.
Then try to run the program

CodePudding user response:

The original code may has bugs in record loop or migration,

CodePudding user response:

See another post reply,

CodePudding user response:

Should be the original database and the code or related fuzzier, suggest check the variable definition

CodePudding user response:

Because after you update the database, the original generation the Where clause of the query may have an empty record set, and you then code MoveFirst error,

Remove the MoveFirst, because after the search, if there is a record, record set pointer is on the first record, it is superfluous, will go wrong when there is no record,

CodePudding user response:

Should be the record of your access to find it empty