Search results

What is my control name?

thanks for the quick response, but the form is working exactly the way that I need it to. What I would also like to include is a message, so that if the user enters a name that is not in the database, they receive a message that says something like " You have entered an incorrect name, please...

I have a macro in a form, that prompts me to enter the name of a company. Once I enter the name of the company, it returns the contact information of the person who manages the account. However, if I incorrectly spell a name or enter in a name that is not in the table, I receive a blank form...

Can anyone tell me how to convert this into an Access query formula? If Parent Company Name = * [Enter Customer Name]*, then stop If Parent Company Name is not equal to *[Enter Customer Name]*, then look for any names that have *- or & or /* in the name that match my customer name. So...

Thanks so much for your help. Not sure what I'm doing wrong but I am getting a syntax error. Will keep trying

It's a simple table. It has the name of the company and the support persons contact information. The goal of the database is to be able to search a company's name and find out who supports the company. My query allows me to pull up the information for an individual company, but it also...

Sure. An example using the "&" sign would be like searching for A&B Corporation. I want to be able to type in the name with or without the "&" sign and still pull back the information. An example of "-" would be Pick-way or pickway

Unfortunately, that didn't work. It worked if I included the "&" in my search but if I put in a name that doesn't have "&" or "-" then it doesn't bring back a name.

There will not be a list for a user to choose from. This is a list that a user could use if they wanted to know who the resources were for a customer? So, the output would be the support resource with their contact information.

Hello, I am working on a query and having some difficulty pulling back the information that I want. I would like to my query to prompt a user to enter in a customer name and have access return the contact information for the customer. The issue is that I can't figure out if I should use...

Hello All, I'm still fairly new to Access but learning fast. I find myself constantly being asked to build new databases and surprising myself with the outcome. I am excited to be a part of this forum and enjoy reading all of the great tips and suggestions.