Trouble with InputBoxes

by

Here is a way to catch most outcomes of interacting with the dialog;

Dim value As String
value = InputBox("Please enter a #", "Determine Limit", 10000)

If (StrPtr(value) = 0) Then
    MsgBox "You pressed cancel or [X]"

ElseIf (value = "") Then
    MsgBox "You did not enter anything"

ElseIf (Val(value) = 0 And value <> "0") Then
    MsgBox "Invalid number"

Else
    MsgBox "You entered " & value

End If

More Related Contents:

  1. ms access vba code for update records through form
  2. How does one decompile and recompile a database application?
  3. What are the rules governing usage of parenthesis in VBA function calls?
  4. Autonumber value of last inserted row – MS Access / VBA
  5. Code to loop through all records in MS Access
  6. Bang Notation and Dot Notation in VBA and MS-Access
  7. How do I force VBA/Access to require variables to be defined?
  8. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  9. How to diagnose MS access crashes
  10. Is it better to use ADO or DAO in Access 2007?
  11. How do I access the selected rows in Access?
  12. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  13. Insert SQL command with Datetime in MS-Access
  14. Prevent enabling of shift bypass – Access 2010
  15. Access 2007 – Left Join to a query returns #Error instead of Null
  16. Save password for ODBC connection to MS SQL server from MS Access 2007
  17. How to loop through all controls in a form, including controls in a subform – Access 2007
  18. how to show query results in a datasheet in the same form?
  19. Access VBA: Find max number in column and add 1
  20. MS Access prepared statements
  21. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  22. Create sequential ID value based on the year that a record is added
  23. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  24. Null values for variables in VBA
  25. SendKeys is messing with my NumLock key via VBA code in Access form
  26. Using a centralized VBA module in multiple Access databases
  27. How to execute a query in ms-access in VBA code?
  28. How to add a menu item to the default right click context menu
  29. VBA – Run Time Error 3271 using DAO object
  30. Get Name of Current VBA Function

Leave a Comment