|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
May 19th, 2005, 12:17 AM
|
|||
|
|||
|
Help Please!!!
Hi I was wondering if anyone could tell me why my code doesn't work right. It goes straight to the Invalid Store Entry box.
Thanks for the help Select Case UCase(strStore) Case "All" qtbSales.CommandText = "SELECT * FROM 2002sales ORDER BY store, month" Case "Glen Park", "Jackson", "Warren" qtbSales.CommandText = "SELECT * FROM 2002sales WHERE store = '" _ & strStore & "' ORDER BY month" Case Else MsgBox prompt:="Invalid store entry", Buttons:=vbOKOnly + vbInformation Exit Sub End Select
|
|
#2
June 21st, 2005, 03:10 PM
|
|||
|
|||
|
re
Put a breakpoint on the "Select Case UCase(strStore). Make sure that you are going to that function/routine correctly, and everything is going as planned.
|
|
| Viewing: Dev Articles Community Forums > Databases > Database Development > Help Please!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
