Search results

Hi, My problem is with 2 combo boxes in a subform. One combo box has a list of Services, and the other has a list of different Groups which change depending on what value is selected in the Services combo. I just cannot get the Groups combo to refresh it's contents whenever the Services combo...

Hi folks, I would like to be able to delete the serial number from the beginning of a record (see below) but keep the rest of the information that appears after it. I have tried TRIM but that only seems to work with blank spaces. All the serial numbers are the same number of digits long...

Hi all, I have been given a text dump which runs into thousands of pages in a truly awful format. I had hoped to import this text file into an Access table (via Excel if necessary) which I could run queries against. This system it comes from is ancient and pretty much locked down, I can't...

Hi, I am having difficulty showing absence days in a graph. The amount of absence days is correct, however the distribution of these days doesn't work out the way I would have liked. If you look at the example graph on my attachement, one person had a very long absence which lasted for 599...

I am developing an absence database which records the first day ([startdate]) and the last day ([enddate]) of an absence. I am able to count the length of the absence in days between these 2 dates ([nofda]) , having holidays and weekends discounted so we are left with just the workdays value...

Hi, I have a form where the user puts dates into 2 text boxes. What I want to happen is to have a third text box have it's value be set to 'Yes' if the first 2 text boxes has a date in them. If either of the first 2 boxes is blank, I want the third box to have it's value changed to 'No'...

Hi all, I'm trying to get a Dcount function to work based on whether 2 check boxes are ticked. The data table is called tblquestions The condition of the count is based on [businessservices] AND [vs_chair] being checked. My stab at it was...

My form has a series of text/combo boxes that allows filtering of staff records on criteria such as name, department, the first day of absence, the last day of absence, reason for absence and so on. I need to be able to show the absences for a department during a monthly period. I can set...

Hi, I have a form with several check boxes on it. I would like all the check boxes to be enabled for each new record, until the user selects just 1 of these check boxes, and when they do, the other checkboxes become disabled. Unless they click their selection for a second time, effectively...