Search results for query: *

If TreeView.Nodes.Count > 0 Then TreeView.Nodes(1).Selected = True End If

johnwm - of course I saw this, I just didn't think it was a very professional solution. Here's the app, oh and by the way you'll have to download this thing from Microsoft. CCLINT - patronising? I didn't say there was a problem referencing/using it, I said there was a problem installing it onto...

If you are planning on rolling out your App on clients which don't have MS Office installed don't use the above library. (fm20.dll) I used it because it gives you multi column list & combo boxes. It was only when I came to install it on non office clients that I got the charming 'System Error'...

I haven't done this but... I think there is a 'SIZE' ftp command which returns the size of a file, so if you call that first and set the Max property of the progress bar to the filesize. Then when you have issued your GET command and are in the loop waiting for completion, use the file system...

I use 'still executing', when its ready to continue and no errors then complete. 'after execute Do While Not inetReady DoEvents 'should probably put something in to exit loop on 'ftp error raised Loop Private Function inetReady() As Boolean inetReady = Not...

If Command1 is recordset returning then it will be prefixed with 'rs', plus you need to open it first, so.. dim rs as New Recordset DataEnvironment1.Command1 With DataEnvironment1.rsCommand1 If Not (.EOF AND .BOF) Then Set rs = .Clone End If .Close End With

How about using a stored procedure in SQL that returns a boolean indicating records or not. You would probably still have to open a recordset but doing it in SQL would be faster than VB. Just a thought...

Spot on Mark - thanks very much.

Hi all I need to display a list of stored procedures in a sql server db. I am using Data Environment and when you insert an SP you get a list of all SPs for that connection - that is the list I am after in code. Any ideas? Thanks. VB6 - XP Pro.

Ok - this is something I have just done that checks if there is an internet connection '***************************************** 'API Declaration Declare Function InternetGetConnectedState Lib "wininet.dll " (ByVal lpconnecttype As Long, ByVal dwReserved As Long) As Long 'function...

Would a routine that ran on a timer and checked the connection state be acceptable or do you only want it triggered on connect/disconnect?

Screen.MousePointer = vbHourGlass always works for me.

Hi I am developing an app that needs to run on remote client laptops. The app downloads xml recordsets and needs to load them into tables in a local db (access). I have no problem opening the recordsets in VB but am struggling to get the contents into the access database (the structures are...

Thanks very much Robert - exactly what I needed.

Hi I am using a TreeView with checkboxes. When the user checks a checkbox at any level - I want all the child nodes of the selected node to be checked in code. Anyone done this? Many thanks.

Hi I have created a VB ActiveX DLL and declared it 'WithEvents' in Access. In VB (design time) when you select the object you have just declared you get the associated events in the procedure drop down list. When I try this in Access I get a 'User-defined type not defined'. The DLL is...

I think for the data combo you need to set the rowsource and rowmember property as well as the datasource property. If this doesn't work, let me know and I'll double check.

Try using a data combo (components - Microsoft DataList Controls 6.0) These have rowsource, datasource etc

Does it work if you change vbResIcon to vbResBitmap? The image may be loaded into the bitmap part of the res file.

Private Declare Function Beep Lib "kernel32" (ByVal dwFreq As Long, ByVal dwDuration As Long) As Long Private Sub MyBeep(Frequency as Long, Length as Long) Beep Frequency, Length End Sub 'This plays a beep using the system speaker 'ie MyBeep 1000, 1000 - would play a 1...