Recent content by RiderOfTheli

  1. R

    Question How to update records with criteria

    Hello, I've got database, with few table, queries and forms. The aim of the database is to send letters to the Vendors. First, I upload data into Access tables from our system, but there are few additional infomations on the letter, which are not in the main data (for example Posted, Blocked...
  2. R

    Merging and deleting duplicate records

    Privateer, Thank you very much, unfortunately it's not working - and I dont know why...hmm. Ive got also this code: Private Sub Command15_Click() 'On Error GoTo cmd_End_Click_Err Dim tdf As TableDef Dim fld As Field Dim dbs As Database Set dbs = CurrentDb Dim strSQL As String Dim sf As String...
  3. R

    Merging and deleting duplicate records

    Hello! I have an Access table with a number of records which refer to the same [InvoiceNo] but with data in different fields. Normally, my database works like this: 1)Import data from Excel File to tblMain in Access 2)Import data from Excel File to tblVendorLine in Access 3)Import data from...
Back
Top Bottom