Used your link and some code I found to create a working version:
function to determine if a string is "valid"
Function ValidateNumber(tempVal As String) As Boolean
Dim result As Boolean
tempVal2 = Replace(tempVal, ",", "")
If (Not IsNumeric(tempVal2) And (tempVal <> "")) Then...
Been thinking about at multiselect listbox as well but I have 400, maybe 500 differents IDs so I thought a MsgBox might be the way to go ... but yeah you're right: Never rely on a user input.
Gonna try your idea first as it might be the better way.
Hi there,
well I don't use Access a lot but since I am the only one in our office who is at least a bit into VBA I have to create some smaller Tools until we get our new ERP (might be 2022 or even later :rolleyes:)
There will be some questions I have to ask because I don't use VBA that much...
Hi,
I have to create a simple report (multiple smaller cards per sheet -- see the picture attached -- red circle represents the next record)
but I'm struggling to implement a good way to create more than one report per button click.
My idea is to open a MsgBox, the user can enter some integer...