Recent content by Rusty

Yep that's exactly what I told my boss when he asked for the field in question to be an updateable drop down list. I'd much rather it was a straightforward combo box with a range of pre-set values to select for the very reason that I am now tidying it all up. That's the problem when users get...

That's spot on and worked a treat - thanks Wayne :D

Hello, I am trying to run a query to pick up some odd entries in a rather large database. Users have been keying data into a text field such as "Nationally funded?" and "Nationally funded / Local Charity" I need to search for all these 'odd' entries and can't use the criteria: Like "*?*"...

Hello, I am trying to create a batch file using a sendkeys command to press Ctrl, Alt and the down arrow to flip someones PC screen (yes April Fools is coming up). Can anyone help - I've only got as far as: ^%{DOWN} If I was using VBA and Access I'd be more than ok but I'm shooting in the...

An Irishman called Paddy was taking his heavily pregnant wife Mary to the maternity unit at the local hospital to give birth. When they arrived the receptionist asked "Is she dilated?" To which Paddy replied "Oh to be sure, she's over the moon!"

Wicked! Thanks - that's really helpful! Looks like it's gonna be SQL then :D Will be sure to read up on it first before committing our cash to anything. Luckily the new service doesn't kick in til 1st October so I have time to plan, get trained and be ready to start in muy new role in Oct...

Hey Guys, I've been working in MS Access for years now but our service is expanding to cover the whole south west (of England). My boss has announced he wants a web-based database to run the show and has given me a blank cheque to go get some training. Great news...only I have no idea where...

Cheers dude. I went with "0000009" as it's the last digit that's optional. Many thanks you guys for all your help. Rusty :D

Cheers dude. The field is a text field that needs to have either a 6 or 7 digit numerical value put in it. (The reason it's a text field even though there's a number going in there is that some of them start with a 0, i.e. "012345") Hope that makes sense. Rusty :D

Thanks guys :D I work a lot in VBA, but how do I check the field using vba? Rusty :D

Hey Guys, Long story on this but I need a reference number field to be limited to either 6 or 7 characters. Any ideas how to implement 2 input masks on a single field. Obviously all I have at the moment is "000000" in the Input Mask section but not sure how to put a second one in there. Any...

Huh? What you "calmed down"? :p

Oh my god! Here it is LINK I am so excited about this film! :D Rusty :D

Hey Guys, If you can't wait for the Dark Knight to arrive here is (supposedly) the cover of Empire magazine for next month. Enjoy! *Please don't look if you don't want to be spoiled :-) http://i92.photobucket.com/albums/l37/methroach/jokerleakedimage.jpg Rusty :D

Hey guys, I have attached some screengrabs to illustrate the very problem but here goes... It’s a 4-tab form that’s too long to fit on the screen. (i.e. the user will need to scroll down to view all the fields on Pages 2 and 3. When I open the main form I have the following code on there to...