Search results

Hello All, I have a warranty database that tracks automotive warranty claims. I have a need to provide the user an allert or a notice that will allert the user that the VIN number typed in was previously entered in the database. I want to allow duplicate VIN numbers but I want to make sure...

I have two tables that I need to obtain data from. Both tables have date fields (Complaint date) and (Invoice Date). I want the complaint cost from June and all invoices from June. Thanks

I seem to be stumped. I have two queries that I need to generate a report with. The first query has a field complaint date, and the second query has an invoice date. I need the dollars associated for a particular time frame. Complaint Date - What cost is associated during that time. Invoice...

I have a form that gathers customer complaints. The customer name is a drop down box and when a customer is selected the rest of the customers information is automatically put in the form ie , address, city, state, phone. The problem I am having is that I can not use the find function on the...

Hello all, I have a report that is used to order parts and send to the customer for their files. In some cases I want the defective parts returned. In the past 99% of the parts were returned so the text box was always part of the form. Now I only have a very few occasions when parts are...

Hello all. I want to say one thing I just finished a week long class on VB and I was lost. You people that understand this stuff my hats off to you !!! Anyway I hope that if I work with it I will understand it. Here is my question. I have an Access 2000 db that has a switchboard with...

I have to report cost on a monthly basis to my staff. I built a database to record customer complaints, ship parts, and pay invoices. The problem I am having is that if I record a customer complaint in Jan 02 and ship parts that day and a month later I pay an invoice against that complaint it...

I have a report that is more or less an invoice to the customer. In the report footer I have text that provides a return goods number and shipping instructions. The problem is we do not want the material back sometimes. Is there a way that on my form I can select to add this text to the...

I have a customer table that lets us put in a new customer while in the complaint form. After the new customer is entered I tried to locate the customer in the drop down box but they did not appear. I had to close out of all the forms and go back in in order for ut to show up. I believe that...

Ii have a query that shows the cost associated with a customer complaint. The fields in the query are: Complaint Date Complaint ID (AutoNumber) Invoice: Nz([tblInvoices]![Parts]+[tblInvoices]![Labor]+[tblInvoices]![Misc],0) Parts...

Here is my problem. I have a query that is based off my customer complaint table. I want the query to return all the complaints and cost associated with the complaint. It does this. The problem is, is that when I place an order I may order 10 diffrent part numbers. In the query results it...

I have a query that returns all customer concerns that have cost the company money by either shipping free parts or paying an invoice. The query returns all data and some fields are blank. For example, if I ship parts only the invoice data is blank as vice versa. I want the null value to show...

I have a customer complaint form that has numerous customer data fields. The first field is a frop down box that links back to the customer table. When the operator selects a customer it auto populates the customer data. From time to time we will run across a new customer that is not in the...

I built a query that looks up all customer complaints from a certain time frame. It pulls from an invoice table and a order table. In the query I want it to calculate a total $ spent. Here is what I have so far but it does not work. The following fields are from the order table. Standard...

I currently have a database that records customer complaints. In some cases the data from one complaint may be the same as the new one. What would like to do is have a button on the bottom of the form that will copy the current complaint (All fields) to the next / new record. How can I do this?

I need help on two issues. 1. I have a query that calculates cost per incident but many of the fields have a null value. How can I make the null values = $0. 00? 2. I want to create a button on the bottom of my form that will copy the current record to the next new record? Thanks for your...

I have a few issues I need help with. I have a query that calculates $ spent per incident. Some of my fields have a null value and in the query I want a null value to show $0.00. I want to create a button on my form that will allow me to copy the current record to a new record. Thanks in...