Search results

  1. C

    Edit data in datasheetview based on query with linked tables

    Hi, I have a query with two tables (inner join). When I create a datasheetview-form for this query, I can only update data of my main table. When I want to change data of the many-table, I always get a write conflict: "This record has been changed by another user since..." (but no-one else...
  2. C

    Listbox selection lost after requery

    Hi, The requery is necessary, because the user can select a line, open the item in a different form and change certain fields. When he closes the form, the changes also need to be reflected in the listbox. Christophe
  3. C

    Listbox selection lost after requery

    hi, I have a listbox (multiselect: extended) in Access. You can select one or more lines and view those more in detail in a new form. When closing this form, the list is requeried, but then the selection gets lost. The listbox used to be a multiselect : simple. Then there was no problem, the...
  4. C

    Create excel file from Access and enter 'Round' function in a cell

    Thanks, it works. (The comma is replaced automatically by a semicolon in the final excel though on my computer) christophe
  5. C

    Create excel file from Access and enter 'Round' function in a cell

    Hi, I create an excel-file with VBA code in MS Access. When I want to enter "=ROUND(Sum(H26:H30);2)" as the value of a cell, it gives me an object-oriented error, but the formula works perfectly in Excel, so there is nothing wrong with the formula. Access-code: mySheet.Cells(irow...
Back
Top Bottom