Search results

  1. N

    Use Listview to mimic Treeview

    My project has a listview with 5 columns. My data will have groups and subgroups like a treeview. I'd like to use space and the Unicode characters ChrW(&H2514), ChrW(&H251c), ChrW(&H2502). Does anyone know some code that can produce something like the attachement? Thanks! :)
  2. N

    SQL Action subroutine

    Is this a good strategy? Public Function SQL_Action(strSQL As String, Optional fWS As Boolean = False) As Boolean On Error GoTo ErrorHandler Dim db As Database Dim sngStart As Single Dim wrk As Workspace Screen.MousePointer = 11 Try: Set db = CurrentDb If fWS Then Set wrk =...
  3. N

    Dynamic table linking

    Does anyone know how Access can search a fe .mdb's/.mde's directory for the be .mdb's/.mde's and then automatically link to the be's tables?
  4. N

    Trying to elimnate locking errors.

    I have networked frontend and backend databases. I'm also experiencing locking errors (3051) when two or more people are using the frontend interface. I always .close and =nothing any CurrentDB or recordset object. All SQL is executed in the following sub: ' Mouse pointer property Global Const...
  5. N

    rst.close vs. set rst=nothing

    Which is better, closing a database or recordset object with .close or by setting it to nothing?
  6. N

    Getting Module & Sub/Function Names

    I employ an error handler that reports the form name and control where the error occured. ErrorHandler Name, ActiveControl.Name & "_KeyPress", _ "KeyAscii: " & KeyAscii It works great untill we move on to modules. I would like to have the code discover the sub/function & module names...
Back
Top Bottom