Search results

  1. C

    main form shows record selected within datasheet subform

    Hi guys, searched around for awhile with this one but none of the 'solutions' seemed to work for me, the situation is i have two forms, looking at the same table, but the main table shows more records, i would like to select a record in the datasheet subform and have the main form flick...
  2. C

    field is populated by the total of 5 other fields

    hello, as stated in the title i would like to sum up 5 fields and save (or just show it in the form view is enough really) in a seperate field, i have managed to sum the 5 fields, but it summed up all 5 fields in all records, i'd like to have my form show the sum for the record, not the table...
  3. C

    SendObj - working, but can it do this?

    hi all, i have nocked up a button to send an email with the information gatherd from the record. is it possible to set the emails flag date-due for the person while the email is sent? the email is sent using the SendObject command. thanks for any help.
  4. C

    Hey guys, field values based upon other fields problem

    hi, heres what i want to do. i want field 2 (Address) to be based off field 1 (Names) so, name = John address must be = Street1 is this possible? ive tryed to put in the afterupdate part this: If Me.name = "john" then me.Address = "Street1" doesnt work, but no error, help requested, thanks
  5. C

    delete queries, a possibility?

    Hi all, never made one, never used one, but now i think i need one. a delete query. what my setup is at the moment is a table has had a make query table used on it to produce a very similar setup table, containing the same information using an append query, but less fields due to not wanting...
  6. C

    merging two fields into one (with a twist)

    Hi guys, first post my problem is quite simple (as far as i can tell) but none-the-less i'm stumped. what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it...
  7. C

    merging two fields into one (with a twist)

    Hi guys, first post my problem is quite simple (as far as i can tell) but none-the-less i'm stumped. what i want to do is merge 2 fields into a separate field with the first field being Unique_Id (autonumber, indexed and no dupes) merge with the second field Type (3 letter field) so it...
Back
Top Bottom