here is the offfending code.
Code:
Private Sub loginbutton_Click() Dim rs As Recordset Dim db As Database Set db = CurrentDb Dim searchstr
4 results in 0.0014 seconds.
-
something resetting status of select case or multi-line if statements
I have an odd situtation where a section of code is resetting the status of either multi line If statments which then gives me the error " end if without block if" or something very similure, or select case where it's giving me " Case without Select case"
here is the offfending code.
... -
Nested IIF Statement (and Select Case) with Date Ranges
Hello all:
I'm having trouble with a nested If Statement working properly. I'm working in MS Access 2002 (OS Windows XP, ver 2002). The non-working code is going on the Form (a Single) as follows:
...Code:Dim Effective_Date As Date If Me.Effective_Date >= 1/1/10 And Me.Effective_Date <= 12/31/10 Then [Prem/Ops Manual XS 1] = ([Prem/Ops U/L Manual 1] * 0.09) [Prem/Ops Umbrella Prem 1] = [Prem/Ops Manual XS -
Multiple condition trigger
I need help with a multiple condition trigger. I saw a post on Dec '06 and coded my trigger like that one but it still doesn't work. I am using DB2 V9 on z/OS.
CREATE TRIGGER DB2DBA.DSOPTCR5
NO CASCADE BEFORE INSERT ON MAD.DSOPTCT
REFERENCING NEW AS N
FOR EACH ROW MODE DB2SQL
SELECT CASE WHEN N.CNSTRNT_TO_TY PE_CD = 'C'
... -
Select Case Statement with Multiple Expressions
Does anyone know if it is possible and the syntax to test mutlitple expressions in a select case statement? This is the best I could come up with but it doesn't appear to be working
Example:
Code:Select Case rng1.value And rng2.value Case rng1.value = 1 & rng2.value = 2 'code here case rng1.value = 2 & rng.value = 2 'code here End Select
