Recent content by guinness

Now I just need to reverse engineer the code so I can understand it in future. Thanks everyone

Thank you. That has worked

I'm going to try this just now. I take it an 'insert' query is just an append query?

Thanks Almahood. I only want to add the record for one member of staff though. Your method would change every Friday to show RDO for everyone....I think

I have a resourcing database that lists the activities of a team of trainers and allows team managers to schedule work to the team. I have one member of the team however who does not work a Friday. I don’t want to have to schedule RDO (Rostered Day Off) every week so would like to run an...

Hi All, I used to be able to do this in seconds and now can't remember how, I have a database with a field called [Start_Date] which is a date field, a called [Trainer_Name] which will have a unique name and a field called [Activity]. What I want to do is update the Activity field to contain...

Thanks for looking guys Bighappydaddy seems to be closest to doing what I want to do but I'd need to have a think about how I achieve it. I don't want to establish the present date as I have code that jumps to todays date whenever a user either opens the form or updates data. The issue is...

Thanks RainLover. If you really do love rain you should try relocating to Scotland :) I wanted it to be a popup form where you could jump on demand to any month. I don't want to filter out other dates just save the user a bit of scrolling. As I said the code I've posted does exactly what I...

Hi Guys Happy New Year I have a resourcing database which has a form created from a crosstab query with the dates of every working date between January 2014 and December 2020 as its left hand column. By default the form opens at todays date and I have created a refresh (actually requery)...

What I ended up doing was creating two queries. One filtered on version 1 and one filtered on version 2. I then created a third query with joins on the three fields I wanted to match, vendor etc. Messy but it got me there. Thanks again for taking a look. Cheers

Thanks Spike It was the duplicate query wizard I used to get the above finding duplicates where the three fields matched. The problem is that there may be three duplicates matching that are all version 1 and a further two that are version 2. Total of 5 duplicates. I only want it to find 3...

Hi guys I have a find duplicates query with the following SQL: SELECT tblData.Vendor, tblData.[Loccurramount EUE], tblData.Last4, tblData.ID, tblData.Line, tblData.CoCd, tblData.[Document record number], tblData.PurchDoc, tblData.Reference, tblData.Curr, tblData.[Entry dte], tblData.Status...

Aaaaargh!!!! I hope someone can help. I've done this a million times and it always gives me grief. I have a combo: cmb_TrainingType. The sql is: SELECT tblTrainingType.TypeID, tblTrainingType.Type FROM tblTrainingType ORDER BY tblTrainingType.Type; My second combo (the one that should be...

Thanks All I got round my problem without putting any Iif commands into the rowsource that would change the record source. I'v simply created a project title using a full stop as the title and aligned the full team against it. So if the user enters a full stop in project title they...

Thanks rainlover The db wouldn't compile as it was missing an End Sub. Sorted now. Again part of the problem is your seeing part of a database not all. The table of dates is actually a table of working days between now and December 2020. One of the things the full database does is a variety of...