Recent content by alexcarter404

  1. A

    Access to SQL Server encryption

    Hi All, I have an access database recently ported to SQL server which is working perfectly. Just have one problem which is encryption. Basically what I would like to do is either encrypt a whole table or a whole database or just several fields in a table, whichever is easiest. I know there are...
  2. A

    Apply IF statement to each record in detail of subform on load

    Hi Paul, Thanks very much! worked like a charm! I used the expression is and put [status] = "CONFIRMED". Cheers, Alex
  3. A

    Apply IF statement to each record in detail of subform on load

    Hi Paul, Thanks for your reply, unfortunately I cannot use conditional formatting as I can only apply the formatting to the cell which has the value, you cannot format another field depending on another fields value. Cheers, Alex
  4. A

    Apply IF statement to each record in detail of subform on load

    Hi All, Used to have an account on here but seem to have lost access to that, but anyway Hello and my name is Alex! The problem I am facing is applying an IF statement to every record in the detail section of the subform. I have the following code: If Me.status = "CONFIRMED" Then...
Top Bottom