Search results

Hi All This works fine... SELECT [qry Submissionsheets].[Employee Name], CDate(CDate([Sickness - Start Date])-Weekday(CDate([Sickness - Start Date]))+1*[tblCount].[CountID]) AS AbsenceDate, Val(DateDiff("d",[Sickness - Start Date],[Sickness - End Date])) AS Expr2 FROM tblCount, [qry...

Hi All Many thanks for your replies: I certainly learnt something (always wondered what the laccdb was for - never tried opening it!), and have sorted my problem (by creating a simple 'loggedIn' table and populating/deleting from this as the swichboard form opens/closes - as per one of the ideas...

Hi All I have a split FE/BE 2010 accdb, and sometimes I am prevented from making a table design change because the table is open on someone's PC. Is there a way to find out the ID of the PC where the table is open? This would save me quite a bit of legwork! Thanks for any help. Les

Beetle Worked a treat - I'm so grateful - very many thanks!! :) Les

Hi Jdraw Thanks for your reply. Unfortunately I still get the same error with your suggested amendment. In fact I had already tried something similar, and then wondered whether I needed to do the replace on the WHERE clause as well, so I had: Set rsEmployees = CurrentDb.OpenRecordset("SELECT...

Hi All I have the recordset assignment below which works fine until it hits an employee with an apostrophe in it - it then hangs:mad:. I've tried doubling up on the quotes, and/or on the apostrophes, and I've even tried doing a findandreplace to get rid of any apostrophes in employee: but all to...