Search results

  1. O

    Select Case: IsNull or Equivalent?

    I'd use If statements for that first Case block as that can capture all the errors, not just the first one? Aircode: If Not IsNull(Me.sdtEnd) Then If Not IsNull(Me.sdtPtp) and Me.sdtEnd < Me.sdtPtp Then msg = msg & "End date cannot be before P date." & vbNewLine...
  2. O

    wrong English grammar in format compatibility mismatch warning

    Well English is the only language I speak and that message seems fine to me? Excel throws it when someone renames a delimited text file to xls for example. What do you think it should say?
  3. O

    System Resource Exceeded

    Seems like it's still solid advice, the MS docs even recommend turning it off in applications where the schema doesn't change much. Good thing I wasn't following it though, or I would have struggled to find this particular problem.
  4. O

    System Resource Exceeded

    Happily I managed to track down the cause in my case. Seems another table not even accessed by this query was corrupted in some obscure manner (no db corrupt error messages, Corrupt and Repair function has been run several times without identifying/resolving it). Importing all tables into a...
  5. O

    System Resource Exceeded

    Unfortunately I don't have an explanation, but ran into a similar problem this week. This simple SQL, which is being generated via VBA, fails with a System Resource Exceeded error message on my work machine (i7, 16GB, Win 10, Access 365 64-bit): SELECT SIGHTING_ID, LOCN_PRECISION...
  6. O

    G'day

    Hello from Australia. Not a coder per se (my background's in wildlife conservation) but have been working with Access VBA applications since 97. Foolishly my workplace has switched to Access 365 64-bit, so a few challenges to research fixing old 32-bit applications. Cheers, OldeCow69
Top Bottom