Search results

Hey Guys, I’ve attached a zipped example of the problem I am having with customised navigation buttons. In my main database the form “subfrmPersonsContact” works perfectly. I have exported it to a new database and now the customised record count fields do not work at all – they are in fact...

I can't do that Pat - patients that are outside the Trust's administrative area are given '000000' as their reference number. So I'm stuck with this rather unique 'challenge'. Rusty :D

Hey guys, Hope you can help with this one. I have a form called "frmPatientID", based on a query "qryPatientID" and table "tblPatientID". I have a field called HospitalNo that is set to "text" and contains the patient's unique hosptal number of 123456, 008777, etc. However, although the...

Yeah, nice one Rich. That'll keep the buggers out!! :D

Hey Guys, Is there any way of deactivating the main Menu Bar ("File","Edit","Insert","Format") when a form opens? I need to implement this for a single form to stop an idiot user from trying to break the system! :mad: He's not doing it on purpose - he's just ignorant and doesn't listen or...

Bloody typical - I hit a deadend and post the problem on the forum, go for a cup of coffee and then I come back and answer my own question! In case anyone is interested the criteria to put in the date field needs to be: Between DateSerial(Year(Date()),Month(Date())-1,1) And...

Hey Guys, I've been racking my brains on this one and need your help. I was asked this question by a friend who has just set up a database for a non-profit organisation in the UK. I have attached an simple example database to illustrate the problem. There is a table called "tblMembers" which...

Ten feet away the rabbit stops, turns around and waves again, he hops down the road another 10 feet, turns and waves, hops another ten feet, turns and waves, and repeats this again and again and again, until he hops out of sight. The man is astonished. He runs over to the woman and...

A man was sitting at home one evening, when the doorbell rang. When he answered the door, a 6 foot tall cockroach was standing there. The cockroach immediately punched him between the eyes and scampered off. The next evening, the man was sitting at home when the doorbell rang again. When he...

Brown Paper Jake: A sheriff walks into a saloon and shouts for everyone's attention "Has anyone seen Brown Paper Jake?" "What's he look like?", asks one shoddy-looking cowboy. "Well", replies the Sheriff. "He wears a brown paper hat, a brown paper waistcoat, a brown paper shirt, brown paper...

Wouldn't you just love to... :D

Once upon a time, in a nice little forest, there lived an orphaned bunny and an orphaned snake. By a surprising coincidence, both were blind from birth. One day, the bunny was hopping through the forest, and the snake was slithering through the forest, when the bunny tripped over the snake and...

Thanks for that Trucktime. Using that I have worked it so that the PDF is selected as the default printer and then the report is printed. When the report is closed the default printer is reset to the laser we have here. Cheers, Rusty :D

I was wondering what George was saying when I saw this on the news... :D

Darwin Awards: These were the winners (awards given for helping mankind along due to the person's stupidity!) 1. When his 38-caliber revolver failed to fire at his intended victim during a holdup in Long Beach, California, would be robber James Elliot did something that can only inspire...

There was a farmer who had four daughters. One night, he heard a knock at the door and found a young man standing there. The young man said, "My name is Freddy. I've come to pick up Betty. We're going out for spaghetti. I hope she's ready." The farmer thought that this was cute, so he...

Hey Guys, I have searched and searched for this on the forum but to no avail. :( I have just installed Adobe Acrobat 6.0 and so can create PDFs. Does anyone know the code I need for a button on a form to print a report to PDF format? Many thanks, Rusty :D

A man walks into a drug store with his 8-year old son. They happen to walk by the condom display, and the boy asks, "What are these, Dad? To which the man matter-of-factly replies, "Those are called condoms son. Men use them to have safe sex." "Oh I see," replied the boy pensively. Yes, I've...

How to be politically correct when you comment about women... She is not a BLEACHED BLONDE - She is PEROXIDE DEPENDENT. She is not a BAD COOK - She is MICROWAVE COMPATIBLE. She does not wear TOO MUCH JEWELLERY - She is METALLICALLY OVERBURDENED. She is not CONCEITED - She is INTIMATELY AWARE OF...

Hey Rak, I've got the open/close cd code to run on the open event of the Splash Screen of the database. If it's April 1st and before 12pm it opens and closes the cd drawer twice and displays a message too. However, most people here have got DVD drives too. Any ideas how to open and close...