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

lol - yeah Belt & braces, much the same thing :) - thenks for your help so really as far as destroying objects goes - the rules I used in vb6 still appy. N

Thanks guys for your help - I like the belt & braces approach so will be setting my objects to nothing. :)

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

Ah - I've got it: dim frmNew as frmBuilder

I have tried that, here is my code, why cant I see tvwMain? Many thanks. Private Sub mnuFileNew_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles mnuFileNew.Click Dim frmNew As Form Dim strProjectName As String frmNew = New frmBuilder() strProjectName =...

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

Nice one if you could send the details to nigz@lineone.net that would be great :)

You need to use something like Visual Basic to produce forms although it's a bit more complex that Oracles add-on. There is a report designer with VB but most people go with Crystal Reports. HTH - Nigz

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

You can scroll through the grid by advancing through the underlying recordset. How do you want to scroll? With buttons or what?

Dim ID As Integer ID = 1 rs.MoveFirst Do while Not rs.EOF 'If you want column 6 populated DataGrid.Columns(6).Text = CStr(ID) ID = ID + 1 rs.MoveNext Loop

If your tree view is an MDIChild then you could 'tile vertically with another form within your MDI container. Usually, however, tree views are used in conjunction with the listview on the same form.

Thanks Kris - I managed to create a db at last - will look at the tools you gave me links for. Thinking I might have a go at writing my own front end to server desktop.

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

does this help: http://www.rpgalive.com/common_problems.html There is a solution to file not found problem there.....

What is the dll - it's not anything to do with Crystal Reports is it?

OK I stand corrected ;) the * 5 thing was not an entirely serious suggestion - N

If it's MS SQL look up 'Alter Table'

<snip> nigz: that will only return the number of weeks....not weekdays. </snip> from MSDN: Setting Description yyyy Year q Quarter m Month y Day of year d Day w Weekday ww Week h Hour n Minute s Second But if that's an error then how about: NoOfWeekDays =...