Recent content by 557

If the name of the 2nd form is secondfrm, you should put your declaration as dim form2 as new secondfrm form2.show

Teach Yourself VB.net in 21 days is a really good book for beginners. Everything you have asked for is explained in easy steps.

Thanks a lot earth and fire. I could use this tip for many form related issues I was facing. :-)

suppose I have 2 forms. I need to call 2nd form from 1st form. when frm2.show() is given, I want to disable frm1. and when frm2 is closed, i need to enable frm1 again. How do I do this?

Can anyone pls tell me how to output contents of a table in sql server into a excel file pls

insert the date field as null (without quotes) eg:- insert into test_dates values('aa',null)

I think you'll have to use the 'mouseup event' if you want to capture all the changes in the value irrespective of the speed at which the click events take place. when the speed is high and the clicks are similar to double clicks and if the value changes from 'select' to 'unselect' to...

johnyingling, thanks a lot. your program worked perfectly. the only issue was that if there were too many combinations, it takes too long. is there any way we can eliminate a lot of unwanted numbers??

is there any maximum number to which the autonumber will be set? each time, i'm clearing the table and adding new set of records. at that time, the autoincrement will not get reset. so, will the autoincrement number fail at any point of time?

not an intellectual exercise. there is a requirement. i've come up with an algorithm. i'll get back if it doesn't work as expected

thanks

i have a table with one field set as autonumber. if i want to insert records into this table from another table using sql, insert into table1 select * from table2 will the autonumber field be updated automatically? how exactly should i give the sql to insert all the fields in table2 into...

i'll get back to you with the details

thanks r937

cbsm, i also had the same feeling. maybe a stack and recursion should be used to implement that logic, right?