Search results

  1. L

    Edit values in linked table error 3021

    Dear Experts, I have a strange error in my system. I have ODBC linked tables to a DB2 database. When I try to edit the values in some of the tables (open the table in dataview and edit one record) I get a 3021 Error -No current record. On other tables (linked the same way) I don't get this...
  2. L

    Run-time error 3021 while updating existing record in DAO Recordset

    Dear experts I need your help, I have a linked table to a DB2 database. this table contains key-pair values and has about 140k records. I use a Sub to update the value of a specific record. The sub starts by opening the needed DAO recordset Then it uses the rs.Findfirst method It checks if...
  3. L

    Add Percentage sign to a text field without changing value

    Dear Experts, I am trying to add a percentage sign (%) after a number I get from a table, thus the number 1,5 should display 1,5% and NOT 150%. I am using the Format Property of the text field. I tried #,##% which converted the value to a percentage (1,5 became 150%) Then I tried #,##"%" and...
  4. L

    Change number of columns in a report

    Dear experts I need your help! :-) I have a report that constists of 4 subreports. I need the first two subreports to render in a two-column format and the 3. and 4. in a single column format. Unfortunatelly I cannot it work as I need to. I have read, that setting the main report in a...
Top Bottom