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!

  • Congratulations strongm 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: shaunhubbs
  • Order by date
  1. shaunhubbs

    Date converted to 35 day calendar

    First, thanks to George for the fantastic solution. It works very well for my application, despite there being the possibility of a 36th or 37th day (if a 31 day month begins on a Saturday). The rules are simply that when we enter our operating room block schedule there are 35 days in a month...
  2. shaunhubbs

    Date converted to 35 day calendar

    Hi all, I am working with operating room statistics and need to convert a given date to it's position on a 35 day calendar (as operating room blocks are assigned based on this type of calendar for a given period). The 35 day calendar starts on a Sunday in Week 1 (day 1) and goes to Saturday in...
  3. shaunhubbs

    Global recordset?

    Thanks for that response as well vbSun. That makes perfect sense and I will keep that in mind in case I do need both the WHERE and GROUP BY in the future. - Shaun
  4. shaunhubbs

    Global recordset?

    Thanks for the response Bob. I am using Access, but an ADP file so there is no linking to the tables. Your response seems feasible, but as you mentioned "depending on the size of the tables". Anyway, the tables will be very large in the end so I may consider using filter/finds, but I believe...
  5. shaunhubbs

    Global recordset?

    Hi all, I have a visual basic form that is uses a treeview and every time a node in the tree is clicked the information for the selected item load in the right pane. The problem I am having is that the information seems to be loading fairly slowly because it runs the same SQL select statement...
  6. shaunhubbs

    Imagelist

    Hi all, I am trying to add icons beside nodes in my treeview and am not able to do so with the following code: Do Until rs.EOF Dim imgVar As ImageList Form_frmSetsTree.imlIcons.ImageHeight = 16 Form_frmSetsTree.imlIcons.ImageWidth = 16 [COLOR=red] Set imgVar...
  7. shaunhubbs

    Treeview sort

    Hi all, Am I under the correct impression that when setting the .sort property on a treeview to true that it is sorted alphabetically? The problem I am running into is that it seems to only sort alphabetically on the root set of nodes. In my application the root is always a SET of instruments...
  8. shaunhubbs

    Make parent node visible in treeview

    Thanks Max! I had just got it as well with the index: axTreeView.Nodes.Remove axTreeView.SelectedItem.Index
  9. shaunhubbs

    Make parent node visible in treeview

    I definitely had that thought as well. Unfortunately I cannot seem to get the syntax on removing the selected node. Any suggestions? Thanks again. - Shaun
  10. shaunhubbs

    Make parent node visible in treeview

    Here is what I have: Dim DeletedParent As Integer DeletedParent = axTreeView.SelectedItem.Parent.Index ... axTreeView.Node(DeletedParent).Expanded = True And now I am getting: 'Object doesn't support this property or method.
  11. shaunhubbs

    Make parent node visible in treeview

    That's where I am having the slight problem Max...the syntax... I have a variable called 'DeletedParent'. Should I set it equal to the index, key or description? From there what is the syntax for getting it to be 'expanded'. Is it axTreeview.Node(DeletedParent).expanded = true or something...
  12. shaunhubbs

    Make parent node visible in treeview

    Hi all, I was wondering if anyone knew how to make the parent node visible after deleting a child node from a treeview. I know how to get the parent information -- whether it be the index, key or actual description, but I can't figure out from there what I should use to display the node. The...
  13. shaunhubbs

    Populating TreeView

    BAH! It was an error in my table. Something got a little messed around in my data and wouldn't load into the tree correctly. Thanks to both of you again for your help though. - Shaun
  14. shaunhubbs

    Populating TreeView

    I tried using the Option Explicit at the top of my code (what did you mean by IDE George?) and I still get the Type Mismatch. Also, to do the 'Compile' from the 'Run' menu I had to edit some declarations that I got away without having before. Any other ideas as to why I would still get a type...
  15. shaunhubbs

    Populating TreeView

    Thanks George. That seems to let it all compile now, but I am still getting the 'Type Mismatch'. Anyone have any ideas on my question #2? The parameters I am passing to the function appear to be a treeview and a string so why would I get a type mismatch? Thanks. - Shaun
  16. shaunhubbs

    Populating TreeView

    Thanks for the response Trevor. I am hoping you can help me troubleshoot a couple of things with the code though. 1) Should the first piece of code be declared as a "Public Function" rather than a "Public Sub"? 2) Any idea why I would be getting a 'Type Mismatch' when the code goes to execute...
  17. shaunhubbs

    Populating TreeView

    Hi all, I am having a problem with populating my TreeView once I get down to the 4th level (way at the bottom in red). In my code below you can ignore the SQL SELECT statements that I am using to set the sources as they are correct. I have tested them in separate views. But once I get to the...
  18. shaunhubbs

    Treeview

    Yep, I am satisfied with what it does for now. I am sure some minor modifications could be done to make it even more effective. Thanks George. - Shaun
  19. shaunhubbs

    Treeview

    That seems to work quite well actually George. Thanks again for your help. I had to do nothing to that code to make it work for me. Thanks. - Shaun
  20. shaunhubbs

    Treeview

    It doesn't seem to work for me... When it hits the .Child it says that that's not supported. I tried this instead: For Each Node In SelectedItem.Nodes Node.Expanded = True And of course that would've been too easy. I did manage to get all to expand with: For Each Node In...

Part and Inventory Search

Back
Top