Recent content by gadgetguy1111

Thanks. problem solved. :-)

thanks zemp. Give u a star. :-) -- Boon Kee

Hi, I'm passing the values of a recordset to another form which has to be shown modally so that the user can react to it before I move to the next record. The trouble is that vb doesn't allow forms to be shown modally in a MDI app. I have used timers on the parent form (disabling the timers...

hello, I'm using a toolbar from the ms common window controls. I realise that the width of all the buttons placed on the toolbar are the same. the buttons have caption. So, the width of all the buttons are same with the button with the longest caption. Any idea how i can set the width of the...

hello again. looks like i have solved half of my own problem. found this artricle: http://support.crystaldecisions.com/library/kbase/articles/c2003185.asp still, is there a better workaround than what is suggested? thanks. -- Boon Kee

Hello, i'm using CR7 and VB6. Integration is done using ocx. For a report that is a crosstab, i inserted another cross-tab as a subreport in the report footer section. The main report's crosstab successfully spanned across a number of pages. The trouble is the subreport is contained within...

Hello, I'm creating a disconnected recordset to pass data for temporary storage. while creating the fields, I used: recForex.Fields.Append "Forex_A", adDecimal, 5 The problem I don't seem to be able to specify the precision of adDecimal. As such, data passed to this field are...

Hello, I'm using vb6 and cr7 for this project. The report i'm creating uses data returned from 2 stored procedures. Each stored procedure takes the same input parameter. I'm facing problems passing the parameter to the second stored procedure in VB. the code is as follows: CR.Connect =...

hello, i'm trying to populate a datagrid by setting its datasource to point to a recordset. The problem is sometimes, the data displayed in the grid contains underlines. I believe this this is due to the ampersands in the data. the issue is sometimes this appears in one grid but doesn't in...

Hello, I'm trying to write a shape statement to relate one table to another. the problem is the fields relating these two tables together is concatenated. so a command like shape {sql statement1} as Header append ({sql statement2} as Details relate Header.field1 to Details.field1) as Details...

hello jason, yes. u are right. the _AfterColEdit() does allow me to do the validation. the problem is if i find an error in the value, how do i cancel the update to the recordset? thanks. :-) -- Boon Kee

hello Niraj, your suggestion didn't really worked as the the event is triggered before the change is completed. eg i had originally entered 200 into the grid and would like to change it to 1000. Correct me if i am wrong here, i don't think i can key in the 1000. the event is triggered when i...

hello, I'm using a datagrid to allow my user to make changes to the data in a recordset. currently, i am using the datagrid_AfterColEdit event to allow me validate the information changed. the problem is i don't know how to cancel the update should the information changed be tested invalid...

many thanks. :-)

hello, i'm using labels to display data retrieved from a recordset. i chose to use labels instead of textboxes (i am aware that textboxes can be locked to prevent editing) so that my user will know that the information cannot be changed. the problem is that some of the data to be displayed...