Recent content by zacharyjunior

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?