Search results

  1. M

    DoCmd.OpenReport (Where condition with array)

    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...
  2. M

    DoCmd.OpenReport (Where condition with array)

    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.
  3. M

    Hi from Switzerland

    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...
  4. M

    DoCmd.OpenReport (Where condition with array)

    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...
Top Bottom