Hello everyone, this is my first post. I had a little programming background, but as of recently my boss is teaching me how to create Access and VB applications. Its been quite a learning experience!!
Ok heres my issue. I created an application that generates tags for stock. I start the first number with 1111, when a button is pushed it creates a new tag with 1112 and so on. I need to add WA to the beginning of the numbers. I created a function for this, and here is the code:
Public Function Generate_Number_Click()
'Create Washer Serial Number
Dim lngsnum As Long
lngsnum = DMax("[WAS]", "table1")
lngsnum = lngsnum + 1
wastxt = "WA" & lngsnum
End Function
It clearly did now like when I added "WA", as I keep getting a mismatch error. I was hoping it would be that easy, but I guess not.