Recent content by bffluv

  1. B

    Confirmation Message OnClick SaveRecord

    Yes, Yes, Yes... it works, Thank you so much...
  2. B

    Confirmation Message OnClick SaveRecord

    Hello AccessWorld Family, I need your help :banghead: I created a SaveRecord button using the wizard. Currently, the SaveRecord do not notify the user that the record was actually saved in the table. Upon clicking the SaveRecord button, I want a confirmation message that tells the user “Record...
  3. B

    Hide the Navigation Pane in Access Form

    I am about to push my Form from development to the test environment. How do I hide the Navigation Pane (All Access Objects) from users? All they need to see is the switchboard that will take them to the Form. I have tried both options below and I can still see the Navigation Pane. Please Help...
  4. B

    Nested IIF Statement in calculating dates

    Thank you so much for your help...
  5. B

    Nested IIF Statement in calculating dates

    SOLVED - I replaced TODAY() with DATE()
  6. B

    Nested IIF Statement in calculating dates

    Everything looks good :banghead: Here is what I am trying to do with this formula: If complaint is active/open, TODAY() minus Complaint Date of Incoming Letter If complaint is closed, subtract Complaint Closed Date from Complaint Date of Incoming Letter. Here is the syntax that I am using...
  7. B

    Nested IIF Statement in calculating dates

    I get an error in the form field, #Name?
  8. B

    Nested IIF Statement in calculating dates

    I started with an excel table with 358 records already in it. I created an Access Data Entry Form to avoid typos and unnecessary data for the excel table. There are calculated fields in the excel table that I need to convert to the proper Access syntax. The attempts below are giving me a...
  9. B

    Southern Girl saying Hello

    Hello everyone, I just got a new job and I am building a data entry form for my team. I have never used Access before. I work in the education field.
Top Bottom