Search results for query: *

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...

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...

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

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...

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...

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...

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...

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

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

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.

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...

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...

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

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...

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

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...

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...

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

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

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...