Search results

Sorry, when I said toggle button, I just meant a standard button that has the ability to sort in either ascending or descending. This would be done by checking if the field had previously been sorted ascending or descending.

Hi I am using Navigation Forms in my database and would like to sort the order of a datasheet on a toggle button. The structure I have is Main Contractors Details Datasheet All the examples I have seen, show the property of Me.OrderBy being checked to see which field has been...

Hi I have created an Access DB for maintaining our contractors information. It has a few tables for CompanyDetails, ContractorsDetails and Attendance. Part of the CompanyDetails table, is to hold the Public Liability Insurance expiry date. To enable us to ensure this is always in date. When a...

Thanks very much for your answers, they are exactly what I was looking for. I certainly will do lots more reading. Its a shame there isn't 48hrs in a day ;)

Do I do this in a separate table? At present my tblContractorsDetails has the following fields ID LastName FirstName CompanyID_FK InductionDate LastDateOnSite At present when they attend site, I press a button on a form that updates that record LastDateOnSite with Date() So not sure how to...

Hi I am in the middle of creating a database to control our contractors. Creating tables for the companies and contractors details and forms for the inputting of this data. Also I populate a field on the contractors record to show the last time they were on site. What I now want to do, is...

Hi Just started to learn Access to allow me to create a database to control contractors at my place of work. Currently a single excel worksheet is used and doesn't do the job at all well. Been watching lots of YouTube videos and have a part working DB, just need a little help to add the bells...