Search results

  1. J

    Conditional Formatting

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

    Query by selecting from drop down menu

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

    Duplication check on entering a record

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

    Linked form does not allow data to be entered

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

    Datasheet/form view on opening

    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...
Back
Top Bottom