Search results

Thank you, that's terrific, yes it does!

Hi all I've struck an issue which has me stumped, so am hoping you good folk out there can help me, please.... I work for a training organisation which trains the people that work in kindergartens, child care centres and the like. One of our staff visit the centres on a regular basis and lets...

Got it working now by the looks of things. Earlier versions weren't excluding a centre that had been visited within the last 4 monhts, so I added that in as a subquery, and it works now by providing a list of centres that are not in the query on those that have been visited within the last 4...

Welcome aboard. Feel free to ask questions as there's a lot of people on here that can help.

Ta - ultimately it probably will feed off a control, but for now the requirement is for anything we haven't visited in at least 4 months, hence the hard-coded timeframe. I got the subquery from ChatGPT... but wasn't happy with it so it didn't stay.

Thanks - I ultimately found that I had a text field in the form which was looking for that field. Was only when I changed the text field to read off my now renamed Visit_Date field that I realised why it was asking for that.

Not as smart as that, I will admit - thank you for the suggestion though. I learnt Access 25 years ago and have had very little exposure to it till now, so am quite rusty but the rust is being sanded off as I go. I had got the subquery from ChatGPT, but wasn't overly happy with its answer.

Thank you MarkK, yes it in essence does in a slightly modified form. I had to fight some syntax errors here and there, and have gotten closer however it shows those that were visited 4+ months ago regardless of whether or not they have been visited within 4 months from today - which is not what...

Hi all, am hoping to get some help with this issue I'm facing, please. I work for a private training organisation that trains the people that work in child care centres. We have a Business Manager who amongst other things tries to visit the centres on a regular basis. We have a spreadsheet of...

Thanks - I struck that error too, and it was due to fields with nothing in them (null) that had either the Required property set to Yes, or Allow Zero Length set to No without realising it, which may be defaults for Access. Those fields in my table were ones that I could afford to have blank...

Hi all My name's Kevin and I'm working at a Childcare Training company in Brisbane, Australia. After learning Access as part of a Bachelor of IT that I got in Nelson, NZ back in the very late 90s, I have now been able to make use of that knowledge. It's only taken about 23+ years of office...