Search results

Thank you very much. The union query was just what I needed. My report now works great!

There are no fields common. The records in the cancellation table appear only in this table and the records in the other appear only there. I have a customer table but once the customer cancels, all record of him is removed from this table and transferred to the appropriate cancellation table...

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

That code was just what I needed. I was using code like it but was getting errors due to improper syntax. Thank you so much.

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

That was the first place I looked. Even when I change this property on the form, it still orders by customer ID.

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

The second way would be okay. How do I get only 10 records on a page. I told you I was new at this...

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 realize that I shouldn't use more than one entry for a field but this is a field that simply lists a person's disabilities and the user would never need to seperate these. They want this simply to save some typing. Thanks Harmony Girl, but I don't have access to the CD and don't have the...

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.