Skip to content
Advertisement

No value given for one or more required parameters adodb access error

I am trying to assign archival id in my database to the corresponding file number column through an Excel userform. It should find the largest alphanumeric string in the column, and increment it by 1 and assign that in the archival id column. This is the VBA code for that:

I am getting error “No value given for one or more required” on the line:

This is what my database looks like: [![enter image description here][1]][1]

Please help [1]: https://i.stack.imgur.com/8baZa.png

Advertisement

Answer

You have an underscore in place of space:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement