4,901 Posted Topics
 | Or you could have a class level variable like Private Initializing As Boolean = True and set it to False at the end of the initialization. Then in your SelectedIndexChanged events you could do If Initializing Then Exit Sub That would prevent those events from processing until the initialization is …  |
| | Or you can test the operands before you do the divide to see if the denominator is zero.  |
 | Cop out. The first girl I was smitten with was Barbara Werch in third grade.  |
| | You need to include the following Imports Microsoft.Office.Interop Then you create a few objects 'create objects to interface to Excel Dim xls As New Excel.Application Dim book As Excel.Workbook Dim sheet As Excel.Worksheet You can open the Excel file by (use your own filename) xls.Workbooks.Open("D:\temp\myfile.xls") 'get references to first workbook … |
| | Is it being run under the same account on the file server as it is on the desktop? Is it using a domain account or a local (machine) account? Perhaps it is just an access rights issue. I'm assuming that you are using an hta staher than a vbs script … |
| | Process.Start can take two arguments. The first is the executable, the second is the arguments. System.Diagnostics.Process.Start(txtProgram.Text, txtArguments.Text) For future reference, it is not appropriate to post in other threads in order to direct attention to your problem in another. It is especially inappropriate to hijack a dead thread to do …  |
 | [Wrox](http://www.wrox.com/WileyCDA/Section/Home.id-105001.html) has produced some excellent books. I suggest [Beginning SQL](http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764577328.html) to start. |
| | > Everyone knows I make it a rule to not trust any statement beginning with "Everyone knows..."  |
 | I'm going to post this from the viewpoint of an English only speaking person (apologies to mike_2000_17 and others). The first language you should learn is English. The most important skill you will require is the ability to communicate clearly. It doesn't matter how gifted you are as a programmer …  |
| | If you are using a DataReader (dr) to read the data then why are you retrieving it from ds? |
 | |
| | This is not the forum for tech questions. It should be posted under [Software Development](http://www.daniweb.com/software-development/2) and tagged with **Excel**. I'm moving it there now. |
 | If you do a manual delete then you might want to use the registry cleaner feature of [ccleaner](http://www.piriform.com/) to do the registry cleanup for you. |
| | There are several free programs that install print-to-pdf pseudo printers. I've been very happy with [PDFCreator](http://sourceforge.net/projects/pdfcreator/) |
 | I'm not sure I see the problem. You go to control panel, then Windows Update, then select Change Settings. Then you pick **Install Updates Automatically**. Just like Windows 7 |
| | Don't do strMonths.ToString(intCount) ToString is evaluated first on strMonths resulting in "System.String[]". Because strMonths is already of type String (array), there is no need to apply ToString. Just use strMonths.(intCount) To clear an array you just loop over all the elements and set each one to zero such as For … |
| | You have a few problems to clear up before we can answer your question. 1. You need to use the **Code** tool to insert code or you lose all formatting (I fixed it up for you this time) 1. You did not attach any screenshots 1. Your question is confusing … |
| | The usual way is to use wildcards. You didn't say what database you are using so I'll just give you the one for MS SQL. SELECT * FROM mytable WHERE stockNumber LIKE 'CC%' This selects all records where stockNumber starts with CC. Other databases may use other characters for wildcards. … |
 | Can I wash your car and paint your house while I'm at it? |
 | Not without knowing more details. Is your table indexed to provide quick access based on how you are selecting the data? |
 | >honestly, I wonder whether that situation would also be the same if 'Iron Maggie' would still be dealing the cards You mean like in the US where Republicans would like to see all sex education removed from the schools and birth control made unavailable to teens - a policy which … |
| | > I find it more difficult to retain anything as I'm getting older. Tell me about it. I'm pretty sure that you and I are roughly the same age (59). I've made several attempts to learn Python. Even wrote a 3D Breakout game but I find that I don't do …  |
 | What do you mean by "extensible application"? |
| | If anyone is interested, there have been over 3530 gun deaths in the USA since the Newtown shootings. Details on those deaths can be found [here](http://www.slate.com/articles/news_and_politics/crime/2012/12/gun_death_tally_every_american_gun_death_since_newtown_sandy_hook_shooting.html). Boston got shut down while police hunted for the remaining man responsible for the injuries and deaths taking place in one incident. Where is … |
 | |
 | If you google it you get [this](http://support.microsoft.com/kb/223152) |
 | You have to call Randomize() at the top or you will get the same sequence of numbers every time. Because you are working with such a small set of numbers (by the way, using (0,4) gets you a number from 0 to 3) you will very likely get duplicates. What … |
 | Re: MS SQL basics In a nutshell, the most basic way is to use ADO. With ADO you communicate with the database through the connection object and the recordset object You supply a connection string to the connection object then use the Open method to open the connection. You can use the connection object … |
 | Unrelated to the question but worth noting - txtUserSearch.Text is already a String so you don't need to use the ToString method. Just use txtUserSearch.Text  |
 | >I want to read the whole thing, search for the keyword "SITUATIONAL" and insert it all into the database and where "SITUATIONAL" will be the key entry for printing it out on the web. Let's take an example. Using your linked text file, what, specifically do you want to insert … |
 | If you do Dim fields() As String = TextBox1.Text.Split("-") assuming that you, in fact, have a date entered in the form YYYY-MM-DD then fields(0) will contain the YYYY part fields(1) will contain the MM part fields(2) will contain the DD part This will work even if the month and day … |
 | I've never understood why the explicit forms of certain words offend people but the more politically correct (a phrase that offends me) forms such as f-bomb, c-word, n-word, etc. do not when by saying f-bomb you are basically still saying fuck. As George Carlin so aptly put it, "shoot is … |
| | Sounds like a homework assignment. What have you done so far?  |
 | |
 | @happygeek - You missed an apostrophe? The horror. Obviously that totally invalidates all of the other content. Good thing there weren't further errors or I might have had to equate you to Hitler (because, as you know, some of Hitler's writings contained typos). Sorry. I accidentally turned on Fox News … |
 | You can use shift-Tab to tab backwards through the controls.  |
| | It's right there in the **Reply to this Discussion** button which ends with **(Alt+S)** |
 | |
| | Taught myself basic on the old mainframe at the University of Saskatoon back in 1971. Programs were stored on paper tape. My first formal language was Waterloo FORTRAN (WATFOR) at the University of Manitoba. Punch cards - yay. |
| | >I try not to bring it up Then don't. I think that going off half cocked and throwing around accusations with no evidence is exactly the wrong thing to do. It's an immature, knee-jerk reaction that will only cause more problems than it solves. |
| | My given names are Richard James but my mother decided I should go by my middle name which is a royal pain in the a$$ because every bleeding form in the world asks for my first name and maybe my middle initial. Thus, whenever the receptionist in the doctor's office …  |
| | Never have, never will. My dad suffered from emphysema after smoking for 40 years.  |
| | It might be the double comma at @dtaGender,,Telephone and since you are using parameters everywhere else why not change WHERE EId='" & Me.MaskedTextBox6.Text & "'" to WHERE EId=@EId  |
| | Normally when you do a join you specify a common (related) field. When you do a join without doing this you end up with a recordset that contains the product of each table. For example, If you have 6000 records in one table and 400 in the other you will … |
| | Re: Key press event This is the vb.net forum. Please post your question in [vb 4-5-6](http://www.daniweb.com/software-development/visual-basic-4-5-6/4) |
| | I've used both Melody Assistant and its bigger brother, Harmony Assistant from [Myriad Online](http://www.myriad-online.com/en/index.htm). I used the Virtual Singer add-on to create four-part vocal tracks for my quartet for learning the various vocal parts.  |
 | If you mean expanding/collapsing long code segments it was answered [here](http://www.daniweb.com/community-center/daniweb-community-feedback/threads/452314/when-codes-get-long) |
| | Without getting into all the other stuff, if you want to know the highest number in a column you can use the MAX function as in SELECT MAX(PrinterID) FROM ... |
 | The most complex program I ever wrote was when Westinghouse was developing our first AGC/SCADA system (in service 1983-1998). Although Westinghouse developed the codebase, it was up to us to create the databases. This was done using a DDL (data definition language) which was used to create the hierarchical database … |
| | The following lists all of the subkeys under HKCU\Software Dim key As Microsoft.Win32.RegistryKey = My.Computer.Registry.CurrentUser.OpenSubKey("Software") For Each subkey In key.GetSubKeyNames Debug.WriteLine(subkey.ToString) Next |
The End.