Search results

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

Hey Guys, Anyone seen this site before? It's MC Hawking That's right, it's Dr Stephen Hawking rapping and it's pure genius! You can watch videos and download some of his MP3s for free. The track "Rock Out With Your Hawk Out" is my new fave Enjoy! Rusty :D

Yeah, that was a separate incident in Celebrity Big Brother earlier this year when several of the housemates subjected an Indian actress to "bullying and racism" in the programme. Telegraph.co.uk Thankfully 'Jade' now seems to have sunk into obscurity. Rusty :D

How many forum members does it takes to change a light bulb? 1 to change the light bulb and to post that the light bulb has been changed 14 to share similar experiences of changing light bulbs and how the light bulb could have been changed differently 7 to caution about the dangers of...

These are genuine too! :eek: Top Ten Worst Picked URLs 1. A site called ‘Who Represents‘ where you can find the name of the agent that represents a celebrity. Their domain name… wait for it… is www.whorepresents.com 2. Experts Exchange, a knowledge base where programmers can...

If it's a query then the best way is to concatenate (or combine) the three fields into a single field. It's quite straightforward and I have attached an example using the information you supplied in the original post, with the three bits of data combined with slashes in between in a new fourth...