Search results

  1. T

    Stupid simple syntax problem: Iff (IsNull...)

    Hello world, I'm trying to replace all the blank values within a table (the table is named "Methane_all2") for a field called "Var01". I'm using expression builder within a simple Select Query. The expression I have in there is: =IIf ( IsNull ( [Methane_all2]!["Var01"] ) , -9999 ...
  2. T

    Create relationship as each excel table is imported into db

    Thanks for the tip... it does get me a little closer, but here's what happens: Now when I run the first Sub, the 1st excel table from the folder is imported, and the 2nd Sub APPEARS to work, but when I go to look at 'Relationships', no tables exist there. Also, after the first time the 2nd...
  3. T

    Create relationship as each excel table is imported into db

    Hello, I’m trying to combine a couple of Subs that I’ve found online. The first one imports every excel file within a specified folder (in the example below, this is ‘strPath’) into Access (but doesn’t set any primary key). The second Sub is supposed to create a relationship between 2...
Back
Top Bottom