Recent content by Andre Bruin

Hi, thanks for your replies. I want to change the code to SQL, but I struggle with the multiple conditions. Can somebody make my Dlookup function into a SQL code? Thanks in advance, rg, Andre

Hi, I've tried already with a query, but that's very slow as well. And now I'm using the Elookup from Allen Browne's already, but with the same result. The form is a single form with 780 unbound textboxes and it is a sort of Calendar which is used for a planning. At the moment it takes about...

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]"...

I get an error with 'Dim xlWB As excel.workbook' "The datatype is not defined"

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é

Hi, it's solved. The problem was the headers of the table in Access and the Excel sheet. They were not equal and that causes the error. rg, André

I get the error in below line: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tablename", strPathFile, True, "deliveries!A1:C2" for now the name of the table is really "tablename"

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...