Search results

You have forgotten the purpose of a report. A report is a one off view of your information, generally for printing and reading. You would use a combo box on a form as a means of selecting information to save in your database and that is why it won't work on a report - different requirements.

In the field's properties put 000 in the "format" line.

That's great, thanks.

Thanks for the suggestion, but unfortunately I need a few pointers. What is a works variable table (or a worksvariable)? I've tried the help and searched the forum to no avail.

What do you say to a woman with no tits? Nothing!

I wish to develop a simple database that will be used for one job to control all the spare parts that will need ordering for a particular job. For each new job, the operators will take the template of the database, save it and use for just the one job. They will then repeat the process for the...

A young blonde woman decided to earn some extra money by doing odd jobs around the neighborhood. She went to one house, a man answered the door, and she asked if he had any jobs for her. "Sure," he said, "how would you like to paint my porch for $25?" "Great, I'd be happy to do that," she...

This ones for Nobody. Just heard Princes Charles doesn't use bookmarks. Just bends the pages over. Short enough for you?

Three men died on Christmas Eve and were met by Saint Peter at the pearly gates. "In honor of this holy season," Saint Peter said, "you must each possess something that symbolizes Christmas to get into heaven." The first man fumbled through his pockets and pulled out a lighter. He flicked...

Three men died on Christmas Eve and were met by Saint Peter at the pearly gates. "In honor of this holy season," Saint Peter said, "you must each possess something that symbolizes Christmas to get into heaven." The first man fumbled through his pockets and pulled out a lighter. He...

One for our American friends: While walking down the street one day, George Bush is shot and killed by a disgruntled NRA member. His soul arrives in heaven and he is met by St. Peter at the Pearly Gates. "Welcome to Heaven," says St. Peter."Before you settle in, it seems there is a problem: We...

Thanks Col, Just what I needed.

I am having trouble getting some reports printed. Depenedent on a certain field value I want either two reports printed or three reports printed. My reports are currently selected for print in two macros (2 reports in one and three in the other). How do I select which one I need? This is what...

Rob, Forgive me if you are already aware of the functionality of Access but I'm guessing that you aren't. Access is a suitable tool to use for your purpose. Access can be used very simply and there are wizards that can help you along. You do not need to be able to understand or write code to...

Unfortunately I need to keep them. I will give the Query a go. Thanks very much for your help.

What I wish to do is list all my records, but where there are duplicates, only show one of them. IE if I have a list that would produce 10 records and three of them are duplicated I would end up with a list of 8 records. The remaining 2 duplicates would not be shown.

I tried searching but without success. How do you produce a list in a form that will display one duplicated record as well as non duplicated records? Thanks in advance.

A businessman flew to Las Vegas for the weekend to gamble. He lost the shirt off his back, and had nothing left but a quarter and the second half of his round trip ticket. If he could just get to the airport he could get himself home and back to work and everything would be fine. He went to...

A little old lady goes to the doctor and says, "Doctor I have this problem with gas, but it really doesn't bother me too much. My farts never smell and are always silent. As a matter of fact, I've farted at least twenty times since I've been here in your office. You didn't know I was farting...

Read the line again. You get the other 90 degrees when you arrive.