Solved

Validate data in an inputbox

Posted on 2007-11-20
2
526 Views
Last Modified: 2013-11-27
I think I'm making this harder than what it is.
I would like to prompt the user for an integer that represents a month. Ex - 9 for September
and have some data validation. However, I seem to be caught in the if statement.

Suggestions are greatly appreciated.


Do
   
    Check = False
    
    If ReportMonthInt < 1 Or ReportMonthInt > 12 Then
    
     Check = True
     
     MsgBox "Please enter a valid integer value for a month between 1 and 12.", vbOKCancel
      If vbOKCancel = 2 Then
       Exit Sub
       End If
      
     ReportMonth = InputBox("Enter the numeric month to query?", "Report Month", DefaultMonth)
      If ReportMonth = "" Then
       Exit Sub
       End If
        
     Else: Check = False
     
    End If
   
 Loop While Check = True

Open in new window

0
Comment
Question by:TylerDerden
2 Comments
 
LVL 2

Accepted Solution

by:
geekspeaknow earned 250 total points
ID: 20321761
I would do this within the properties part of the combo box.  Right click on the combo box and go to Properties, go to the Data tab.  The 3rd choice of Row Source Type, pick Value List.  In Row Source, Type 1;2;3;4;5;6;7;8;9;10;11;12 (You would need code for a longer list, but this should work for what you need).  Then change the Limit To List box to Yes.  Let me know if this works for you.  Thanks!
0
 
LVL 10

Expert Comment

by:LennyGray
ID: 20322305
See the attachment
Public Function FigureTheMonth(sTheMonth As Variant)
Dim bStatus As Boolean
 
    
    Select Case CInt(nz(sTheMonth, 0))
        Case 1 To 12
            bStatus = True
        Case Else
            bStatus = False
    End Select
 
MsgBox "Status = " & bStatus
    
End Function

Open in new window

0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question