Search results for query: *

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

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

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

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

Hi all, I am trying to create a simple form in Access to display a tree full of Sets with Items in them. The problem I am running into is, I believe, the syntax/parameters used by the TreeView ActiveX control. Here is some simple code that I have written in the Form_Load even; any ideas why...

Hi all, I am running CR9 and am trying to come up with a way to alternate colors within the detail section, but it is not quite as simple as alternating for each line. In some cases I actually want the color to repeat so the REMAINDER function I had used previously does not work. The scenario...

Hi all, I have times stored as integers (Eg. 2351 = 11:51 PM, 955 = 9:55 AM) and I need to calclute the amount of minutes between them. Anyone have any suggestions? TIA. - Shaun

Hi all, I am using CR9 to create a report that contains the same information twice, just sorted differently the second time through. I have a main report and then a subreport to accomplish this, but it runs very slowly as each time it hits the subreport in the group footer it implements the...

Hi all, I am using CR9 and am trying to copy a report, but make it change the datasource location. The new datasource has the exact same information with the exact same column names as the first, just the SQL statement is using an extra UNION statement to bring in more information. So I go to...

Hi all, I have a main report that has the items "picked" for a surgery (called a "pick list") and it contains two subreports: (1) an "explosion" list that contains those items that are in a set specified on the "pick list" (2) a "worksheet" that has the same items picked on the "pick list" only...

Hi all, I have a report that I have created that contains information on what items need to be "picked" for a surgery. This list can also contain sets that also have a list of items in them. What I have done is created the pick list and then in the group footer (grouped by surgery) I have...

Hi all, I have a problem with a custom function that I want to be able to use for views, reports, etc. The problem is that I already have a function that does exactly what I want it to, but when I copy it and change it to specifically what I need (I only change a table name and field value...

Hi, I have produced a report that gives me a breakdown of the number of surgeries that have been booked at a hospital by hospital and then further by a category. (Eg. Hospital #1 has stats for General Surgery, Urology, etc. and Hospital #2 has its own stats for the same categories.) What I...

Hi, I need a little help with getting a calculation working here. I have a report which is used for a health region and I am trying to gather the total number of theatre hours needed (for the whole report) so that I can then get a percentage for each details line. I am using Crystal 9. How...