Search results

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.

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...

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