Search results

  1. T

    Solved Need help with IF AND OR function

    I have following IF function in Macro (Field3 is text field): IF [Field01]=1 And [Field2]=0 And [Field3]="12" Question: [Field3] has 3 valid values: "12" or "1" or "2" I have tried this in function, but did'n work correctly: IF [Field01]=1 And [Field2]=0 And [Field3]="12" Or [Field3]="1" Or...
  2. T

    How to save Unbound field data to specific txt-file?

    Hello, I have kinda log-in form where is unbound field (LoginUserName). If access is granted I need macro(?) to save that LoginUserName in to local drive (C:\Users\ActiveUser.txt) file, as Access is reading that file data later. This ActiveUser.txt file has only one line of text (6 characters)...
  3. T

    Question Formating Currency to plain numbers?

    Hello PRO's, How to format to get results I want from Currency field? I need with leading zeros and without cent separator total of 8 digits: [CurrencyField] -> What I want to see on separate (unbound) text box: 15,29 € -> 00001529 1458,80 € -> 00145880 etc.? I have tried...
Top Bottom