Search results for query: *

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?

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

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

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

I am using CR 8.5 with VB 6. My users needed the ability to select one of many printers, so I used the following: Private Sub CRViewer1_PrintButtonClicked(UseDefault As Boolean) UseDefault = False 'Don't use the default printer Dim cOrientation As CRPaperOrientation Dim...

I have this error that started ocurring recently. Whenever I close the VB 6.0 IDE, I get the "Visual Basic has encountered a problem and needs to close" error. Everything else seems to be working fine. Any ideas? Rene'

I have some accounting information grouped like: ID Assessment DetID Paid 1 1000 1 100 1 1000 2 500 1 1000 3 200 2 500 4 250 2 500 5 250 I need: 1500...

I have a report parameter that is type string and the related stored procedure has its parameter as varchar(x). The reason the parameter is set up as a string is because the VB app that renders the report dynamically sets up some pre-determined default report parameters and has declared them as...

The search feature has been down, so I hope this question has not been asked too many times. I need to display the parameter description. Can this be done? I am using 8.5 with an SQL Server stored procedure. Thanks, Rene'

I have what seems to be a simple problem, but I can't put my finger on how to do it. I've got a cross tab report that is working fine, except, instead of a count summary, I just want to put an "X" if the count is > 0. So that I get the following: col1 col2 col3 row1 X...

I have a main form bound to a "Contact" table and a subform bound to an "Address" table. The subform is linked to the main form via an AddressID field where Contact.AddressID = Address.AddressID. All seems to work well, except when I have a situation where the Contact table has a null...

I have spoken with CrystalDecisions about not being able to print the drill-down detail on a subreport when rendering in a VB CRViewer and they informed me that this is a known limitation. They do have a workaround, but it entails VB code revisions and I do not have the luxury of...

I have a main report and 2 subreports in a Crystal 8.5 report. The report is rendered in a VB 6.0 application using a CRViewer object. The main report prints fine, the subreport summaries (first page of subreport) print fine, but the drill-down on the subreports will not print. The subreport...

I'm not sure if I have been thinking about this too hard, but here is my problem. I need subtotals on a report and the ability to drill down to the detail behind the subtotals. I understand this part but the presentation is giving me a headache. I have: GroupHeader #1 subtotalfield Details...

I have a VB/SQL Server 7 app that I am working on. I need to save image types to the database but I keep running into an "Invalid Input Parameter Value" error. Here is the VB code and stored procedure: Public Function FileToBlob(ByVal FName As String, _ lngCTXID As Long, _...