Search results

  1. P

    Querying on date fields originally populated with value from FileDateTime

    I have a table in Access that contains a list of file names and their modified dates, which is used to check if a certain file in a filing system has changed. The file modified date field is populated using the output of FileDateTime. However, whenever I query this table using the file name and...
  2. P

    Question Saved Excel import not respecting configured Indexes

    I'm having an issue whereby I set-up and configure an import of an Excel spreadsheet into Access 2016. I carefully configure which fields I want to have as an index and which fields should be skipped, and then opt to save the import for future use. The import on its first run is successful and...
Back
Top Bottom