Search results

The code worked great. I am intersted in having a report or form pop up with the records that have the duplicate records. How can I do this? Thanks Zacharyjunior

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

Pat, I am still having a problem. I understand the part of entering the Between [Start Date] and [End Date] in the criteria part of each date. This is not a problem. The problem is that the correct data is only returned for the Invoice cost. The order total $ has the same amount and the...

Sorry for the double post. Pat, where do you put this line at in the query? Where ComplaintDate Between [Enter Start Date] And [Enter End Date] OR InvoiceDate Between [Enter Start Date] And [Enter End Date];

RV, I am a little confused with your response. What do you mean by use the format function? I have two diffrent tables. Complaints (Which houses the complaint and orders are placed). Invoices - Stores the financial data for invoice payments. The orders are placed and the date is recorded...

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 believe the customer name (drop down) is a bound control and the remaining customer info is unbound.

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

Here is the code. Where should I enter the requery command? Private Sub Disposition_Click() Me.Visible = False DoCmd.OpenForm "frmDisposition" End Sub Private Sub Form_Current() Me.Address = Me.Combo59.Column(2) Me.City = Me.Combo59.Column(3) Me.State = Me.Combo59.Column(4) Me.Zip =...

Where can I locate the code module?

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 put the following command in line one of the field (in the design view of the query) as you said Your Statement: Format(Nz(YourField,0),"Currency") My Statement: Format(Nz(Parts,0)"Currency") This is what it changes to: Expr1: Format(Nz([Parts],0),[Currency]) When I run the querry it is...

Ok It worked. Thanks. The only probelm is that it changes the format. The fields use to be currency but now they are just numbers. Any thoughts?