Search results

Thanks for the help. It works except for one glitch. After clicking the "OK" button on the msg box the form still opens. Is there any way to stop the form from opening?

Using brackets in the query grid ([Enter last name].

I get a error message when I try this. Am I correct to assume that the "*" is the name of the last name field and the "qryLastName" should be the name of the qry that the form is based on? When I go to debug, this is the line that is highlighted.

I tried using the "+" operator but still got the ", " when the first name is null, i.e if the last name field is "Sears" and the first name field is blank the name field in the report is "Sears,". Can an if, then statement be used? I have tried to construct one but I know just enough about...

I have a form that is tied to a query that searchs on the last name. I would like to have a meesage box appear if the last name is not found. Thanks for the help.

I have a "name" field in a report that is created from two fields (last name and first name using [LastName]&", "& [FirstName]. Sometimes the last name is a business and the first name is null. How could I print just the last name field when the first name field is null. Thanks for the help.

That did it. Thanks for your help.

I have a form based on a query that is used to edit data. I have created a command button in the form that prints a report using the data in the current form. The problem I'm having is when I edit the data and then click the command button the report prints with the original data not the...

I 'm using Access '97 and have a form that is based on a table. One of the fields is a combo box that looks up names from another table. The Look up tab for the field has the following properties: Display Control Combo Box Row/Type Source Table/Quary Row Source name of table...

I have a form which is based on a query. The quary yields stats based on a specific date which is entered with [Enter Date]. I would like to have the specific date be in the form. I have tried making a new unbound text box and using ="Flyer Date: "&[Enter Date] in the data control box but I...

Thanks for the reply, but I'm new to Access and am still lost. I tried a couple of different ways and couldn't get it to work. Can you tell me step by step how to do this? Thanks for your time.

I am trying to create a report from a query that finds records between two dates. How can I get the parameter dates to print in a report,IE: Report Title "Start date" to "end date" Thanks for any help