Recent content by farmboy

I had come across that method, but it gives me an error message: "Run-time error: '438' Object doesn't support this property or method" Which is the same one I get when I just use .Caption. Thanks though! EDIT! I'd missed the "s" from "Controls"! It works now, Thanks JHB!

Hi Guys, I'm trying to customise the error message for Input Mask Violations, so that it references the control where the error has occured, rather than just being a generic error message. I can make this work using the code below: Private Sub Form_Error(DataErr As Integer, Response As...

Lol. Nice one, I'm sure he'd go for that!!

I do still want him to think I did some actual work today!

Cheers JHB, I managed to modify the info from that video to get close to what I needed. I did use my test database, I just had mountain of paperwork I had to get to first! Hi Spikepl. Don't worry it annoys me too, and I hope it will annoy my boss! It was just one of those things he decided to...

Looks like that has possibilities, just need to wait till I have sole usage of the database again!

Hi guys, I'm working on a series of forms for a company that I'm currently employed at, and on one of them I've made a listbox which will display records which need action in the next 2 weeks. That's all going fine, and I'm quite pleased with myself (I'm new at all this!) :) However, my boss...

Hi, I'm just starting out with access, having landed my first job as an admin which has involved my getting to grips with Access. Currently I'm trying to get a 7 year old database that has been chopped, changed, and copied multiple times to behave itself! :banghead: As such I'm just picking...