Search results for query: *

Hi - is it possible to cycle through a recordset in com+ from the client i.e. with objCom .recCom.MoveFirst while not .recCom.EOF 'do some stuff .recCom.MoveNext wend end with When I do this each call to recCom appears to reset the recordset so that I always return...

In vb 6 you set an object to nothing. What's the best way to destroy an object and force garbage collection? I have used the following code to destroy a form, it works but seems a bit 'over the top' - grateful for your suggestions. frmNew.Close() frmNew.Dispose() frmNew = Nothing

Hi - how on earth do you reference a control on one form from another? in vb6 it was for instance: frmMyForm.MyControl.Text="Whatever" how do you do it in .NET? many thanks

Does anyone know of a (free) tool that acts like enterprise manager for MSDE? I'm recovering from an op & bought Vb.net stnd to brush up on my skills. Installed MSDE but used to the manager at work so finding it a little difficult to manipulate now at home. TIA - Nigz

I've in stalled the SQL server engine which comes with VB.Net Standard but how do I create a new database? I managed to create a create databse stored procedure in the master db and it appeared to run OK. However I can't see it - although if I try to run the sp again I get a message saying...

I have a problem with an sp which uses the sp_executesql statement - the app has a vb front end when running in debug all is ok but once compiled we get a 'permission denied' message - any ideas? many thanks Regards Nigel

I am trying to write an app which uses the JoyStick (using vb6 on xp home) I have an old sidewinder pro and whilst I can detect joy movements and button presses I cannot find a way to detect rudder movement or the other one (which I can''t remember the name) Basically I want to detect twisting...

OK I have been looking into this now for a while - basically we have written an n-tier app VB6, COM+, SQL2000 but we are unsure which is the best way to reference objects. Advice seems to differ and alot of it appears to deal with MTS ratyher than COM+. So initiating a new com+ component from...

Hi - I've just started playing with layers - I have a number of layers nested within a container layer - but how do I center the container layer using align="Center" seems to have no effect. Thanks Nigz

Hi - I have 2 disconnected recordsets both with same number of fields with same field names and I just want to combine/merge them. What's the best way to do this? BTW there will not be duplications as the key value is unique across both. Thanks N

Is it possible to access joystick movements, button presses etc - can anyone point me in the right direction - cheers

Can anyone recommend a good datagrid control? Kind of thing I want to do is colour individual rows etc. many thanks Regards N

Hi - I want to use the following type in a class - but I can't seem to get the syntax right. VB6 won't let me declare a public variable of type FormRecordsets and the following code, although it doesn't fall over doesn't work either. I would be grateful of any pointers, thanks! Public Type...

Hi - I want to use the following type in a class - but I can't seem to get the syntax right. VB6 won't let me declare a public variable of type FormRecordsets and the following code, although it doesn't fall over doesn't work either. I would be grateful of any pointers, thanks! Public Type...

I have built a form with textboxes & when I press the finish button it inserts the text into a document. However I want the text to overwrite rather than insert.I've used the following code: Selection.GoTo wdgotobookmark, Name:="B1" Overwrite = true Selection.TypeText Textbox1.Text...

I have built a form with textboxes & when I press the finish button it inserts the text into a document. However I want the text to overwrite rather than insert.I've used the following code: Selection.GoTo wdgotobookmark, Name:="B1" Overwrite = true Selection.TypeText Textbox1.Text...

Hi - I have just been handed a very lengthy form - which in the past was printed and filled in by hand but now needs to be made into a template. The problem is that the user wants to have tabbable text boxes on the document itself. I can add textboxes but there doesn't seem to be anyway to set...

Hi - I have just been handed a very lengthy form - which in the past was printed and filled in by hand but now needs to be made into a template. The problem is that the user wants to have tabbable text boxes on the document itself. I can add textboxes but there doesn't seem to be anyway to set...

Hi - I have developed a simple comm object which is running on complus service on a win 2000 server. The comm suppllies an adodb connection object - the comm appears to work fine but when I try to assign the connection object to the active connection of an adodb command object I get an error...

Hi - I hacve been trying all day to cycle through all code modules in an access database (using vb6) and then read the individual lines of code out to another file - I come up with loads of problems ..... I can identify the modules but can't open them - any help would be much appreciated. - N