Search results

  1. J

    Offline front end database

    Hi Guys, I have created a database to be used for lift maintenance audits. The idea is a central database is used to produce reports using mail merge. This all works very well. However, since we have purchased tablets we would like to use them to carry out the surveys rather than use paper...
  2. J

    MS Access Database Sharing

    Hello Guys, I have created a database & forms for data entry for the company I work for in order to streamline one of our processes. What I am struggling to get my heard around is allowing multiple users to work on the database at the same time without the same Primary Keys being used and...
  3. J

    Mail Merge - Multiple value fields

    Hi Guys, I am using mail merge to produce reports for lift inspections and it is all going well apart from the fields that are multi value do not quite transfer. For instance the "inspections completed" field has a list of the months Jan-Dec and therefore a visit may have been completed in...
  4. J

    Merge two child fields as string

    Hi all, I am currently creating a database for lift inspections. The output is a mail-merge report. What I am trying to do is get the multiple Lift Name (child) and Floors Served (child) combined into a string so that each Lift Group (parent) inspection has only one row. This then means that...
Back
Top Bottom