Recent content by JDCD201

Thanks Rx_ With regards to the "dirty data", none of the current data shall be changed on the tablets, only new data will be added. Maybe outlining the structure would help: Form 1 - The engineer selects the: 1. Client 2. Site 3. Lift Group 4. Lift (These will not be changed on the tablets but...

Thanks for the help guys! I managed to make the ID's unique using the tablet number and the system time as a string. I have another query now regarding the synchronization of the data: http://www.access-programmers.co.uk/forums/showthread.php?p=1352392#post1352392 Any help would be greatly...

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...

Thanks Ken, We are looking at trying to keep it all in house if possible but I shall have a read later. Thanks, James

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...

Right done that Paul. When I go to export the query to word this pops up: ODBC Microsoft Access Driver Login Failed: Could not find file 'C:Users\James\Desktop\.mdb'. * I Click ok* then this pops up: Login Authorization: Admin Password: I haven't set a password or login up for this? Is...

Hi Paul, I removed the function and re-added it again just to check and saved it as ConcatRelated. I then couldn't use it and whilst researching found that if the module and function are saved under the same name it confuses Access so it is now saved as Module 1. The previous error message...

When merging my query with word an error message pops up Error has occured: "Undefined function 'concatrelated' in expression. Does anybody know how to solve this? Thanks, James

Thank you so much paul! That worked perfectly! Just out of curiosity how could I change it to it showed Lift Reference, Floor Served; Lift Reference 2, Floors Served At the moment it is showing Floors Served, Floors served but it would be awesome if i could show the lift and then floors that...

Sorry paul! SELECT tb1Lift_Group.[Lift Group ID], tb0Site.[Site Name], tb2LMA_Info_LiftGroup.[LMA Group Examined by], tb2LMA_Info_LiftGroup.[LMA Date of Examination], tb1Lift_Group.[Lift Group Reference], [tb1Lift_Group]![Group Rated Load (kg)] & "kg/" & [tb1Lift_Group]![Group Rated Load...

Floors Served: concatrelated([Lift Info Floors],[tb2lift],[Lift Group ID],[Lift Reference]) I have also tried: Floors Served: concatrelated([tb2Lift]![Lift Info Floors],[tb2lift],[tb2Lift]![Lift Group ID]) Thanks, James

Thanks Paul, I've been fiddling around with it for a while but I can't seem to get it to work. It keeps telling me that the field I select (the table) could refer to more than one listed in the FROM clause in my SQL statement... any ideas? Thanks, James

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...

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...