Search results

  1. M

    Referencing a fields from a form, from within a subform

    Thanks for the quick reply.... So I have set the Control Source of the text field (of the field I want populated) to be me.Sample!txtKPI_Target But When I test this I just get "#Name?" The form is linked to the subform through a one to many link. If I could utilize this link it may be best...
  2. M

    Referencing a fields from a form, from within a subform

    I know that title is a bit of a tongue twister but what I am trying to do is... I have a form, Called frmSample and a subform called MthData I have a field in the frmSample called txtKPI_Target and I have a field in the Subform called txtKPI which I want to be populated by the above field...
  3. M

    Importing an excel file

    I have a file I wish to import into access every day, I want the duplicates rejected by Access - but when I try to do this it keeps failing the import. I am using access 2003 7 excel 2003. I have an ID field which is the primary key, but I want this set on the excel side of things ? Is this...
Back
Top Bottom