Search results

  1. C

    Using an array in where clause

    Hello everyone, I need to run a query that is filtered by an array, but is not returning the desired result. I have a textbox "txtValues" on a form, that has the array values let's say 1,4,5,6 I need to fire up the query where the ID is within those value, so ran the SQl statement adding "where...
  2. C

    Build the 'where' sql statement following search form selection

    Hi everyone, I am building a search form for my DB, and added 5 checkboxes, with comboboxes/textboxes next to them to let the user make a search selection. They are cbPosition, cbDepartment, cbInterviewer, cbFeedback, cbRating and cboPosition ,cboDepartment ,cboInterviewer ,txtFeedback...
    • Chaga
    • Thread
    • Replies: 42
    • Forum: Forms
  3. C

    Remove #Type! when no parameters

    Hello everyone, I found a function online that returns years/months/days for a date difference, and using it in a form to give me a contract duration between 2 dates. But the result textbox displays #Type! before entering the dates, how do I keep it blank instead? Am pretty sure it's quite...
    • Chaga
    • Thread
    • Replies: 2
    • Forum: Forms
  4. C

    Merging 3 databases into 1

    Hello everyone. I have 3 similar databases containing multiple tables with different data, that I need to merge into one. How can I do it while preserving data integrity since the main AutoID will change. Let's say 3 tables Contacts Interviews JobHistory Interviews and JobHistory will have...
  5. C

    Need some guidance with normalizing data from excel import

    Hello everyone, I am an ex access developer, but haven't done any work in the past 15+ years so am quite rusty. Would love it if you could give me some insight as to how to proceed with my issue(s). I've decided to get out of retirement and help a friend of mine who's in HR, and migrate her data...
Top Bottom