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...
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.
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...
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...
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
Hi All,
Does anyone have any alternatives for a chart control for VB? MSChart does the job, but is not very pretty on the eyes.
I found a great free control, but unfortunately it only supports 1 series.
Any suggestions would be great.
Cheers,
D
Hi All,
I have a .bat file which I am executing using a Shell command. However, when I execute it using Shell the commands in the batch file are not executed - if I run the bat directly it works fine. Any ideas why this is?
It's a very simple file which changes directories then executes an exe...
Hi all,
I'm looking for a way to make a signal interference type effect. This is ususally seen in films when a camera is dropped (fuzzy image, lots of noise) - it can also be seen in formula 1 onboard footage when a car passes under a bridge or the gearshift/revs affect the signal.
I hope...
Hi All,
I recently had to replace a motherboard on a Windows 2003 server. Included in this change was the network adapter.
The hardware has installed fine, and Windows loads, but needs to reactivate due to hardware changes. The problem is after selecting this option, the system doesn;t do...
Hi All,
I need to be able to get a user's SMTP address from Active Directory using their login username (which I am able to get)
Is there any way to get this info from AD ?
Cheers,
D
Hi,
I'm trying to delete a record using the DELETE FROM command. My code is
cn.execute "DELETE FROM table WHERE id=1"
When executing this command I get a timeout, but running it through Query Analyzer it works fine (takes < 1sec).
All my INSERT INTO commands work fine, but I cannot delete...
Hi Guys,
I'm hoping that someone here has tried their hand at newsgroups/newsreaders and can help me with this.
I am trying to develop a very basic newsreader for personal use (I'm not trying to re-invent the wheel so bear with me).
My code so far works fine and I can download headers etc...
Hi Guys,
I am trying to connect to a database, but I don't know what format it is in. How can one determine the format ?
I am actually trying to connect to a Championship Manager 4 savegame - maybe someone here knows how to do it ? I would like to be able to pull info from the DB (savegame)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.