Search results

  1. A

    other method than Dlookup vba form

    Hi, on a form, I've 800 textfields which are filled with data via a dlookup in VBA. Because, it's a little bit slow, I want to use another way to fill this fields with data from a table. See below for the DLookup function what I have at the moment. code: Me(k1) = ELookup("[KLant]"...
  2. A

    Check if Excel workbook is open in Access

    Hi, I'm importing data from an Excel file via VBA Access. Every 5 seconds Access checks in a folder if an Excel sheet is available. Now I want that Access first checks if the Excel file is open already and if the file is open, it should be ignored. thanks in advance, rg, André
  3. A

    Error with DoCmd.TransferSpreadsheet

    Hi there, I want to import several Excel sheets into a Access table. I'm using below code, but for some reason I get an error message "error 3270 property not found" code: #Sub Import() Dim strPathFile As String, strFile As String, strPath As String Dim strTable As String Dim blnHasFieldNames...
Top Bottom