Search:

I have a script that queries Windows using the WMI tool. As part of the script it queries the Win32 database. Will the script execute the query and wait for the reply before moving on to the next...

Can anyone tell me whether VBScript is asynchronous or not? The reason for asking is because I have a script that gathers the number of alerts logged in the Windows event logs and adds it to a db...

That's perfect, thank you for your help!

Salika, did you ever get to the bottom of this because I am experiencing the same problem?!

Thanks

I have worked with applications in the past that allow the user to move/modify controls at runtime and allow those modifications to be saved. For example, the user may want to add a text box to a...

Does anyone know of a way to count the number of selected nodes in a treeview without looping through the Nodes collection?

Twodogs,

Thanks for that, I too will probably have to implement something like that.

Does anyone know of a way to edit values in subitems? What I am trying to achieve is to have the listview populate with values from a table but to allow the user to edit those values and then read...

Hello!

I changed the cursor type to Forward Only with minor performance gains. How do the likes of Crystal do it?!?:confused:

Hi jp140768,

The cursor location is already on the server.

I've set the cursor type to Static and the lock type to Read Only but when accessing large numbers of rows it still takes significantly longer than other 3rd party applications. The select statements...

Can anyone give me some advice on ways of being able to speed up my recordset creation process? I am using ADO and Microsoft OLE DB Provider For ODBC Drivers to access data from various systems...

Cimperiali,

I used the code you posted and Excel does not display anymore so thank you very much!!:)

Hi Cimperiali,

Yes, what I want is for Excel not to show, something like Application.Visible = False would do but for the connection string.

Thanks

I am using the following code to open a connection to an Excel workbook but whenever I run the code it opens the workbook that I am querying?!

Set oConn = New ADODB.Connection
...

Malleyo,

I think you may have found the answer - I'm using a Win98 machine so I'll be trying the app on a 2000 machine to see if the problem persists.

Thanks for the link!!

When I comment out the following lines:

If blnMerge Then
wkSheet.Range(strCell & ":" & strSecCell).Merge
wkSheet.Range(strCell & ":" & strSecCell).HorizontalAlignment =...

I am exporting data from a recordset to Excel. The following code is a sub within the class that I'm using for the export:

Private Sub AddText(strSheet As String, strCell As String, ByVal strText...

Two questions:

1. I have a field in an Access database that is a Date/Time field and contains times. When I add this field to my Crystal Report it is displayed as a date instead of a time. How do...

I have created a report using the Data Report Designer that displays start and end times in hours and minutes. There is a function in the group footer that totals the number of minutes and one that...

How do you set environment variables?
From the command line "set Test = Test" works perfectly but I cannot achieve the same thing in VB!!

Hello! This isn't really a VB question but I thought that you guys might be able to help! I'd like to be able to insert,delete etc from an Access table but would like to embed the SQL into a batch...