Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. C

    If statements in access NESTED

    I am new to access and I am trying to combined two IF statements I tried them below in access query and they work separately but when I put them together the query doesn’t run I am not sure why? Any help would greatly be appreciated The statements below work perfectly separate but I want to put...
Back
Top Bottom