Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Anesthaesia

    Populate Excel spreadsheet

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

    Populate Excel spreadsheet

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

    Populating Treeview problems

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

    Creating an Outlook PST file

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

    Listview adding in reverse

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

    Listview adding in reverse

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

    Integer to Time format

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

    SQL Query - improve speed using LIKE

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

    SQL Query - improve speed using LIKE

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

    Filter Listbox

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

    Filter Listbox

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

    Filter Listbox

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

    Keystroke log reader

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

    Install software usinf INF file

    Thanks Joe, Worked a treat!
  15. Anesthaesia

    Install software usinf INF file

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

    Install software usinf INF file

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

    Data output performance

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

    Data output performance

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

    Data output performance

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

    MSChart Labels

    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

Part and Inventory Search

Back
Top