Search results for query: *

Hi there. I've been struggling with this for a bit now and it might just be a quick algorithm and I'm missing something. I'm using VC++ 2005. I have 5 panels (all the same size) on a windows form and I want them positioned across the width of the form. I want one panel on the leftmost side...

I want to send fields to a crystal report at runtime, depending on the user's selection in a VB6 program. Is this possible? I'm using a dbaseIV database and ADO (DAO) in Crystal to set up the report and ADODB in VB6.....

I want to send fields to a crystal report at runtime, depending on the user's selection in a VB6 program. Is this possible? I'm using a dbaseIV database and ADO (DAO) in Crystal to set up the report and RDC in VB.

Hi. I've got one table with multiple children tables off it. I've got individual SPs for each of the tables that either updates the record or insert it if it doesn't exist. I have to update the tables thru VB6 and I'm not sure about something. Can someone tell me if its better to have...

I have a report set up like this and I need to write a function that calculates a running total to get the Net values (from a starting value which is supplied). Say the starting value is 20, the results should go: Field1 Field2 Add Sub Net ------------------------------------- 12...

In my view, I'd like to do a subtraction on two fields, but both values can contain nulls. When one field has a value and the other is null, the calculation returns null. Can someone show me how to do this so it adds the value that's not null to the null one and get an actual value?

I'm using a stored procedure to insert records into an sql db through Visual Basic (very new to sql server programming). My question is, should I be performing error checking in my program code or in the stored procedure itself? (Error check such as make sure an entry is a number or string...

Is there a way to pass a parameter into the query of a SP for the table name? If you send in "Table1", the query is: SELECT * FROM Table1 and if you pass in Table2, the same query becomes: SELECT * FROM TABLE2

I have 2 MSHFlexgrids. One is setup just for header information (it is just 2 fixed rows) and the other is the details for the data. What I want to do is, when the user resizes the headers in the first grid, the same effect takes place on the second grid both grids continue to look like one...

Hi all. I would like to merge the headers of my grid (I use two rows as the header). I have set it to .MergeRow(0) = True and .MergeRow(1) = True and set all my MergeCols to True also. The problem is, I just want the headers merged, not the rest of the grid, but it is merging all of the grid...

Hi there. I need to intercept a call to Shutdown or Log Off thru a VB6 application. I found this code, but it doesn't appear to work: Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) If UnloadMode = vbAppWindows Then 'Windows is shutting down; put code here...

Can someone help me write an UPDATE query that sets the Date of Table1 equal to the Max(Date) in Table2 where the tables are joined on Table1.ID = Table2.ID?

Can someone help me write an UPDATE query that sets the Date of Table1 equal to the Max(Date) in Table2 where the tables are joined on Table1.ID = Table2.ID?

Can someone help me write an UPDATE query that sets the Date of Table1 equal to the Max(Date) in Table2 where the tables are joined on Table1.ID = Table2.ID?

Has anyone had such a problem? When I try to refresh my crystal report (8.5), I get the Microsoft error "Crystal Reports has encountered a problem and needs to close...." and then I get "The instruction at 0x73dd1351 referenced memory at 0x00000004. The memory could not be read" Can someone...

Can someone show me how to create a crystal report viewer programmatically?

Is there a way to sum a summary in CR8.5? I have a report grouped on EmpID then on Date. Using a formula, I managed to pull out the total number of hours worked on each date for this month and now I want a grand total of that.... My formula for getting the Hours for this Month is: if...

Could someone give me a hand here? In my report (CR 8), I need to show the Hours each Employee worked this month. I've tried creating a formula that says: If Month({Employee.FINISHDATE}) = Month(CurrentDate) then Sum({Employee.HOURS}) But that's giving me the total hours of all employees....

Can someone take a looka t this and tell me what I'm doing wrong? THis is the first stored procedure I've ever written :-( If I'm supposed to post this in the VB forum, plz let me know. This is the procedure: CREATE PROCEDURE CUSTOM_UPDATE_REQSTION @p_REQUISITIONNUM_in VARCHAR(20)...

Hi everybody. I'm not sure if I should be posting this here or in the SQL Server forum. I need some advice on whether to use a client side or server side cursor. My program (VB 6) is reading from the SQL Server and is used by many people which makes me think I should use a client side cursor...