Recent content by Jetjefferson

This may be really obvious but I can't think how to set this up. I have a spreadsheet with names down the left and products across the top. I have the price in the corresponding cell for the name and the product. For the name row, I want to highlight the lowest cost in a different colour...

I have a database which is used to record leads and sales for a saleforce. Currently, I have a separate query which does the same thing for each person. What I would like to do is have one query but be able to select which sales person from a drop down. My Access knowledge is fairly basic...

Can anyone tell me if there is a way to check whether the info being entered to a form is already stored in the form. i.e. by checking the telephone number to see if there is another record with the same number. What I want to happen in this circumstance is for a warning box to come up advising...

I've been playing around with the forms and have narrowed down my problem to this: When I click the 'Contact History' button, I want to display the data entry form and have a default in the 'ID' field (which will not be displayed) as the ID from the record from which the 'Contact History'...

I follow what you are saying, however I thought I had the details entered into the 1 table when I was trying to enter the details in the N table. Did you try putting data into the main table and then enter data into the contact history? I did that and still got that message. Maybe I've...

I have set up a database (blank file attached) to record lead information and details of contact made with the prospective clients. When the Contact History button is clicked, it opens a dataform which should allow a record of the contact to be logged. Everytime I try to do this however I get...

Thanks Peter That has done the trick. Much appreciated Derek

I have made a database for recording contact with potential clients. I have set up a button on the main form which opens up a second form which details dates and time of calls. In this second form I have placed a sub form to record notes of the conversations. I set the second form up so that...