Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cj44
  • Order by date
  1. cj44

    create new folder

    Dim strDir As String strDir = Dir(&quot;C:\Users\*.*&quot;, vbDirectory) Do Until Len(strDir) = 0 If Left(strDir, 1) <> &quot;.&quot; Then MkDir &quot;C:\Users\&quot; & strDir & &quot;\MYWORK&quot; End If strDir = Dir() Loop
  2. cj44

    Access 97 Report Viewer

    I'm just finishing up the code. Alphanytz, if you could reply with your email address I'll send it to you too.
  3. cj44

    Access 97 Report Viewer

    I've been working on a converter of Access reports to HTML, that preserves all controls (including lines). It's not completely finished/tested, but if you want I can email it to you.
  4. cj44

    Filter by month

    You could try something like &quot;MONTH(DateField)=&quot; & (comboBox.ListIndex + 1) as a filter.
  5. cj44

    User resizing of controls

    What's a good way to handle user resizing of controls on a form? E.g., allow user to resize a frame on a form?
  6. cj44

    Dictionary object

    You need quotes around &quot;Scripting.Dictionary&quot; -- Set d = CreateObject(&quot;Scripting.Dictionary&quot;)
  7. cj44

    Structures and Pointers

    'Sorry, I didn't test this code first, that should be: Property Get NextNode() As clsNode Set NextNode = mNextNode End Property
  8. cj44

    Structures and Pointers

    You can also define a class for a node, and include one or more pointers to the node's class inside the class definition. Then use the New keyword to create new nodes, and link them with properties: For example (This module is named clsNode): private mNextNode as clsNode 'Other variables you...
  9. cj44

    SQL help

    You can't use = NULL, you have to use IS NULL. I would rewrite your query as: SELECT * FROM tblClaim WHERE NOT (AppraiserLastName IS NULL) AND DateClosed IS NULL Hope that helps.
  10. cj44

    Access returns update confirmation?

    It depends on whether you're using DAO or ADO. With DAO, use the dbFailOnError option and the call will generate a run-time error if, for example, the query can't execute because it would cause a key violation. With ADO, the call will generate a runtime error if not successful, also you can...
  11. cj44

    recursively creating folders

    'Here is code I have used in the past (it works on UNC 'paths as well): Public Function MkFullDir(strDir As String) As Boolean On Error GoTo err_MkFullDir Dim strParentDir As String MkFullDir = False strParentDir = ParentDir(strDir) If Len(strParentDir) > 0 Then 'Not At...
  12. cj44

    Command_Click doens't work

    The name, cmdResultaatTicketVerkooplijnVerwijderen, is 40 characters long. The VB help says 40 is the maximum length for a name. This means the sub cmdResultaatTicketVerkooplijnVerwijderen_Click might be too long for the system to process. I'm not sure if this is your problem, but you could...

Part and Inventory Search

Back
Top