Search results

  1. G

    Very poor performance on multi-join query

    Hi all, I'm having some serious performance issues with my query. All tables are setup with unique indexes. The main table has ~500k rows and most LUTs have <300 rows (except for tblDataConnected, which has ~250k lines). I'm using Access 2010 with an ACCDB database on XP. Not all columns...
  2. G

    Check if function or sub exists

    Hi there, The following code will check whether a given procedure, function or sub exists in one of your VB projects modules: Required reference: -Microsoft Visual Basic for Applications Extensibility Function ProcedureExists(ProcedureName As String) As Boolean Dim m As Module, mo As...
Back
Top Bottom