Search results for query: *

After doing a bit of searching it seems this is known issue and the best way to do it is dropping an array straight into a worksheet. My VBA knowledge is limited so if anyone could give me an example of doing this I am sure it is what I am after. Thanks to those that replied, but neither of...

Hi All, I need to populate an Excel spreadsheet with a large amount of data. Everything is working fine, but it takes ages to write the entries. As the data needs to be a in a specific order its going into an array and then to Excel using "oSheet.Cells(nRow, nCol).Value = strData" Is there...

Hi, I need to populate a Treeview from a database but am having problems getting my head around it. Any tips would be great... I have no problem getting the data - its only the populating part I am having trouble with. The data is stored as: Office Mgmt Office\Location Office\Dept\Accounts...

Hi, I need to be able to create a PST file in Outlook 2003 and change the properties for it when created. I have the code to create the PST and open it in the current Outlook profile, but I cannot find how to change the file properties in VB (display name in Outlook) By default the PST...

Nevermind - figured it out by specifying the index to use - I thought it would simply replace the existing entry.

Hi, I need to add items to a listview but have the most recent entry at the top, and each existing entry will move down one. Sorting is not an option. Is there any way to do this, or any other control that would support this?

I need to convert an integer to time format ie. 127.8347 would be 2:07.8347 I have found examples that convert to hh:mm:ss but do not allow for milliseconds. Any help would be great.

Thanks Mike, That's something I had a look at but wasn't sure about (not too familiar with SQL indexing/performance) Going to give it a try now... Cheers, D

Hi, I have read through some posts about table scans in SQL, which are performed when using a LIKE query. Is there any other way to do this and improve performance? I am currently using ...AND rsRec LIKE '%" & txtSearch.text & "%'... in the query. I need to be able to do a wildcard search...

I actually kind of answered my own question there... I have populated 2 arrays, one which is created by filtering the 1st, which contains all entries. This seems to work OK (listbox population slows it down a bit with a lot of records). How do I filter the beginning of the word though? At the...

The only thing I can think of is adding the contents to an array, but at that point I'm a bit stuck. Also, the slow refresh rates of listboxes was a concern I had, so wasn't sure if there was a right and wrong way of doing it. I assume the code will go in the textbox change event which should...

Hi, I want to filter items in a listbox as I type chrs in a textbox. Any idea on the easiest way to do this? Example List: Apple Animal Banana Typing "a" in the text box will remove "banana" from the list, typing "ap" will leave a list with only "apple". This will happen as the chrs are...

Hi All, I am using some code I found which records keystrokes to a log file. What I would like to do now is format the log file to make it readable. An output example would be: "I needd[BKSPACE] too[LEFT][DEL] format the[BKSPACE]is" Coded keystrokes are...

Thanks Joe, Worked a treat!

Hi Joe, There is no executable in the install package - you can also install an INF by right-clicking in Windows Explorer, and selecting the Install option. This is the operation required to install the software I have.

Hi All, How can I install/execute an INF file from VB? Since it's not officially an executable, the shell command does not work. Cheers, D

Thanks for the replies and informative links guys... I don't think any further changes will improve the performance drastically - chiph probably answered my question best, as this is obviously due to the design of databases. I had never compared writing to a text file vs a database before, and...

Hi Jerry, This is considerably faster - creating the recordset takes the same time as outputting to the TXT file (3secs) but writing to the DB takes a bit longer - total time 30sec. This should be fine for now - obviously this performance would change based on HD/CPU speed etc, but is much...

Hi All, I am outputting about 30,000 lines of text (all lines approx 50-70 chrs long) to an Access database. This database has 1 table, 1 field and is stored locally (on same PC) To save these records from VB takes approx 80secs. However, if I send the exact same text to a TXT file, it takes 3...

Hi All, Is it possible to add labels to each column on an MS Chart control, instead of using a legend (single series, 2d Bar)? If yes, is it also possible to rotate these? (either 90 or 45 degrees) Cheers, D