Recent content by JackD

Hi Bob, the row source on the 2 combo boxes provide the link between the values Services and Groups? combo.TransfromService = SELECT ServiceID_Table.Service_ID, ServiceID_Table.Services FROM ServiceID_Table; combo.TransfromGroup = SELECT GroupID_Table.Groups FROM GroupID_Table WHERE...

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

Bob, Thank you for your kind help, it worked a treat. Regards, Jack

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 have attached a pdf of the graph have managed to cobble together. As you can see the data was only being input from around July 2008 onwards but it shows the problem I have. The total for March shows there were 104 days lost to absence. Actually, that absence began in March and ran through...

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

Thank you for the assistance Listo, it worked a treat. Bob, I agree 100% that a query should be used for applying criteria to harvest corresponding data from tables for reports or otherwise. However this is just a cosmetic change I wanted for the user front end form, a visual indicator that...

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

There are times in your life when you just have to stand back and applaud in sheer bewilderment and acknowledgement of a tremendous event or person. Mr Warnock, I am eternally grateful for your time, generosity and genuis. You have truly dug me out of a hole from which I thought I was never...

Would have responded much sooner but I've had a couple weeks off work in an attempt to regain some sanity, but I think I'll need more than 2 weeks to work on that.... I'd like to thank everyone for their help with this database I am trying to create, especially Brian who has taken me to the...

Almost there, in a glass half full kinda way! Still having issues though. If you set a date period from the 1st oct to the 31st you can see the filtered list picks up the correct records, including the ones with dates that lap inside and outside of the first/last day of month range, as...

Thanks for your prompting and input. Sadly I am stilll unable to get the results I need. I have tried to express the VB code to capture Brian's SQL (see below), but I have failed dismally. Anyone out there who can offer me a shoulder to cry on or maybe a hand out of this quick drying cement...