Search results

  1. A

    Retrieving data from a row in a subform datasheet

    Found my mistake. I have using a table as a subform datasheet. I created a form of the table and added that as a subform. Accessing the selected record is available through a mouseup event on the subform using me.currentrecord. I shall go stand in the corner now for being stupid.
  2. A

    how to make insert,update,delete in ms access and vba using function

    My best advice is to create a query then view it using SQL View. You can run the sql command as a string from within vba using DoCmd.RunSQL DoCmd.RunSQL ("DELETE tempPerson.* FROM tempPerson") or you can build and SQL string and execute it, this allows some very complex queries to be built...
  3. A

    Retrieving data from a row in a subform datasheet

    I am developing a database to handle gift aid for a charity. I have a donor selection form that comprises combos boxes allowing the selection of postcode, name, house number. As the user selects data in a combo a subform show as a list of potential donors from the database, as the user selects...
Back
Top Bottom