Search results

I have two unrelated tables. One tracks customers who have cancelled service. The other tracks customers that have cancelled but still have a balance owing. I need to generate a report showing all cancelled customers. I tried several variations but I just can't seem to design a query that will...

How can I display multiple selections from a combo box in a text box on the same form? Right now the user has the ability to enter customers disabilities in a text box. They want to be able to select these from a combo box. I've added two new tables to the database to hold and link the various...

Right now I have a form that sortsrecords based on customer ID. I need it to sort by Last Name. This seems easy but nothing I've tried works. Why is it sorting by ID anyway. The form is based on a table and I've set the table to sort by last name. Please help, somebody!

I have a form that is used to lookup records for a variety of criteria, using "find" command buttons. I just added three more buttons and they all work fine to find my records. The problem is once the record is displayed(in a separate form)and I use a command button terminate the record, I get a...

I'm updating a database that somebody else designed and he has a form that allows the user to enter a new client. On that form he also has a button that brings the user to another form that adds that clients contacts. The problem is once the client is added, the add button must be clicked to add...

I need to generate a report that provides a list of ten units that need testing. I have no trouble with the report but how do I get it to increment to the next ten once those have been tested. I am so new to Access and have only done one course. I'm on a work term now that's all Access and I'd...

How can I allow a user to select more than one option from a list box and be able to carry the whole selection to the underlying table. When I change the property to allow this, I get a null value. I'm new at access and this is so frustrating! Thanks.