Recent content by cardonas

  1. C

    Forgot access database password

    Ah! I see . I did try and to recover through the several different programs but nothing . Good news is I have a back up unlocked :). I really do appreciates the help and education . Thank you !
  2. C

    Forgot access database password

    I have a access database that I password protected it and now I can not remember the password. Is there a way to recover the password I need to open the DB or then I have to rebuild . Its NOT a file its a Database I have to recover the Password everything online gives me code to unlock an access...
  3. C

    Conditional formatting and If statements in user form

    Thanks !! for your help and that is alot cleaner then mine
  4. C

    Conditional formatting and If statements in user form

    Ah, thanks not sure what that is since I am a newbie but thanks any shortcuts are much appreciated.
  5. C

    Conditional formatting and If statements in user form

    Just a quick update I used VBA instead and drop the code in the Afterupdate event in the [termdate] field below is my code in case anyone has the same issue I did and I used Conditional formatting to change the color Private Sub Term_Date_AfterUpdate() If Me.Term_Date = " " Then Me.Job_Status...
  6. C

    IF Then Else VBA Access form

    Wozzers!!!! YOU'RE:D THE BEST !!! Thank you so much !! I did not know that and my code work !!!! Thank you again!!
  7. C

    IF Then Else VBA Access form

    I moved the code on over to the [TERMDATE] Field and now I get an error when I debugg on the IS NULL part of the code. Also I am a NEWBIE at this. Private Sub Term_Date_AfterUpdate() If Me.Term_Date = " " Then Me.Job_Status = "Active" ElseIf Me.Term_Date Is Null Then Me.Job_Status =...
  8. C

    IF Then Else VBA Access form

    I have two fields in Access form one is [Job Status] and [Term date] I am trying to have a word populate in [job status] based off of what the [term date] field here is my logic is this If [Term date] is " " or IS NULL I want the word "Active" to populate in the [jobstatus] field Else if not...
  9. C

    Conditional formatting and If statements in user form

    Thank you thats where I had it but then the field does not feed into the backend table in access.
  10. C

    Conditional formatting and If statements in user form

    My issue is I am not sure where to put the IIF statement on my user form ??
  11. C

    Conditional formatting and If statements in user form

    Hello everybody, I am trying to do an IIF statement in my user form in access I have a field [Job Status] and I have a [Termdate] field I want a "String of text" to pop up in my [Jobstatuts] field base off of what the [Termdate] field has. Heres my IIF statement =IIf(([Term Date]=" " Or...
  12. C

    IIF statment criteria Numeric

    Thank you guys so much!! I had no idea it could not be both good to know and thanks again :) I did what you guys suggested and it work!!! now I can get my scorecard in yay!!!
  13. C

    IIF statment criteria Numeric

    Hello Everybody, I did several different IF statements in access and they work perfectly! But as soon as I got to my last if statement it query on a field that can a numeric or just null or " ".:confused: I wrote the IF statement below and it seems to work perfectly if I take out the "GREATER...
  14. C

    If statements in access NESTED

    PLOG!! YOU'RE:D THE BEST!!! I followed your logic and it work !! Thank you again!!
  15. C

    If statements in access NESTED

    Ah!! Thank you Plog I just realize the query runs but now I am getting (-1) as a result in my column?? So looks like the IIF:( statements are not working...
See more
Back
Top Bottom