Recent content by surferdude800

So, update on what i'm doing. I found out that it is the Q in my serial that causing the issue. But thank you guys for your help.

How would you suggest fixing it?

Thank you vbaInet and jdraw. I did see that re post before, but I didn't manage to fix anything using the suggestions I saw. I will look again and see if I find anything. Any tips on better programming this are appreciated. This database is a serial number database for the company I work...

Sorry, please disregard my previous post. I had to rebuild my database and it didn't have any previous serial numbers to get to increase the increment. That why it was a null value. For for the Read only error I got: Run-time error '3027': Connot update. Database or object is read-only...

Run-Time error '94' Invalid use of Null

Somewhere in these two lines is my issue. I think because its a text field and then I'm doing a string & number mix into a string. That's causing this issue.

Hello, I'm having an issue with the database being read only and a type mismatch due to OpenRecordset. I know this database use to work when it when it was just CurrentSerNum = RecSet(0) +1 was doing the incrementing. I need the database to increment in a different way now. Q=manufacture...