Recent content by rdeleon

Hey Riverguy, thanks for the response. I really am not into doing something "just to do it", so maybe I am not looking at this from the correct point of view. The biggest problem I have is not knowing how Microsoft is going to support Excel working with COM/dll in the future. I guess I could...

I am not sure if this is the correct forum to post, but.. I have a dll that was written in vb6. An Excel spreadsheet references the dll. I want to get away from vb6, but I am not sure how to go about it. How does Excel "play" with .NET? Is the Excel/dll architecture still supported using...

I am trying to upgrade a VB6 dll to VB.NET and I am brand new to VB.NET. I used the conversion tool and the dll compiles, but I get {"Object reference not set to an instance of an object."} errors in variables that I have defined in a module. Here is my simplified code. In module: Public...

Not sure if I am over/under thinking this. I have a table: OWNED_GUID OWNER_GUID FRACT_OWNED EFFECTIVE_DATE X_UPDATED {D4662394-8B75-4FD4-BE31-4F1A7DF616AB} {6DDEA9E6-2493-49C8-BD02-A88F9684459D} 100.00% 01-May-09 15-Feb-10 {25EA6970-8EAA-4B8D-99D6-DDA1E74F9422}...

I have a workbook with >15 sheets with vba code and contols on some of the sheets. Copying sheets from the workbook to another copy of the workbook works in 2003, but Excel 2007 crashes when I attempt the same operation. Simple sheets, with no controls, seem to copy. Any one having this problem?

I have some Crystal Reports XI reports with date parameters that are not working with Vista/IE8. When you select the calendar icon on the date parameter to show the calendar, a blank box displays. Clients with Vista/IE7 are working fine. Has anyone encountered this error?

Thanks PDreyer. I just realized that I also need to be able to group by week and month. (I realize my previous data was off in the last post) Date BeginValue EndValue 12/1/2008 04:00:00 0 100 12/1/2008 10:00:00 100 600 12/1/2008...

sql 2005 I have a table that looks like: Date BeginValue EndValue 12/1/2008 04:00:00 0 100 12/1/2008 10:00:00 100 600 12/1/2008 18:00:00 600 400 12/2/2008 11:00:00 0 200 12/3/2008 10:00:00 300...

I am using CR 11 and have a crosstab with the information I need, but I was hoping there was a way to conditionally format a particular crosstab row. Here is what I have: Type1 Type2 SubType1 SubType2 SubType1 SubType2 Row1 2/10/05...

Yes, that is what I am having some problem with. So lets take your scenario and the "in use" period was from 6/1/05 22:00 thru 6/2/05 04:00. If the user wants the utilization for 6/1/05, I need to give them 2/24 for the 6/1/05 period. If they select 6/1/05 - 6/2/05, I give them 6/48. I am...

I am tracking the use of a resource with the following table structure: rID rDateTime rStatus My status is basically "in use" (1) or "idle" (0) and a record is written each time the resource goes in and out of each status. I am calculating the number of hours that a resource is "in use" by...

You're right! I want the latest record for the activity type, but I need the activityaction to let me know what happened to the latest activity type. Rene'

Thanks hmckillop, but I realize I didn't give you the whole picture. Here is my problem: ActivityType ActivityDateTime ActivityAction 1 4/1/05 11:00 am A 2 4/2/05 5:00 pm C 1 4/4/05 4:00 am B 1 4/5/05 3:00 pm A 2...

I have an activity table with the following structure/data: ActivityType ActivityDateTime 1 4/1/05 11:00 am 2 4/2/05 5:00 pm 1 4/4/05 4:00 am 1 4/5/05 3:00 pm 2 4/6/05 11:00 am 3 4/6/05 1:00...

This is taken from the Crystal help file: ToWords(12345) Returns twelve thousand three hundred forty-five and xx/100. ToWords(12345.6749,2) Returns twelve thousand three hundred forty-five and 67/100. Hope it helps. Rene'