Recent content by viennese_finger

  1. V

    Referencing a form control from a Query.

    hi all - not sure if i should reply to this or start a fresh post...? anyway, here goes: I have a form (frmQuotesIssued) with a subform within (qryQuotedServices subform). It is the subform I'm interested in. The subform contains records that relate to the main form ID (one-to-many). the...
  2. V

    change date field/control using a button

    Ok, pbaldy and Minty - it makes sense - I will go with that Thanks a lot for your help Matt
  3. V

    change date field/control using a button

    Hi - I have a form with a DateModified field/control. This field records the date an event occurs; this also causes a phase change in the main process. The DateModified control is blank by default until this event occurs. I am using a button ("Date modified"; on-click event; code builder...
  4. V

    two comboboxes on a form: values and queries

    Thanks for the reply - I think I have updated the Row Source for the 2nd combobox: SELECT tblClusterSeqKit.ClusterKit FROM tblClusterSeqKit WHERE (((tblClusterSeqKit.ClusterKit)=[Forms]![frmRNASeqProjectPlan]![Combo654])); running the query appears to give the correct results. but I'm not...
  5. V

    two comboboxes on a form: values and queries

    Hi - I have a database for Project management and project costing. Tables are like this: tblProject - summarises use of SeqKit and ClsuterKit for each project tblClusterSeqKit - relationships between each SeqKit and the appropriate ClusterKits that go with them - there are many ClusterKits...
  6. V

    Help calculating the sum of all costs associated with a unique ID

    Thanks - I run a biotech research lab where we run contract research Projects on behalf of other labs. The projects have lots of options involved, lots of picking from lists, and other entered data too. We record each project enquiry currently using Excel, use lots of dropdown lists and VLOOKUPs...
  7. V

    Help calculating the sum of all costs associated with a unique ID

    Thanks for the quick reply - all that sounds great - I am doing a larger design which incorporates dates and lots of other info - I wanted to boil down to this single issue to start with (there are others too). I have another table above projects (tblEnquiries) that I view as a form with...
  8. V

    Help calculating the sum of all costs associated with a unique ID

    Hi - I have a similar issue - perhaps I could give more details of my problem, see if that helps?? i have a table, which lists number of a specific type of kit is used in a project tblProjects ProjectID KitUsed Quantity and I have a separate table, where I store the costs of using each kit...
  9. V

    greetings from london

    Hi - new user here. been on a couple of training courses and trying to relate what I've learned to my specific needs: it's not always easy to map your own data onto example data... i run a research lab and have a need to manage various datasets (project management, sample/LIMS, financial stuff...
See more
Back
Top Bottom