Search results

  1. C

    Check for duplicates

    Have you tried using the find duplicates query wizard? Click the new button from the queries section and follow the prompts. HTH
  2. C

    Preventing old reports updateing new details

    I have report which looks at linked tables for agent details. If however I change one of the details the report updates the changes in all previous records. How can I ensure that it only shows the values that were current at the time of data being keyed in? tia
  3. C

    Adding fields in a report.

    Excellent. Thankyou.
  4. C

    Adding fields in a report.

    I have about ten number fields that I want to add in a report. If there is no value in one of the fields I want that particluar field to be blank. the problem is if I put in the calculation [field1]+[field2] and field2 has no value the result is nothing but if both field have a value it will add...
  5. C

    Required fields

    Thanks for the advice that's what i will do if this other idea doesn't work but I want to make the form appear less congested if the other fields aren't necessary. I have a whole groups of agents who have sub agents under them. Many have only one or two but others have up to ten. I was hopeing...
  6. C

    Required fields

    How can I make a field "required" dependant on another field having a value in it. tia.
  7. C

    Msg Box with a cancel option

    Thanks but now how can a use the response to end the event if the cancel button is pressed.
  8. C

    Msg Box with a cancel option

    I've have a Report that prints from a form button. I've added a MsgBox which warns the user which report it is but it only accepts "OK" and then prints. Could I put a cancel option on the message box so that the action can be cancelled and the report won't print? Luke
  9. C

    Generate an auto-date when tick box = true

    Thanks M8 works perfectly. What is the Me. commmand for? [This message has been edited by chuckster (edited 10-10-2000).]
  10. C

    Generate an auto-date when tick box = true

    I want to tick a tick-box and then have another field generate the current date and record it in the DB. It seems so easy in VB but I get all sorts of bugs occurring when I do this.
  11. C

    Calculating fields within a Record

    Cheers. Makes sense.
  12. C

    Calculating fields within a Record

    I want to calculate a field based on the values of others fields in the same record. I have put an equation in the control source property which generates the correct result but this doesn't write the result into the table that the form is linked to.
View older results
Back
Top Bottom