Search results

I used the wizard to insert a button used to create a duplicate record. The button worked fine under NT but since we've converted to XP, it causes an error. All I get is a message that says 'The record that Access was unable to paste has been inserted into a table called Paste Errors'. I...

I have a button called 'Duplicate' on a data entry form. This allows users to copy a record and then make only minor changes to a field or two. It worked fine under Access 97, but since converting to XP, it won't work at all. I get an error message that says "Records that Microsoft Access was...

While taxiing at London Gatwick, the crew of a US Air flight departing for Ft. Lauderdale made a wrong turn and came nose to nose with a United 727. An irate female ground controller lashed out at the US Air crew, screaming: "US Air 2771, where the hell are you going! I told you to turn right...

A man says, "Honey, this meal is fit for a king." Then he puts his plate down on the floor and shouts, "Here King! Here King!"

How many men does it take to open a beer? None. It should be opened by the time she brings it. Why is a Laundromat a really bad place to pick up a woman? Because a woman who can’t even afford a washing machine will probably never be able to support you. Why do women have smaller feet than men...

Is it your goal to be the last poster on every thread?

What is an Essex girl?

<<The Doctor replied, "Same problem - but he's with BUPA.">> What is BUPA?

Sorry, cannot download the .zip file.

I have a form that is used to search for a project. When the correct project is found, the user double clicks it and a project info form is opened where the user can enter comments (subform). I have it set up so that if a comment has been entered previously, it cannot be edited. This means I...

Colin, find the energy to read Fizzio's piano player with Tourette's on page 2. Now one of my all time favorites.

Thanks, I'll give it a shot.

I have a button called Smart Search that is available on almost all forms in my db. Is there a way that when the button is clicked, it will not only open the Smart Search form, but will close all other forms currently open. Thank you.

Thank you very much. Worked great!

The record source for my form is a query with the following criteria: Like [Enter Contract Number]&"*" It works well except for when a user enters something off the wall. Then the form enters completely blank, nothing at all is displayed, including fields. How would I go about displaying a...

Thanks Mission, I'll give it a shot.

This is a very simple example, but one that I hope will demonstrate what I am trying to figure out. I have a table with 4 columns and 100 records. The columns are County, Route, Section, and Engineer. I have created a search form with 4 unbound combo boxes -- one for counties, one for routes...

Thanks. After re-reading, I realize I didn't really ask what I was looking for. I've got the SQL working where it returns any user with any account checked Yes. What I cannot figure out how to do is tie this query to a form where the user checks whatever they want. For example, if BCM, DSI...

I have a table that has the following columns: UserName BCM CSI CUINQ DMI ESI The last 5 columns are Yes/No columns which represent IBM accounts that the user may or may not belong to. How would the SQL look if I wanted to return every user that has at least one Yes in any of the IBM account...

Thanks, I'll give it a shot.