Search results

  1. N

    Split Text From Excel To Access Then Recombine

    Hi, My database has a seperate table for comments. The Excel s/s I want to import has a single column for comments eg '28/10 Phoned Patient, 29/10 Patient confirmed appointment, 30/10 Saw Patient'. I want to convert this column into my table as seperate records eg PK: 1016 Ref: 11293 Date...
  2. N

    Update field on subform with calculation

    Hi All, I have a form with a value field on it. I also have a subform on the main sheet. When I update the field on the main form, I want a field on the subform to equal 50% of the value. I'm sure this is simple, but I've tried everything and can't for the life of me get this to work. Can...
  3. N

    Help!!! DLookup returning #Error

    Hi All, I'm new here, and found the site when looking for some help on a DLookup problem. I'm just about to pull the rest of my hair out. I've tried just about everything - even copying and pasting the code directly from the Microsoft site. My form has a Combo box, which links to a table...
Back
Top Bottom