4,901 Posted Topics
 |  |
 | Re: Badges Page It's a slang term that irritates me to no end. I have a friend who runs a business selling marketing advice. I am frequently asked to critique her promotional materials which include text as well as video. I've finally convinced her to replace all occurrances of **automagically** with **automatically**. It …  |
 | Please read the section of [member rules](http://www.daniweb.com/community/rules) which states - Do provide evidence of having done some work yourself if posting questions from school or work assignments |
 | >Home sick in bed with a cold. Bummer. I got a flu shot last October. Didn't keep me from getting the flu and a nasty case of bronchitis. Hope you are feeling better soon. |
| | I suggest you have a look at [Spinrite](http://www.grc.com/spinrite.htm)  |
| | A lot of questions in the VB.NET forum are database related. Most of the code that gets posted result in one or more comments like "use parameterized queries to avoid SQL injection attacks". I won't describe the nature of a SQL injection because it is easily looked up via google. … |
 | Just out of morbid curiousity, what 170 pieces of information could you possibly have that could not be broken down into sub-tables? I strongly recommend you reconsider your database design. Your queries are going to be horrendously difficult to code and maintain. It takes a lot less effort to change … |
| | Re: Pause VB 2012 You can pause your application (the example here is for half a second) by System.Threading.Thread.Sleep(500) but what would be the point? All that you do is make your app unresponsive for the sleep time. VB programs are event driven. If you want some event to occur at set intervals then … |
 | What is your definition of "closely related"? Is it by word count, average word length, sentence length, word frequency? As you can see, the term is very vague. You want to > take one paragraph from one cell and a paragraph from another cell I don't see that this requires … |
| | You can find [sample code here](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks) |
 | Prompt the user for the name of the database on first use and save the result in a settings variable for subsequent use. I'd also recommend changing your connection string so that is does not depend ona particular file name. For SqlDb you can use "Server=.\SQLEXPRESS;Database=PUBS;Trusted_Connection=yes;" for OleDb you can … |
 | vbScript had the functions, Execute and ExcecuteGlobal which allowed runtime execution of VB expressions (strings) with various levels of scoping. As I recall, this feature is not available in VB.net 2010 but might be have been restored in VB.net 2012. If you really need to execute dynamic code then you … |
| | A question came up in the geeks lounge about answering posts with a simple "just google it". There were concerns about directing traffic **away** from DaniWeb. I made a suggestion there that I thought I'd repeat here. When someone posts a question that has been answered before, instead of posting …  |
| | When you try to connect, the connection does not happen instantaneously. The connection timeout has to elapse before the attempt fails. The way to avoid the freezing is to put the code in a separate thread. However, with that approach you have to use a delegate to update your main … |
 | It would also help if you tell us on what line the error occurs. |
| | The following three statements get the values correctly Dim PurchasePrice As Double = ToDouble(txtPurchasePrice.Text) Dim InterestRate As Double = ToDouble(txtInterestRate.Text) / 100 Dim DownPayment As Double = ToDouble(txtDownPayment.Text) However, if you are calculating the minimum down payment as a portion of the purchase price then there is no reason for … |
| | Click the volume icon on your taskbar, then click on "Mixer". From there, scroll through the various volume controls and check that they are not muted or set to minimum. It is possible that your "System Sounds" volume has been muted. That could explain why your logon sound is gone … |
| | At line 34 you have Me.Controls.Add(txbPartNo) but you don't have an End Sub before the next statement. On my system (VB 2010), the statement txbPartNo.TextAlign = ContentAlignment.MiddleLeft is not valid. When I remove it and add the End Sub the code works fine. And just out of curiousity, why do … |
| | Re: help me Please read the [rules](http://www.daniweb.com/community/rules). Especially the ones that state - Do use clear and relevant titles for new articles - Do provide evidence of having done some work yourself if posting questions from school or work assignments |
| | This thread is more than a year old. Please read [the rules](http://www.daniweb.com/community/rules) which talk about resurrecting or hijacking old threads. If you want an answer then please start a new thread. |
 | You need to have single quotes around text fields. For example INSERT INTO myTable (lname,fname) VALUES(Flintstone,Fred) is not valid but INSERT INTO myTable (lname,fname) VALUES('Flintstone','Fred') is. Also, you should be using parameterized queries. It's not only more secure but it makes the code easier to read. See [here](http://www.daniweb.com/software-development/vbnet/code/445801/avoiding-sql-injection-attacks) for sample … |
 | Two of the [Rules](http://www.daniweb.com/community/rules) for posting here on DaniWeb are - Do provide evidence of having done some work yourself if posting questions from school or work assignments - Do not hijack old forum threads by posting a new question as a reply to an old one So, show us … |
| | Try replacing **Date** with **[Date]** in your queries. **Date** is a reserved word. It is a function that returns the current date. I am assuming that you are using it as a field name rather than calling the Date function. |
 | Lately when I post a response that says "google it" I include an actual link that includes the google search phrase plus "site:www.daniweb.com". For example [google SQL injection](http://www.google.ca/#hl=en&sclient=psy-ab&q=sql+injection+site:www.daniweb.com&oq=sql+injection+site:www.daniweb.com&gs_l=hp.3...4413.15091.0.16259.40.31.3.6.6.3.1571.9699.0j12j13j0j3j0j2j0j1.31.0.les%3B..0.0...1c.1.4.psy-ab.Xr1sMTFXws0&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&bvm=bv.42661473,d.b2U&fp=40da3377a7b91932&biw=1298&bih=745). If the user clicks on that link he/she is shown a list of threads on DaniWeb that address the particular question. The …  |
 | |
 | Please start a new thread for your question. Please ensure you post in the correct forum. Yours is a VB6 question. This is VB.net. |
| | As has been said before - a programmer's job is not to write code. A programmer's job is to solve problems. |
| | Nobody here is going to do it for you. If you have specific questions we can try to answer them.  |
| | My most interesting job was my second job after graduating. I worked in the Neuro-Science department of the University of Manitoba Medical College. I worked for two doctors doing research. The first was doing vestibular studies (balance, eye-hand coordination) on a grant for NASA and the other was doing spinal … |
| | Which index is it complaining about? You have two - currentTimer - 1 - List.Items(currentTimer - 1).SubItems.Count Try replacing the code with Debug.WriteLine("index 1 = " & (CurrentTimes - 1).ToString) Debug.WriteLine("index 2 = " & (List.Items(currentTimer - 1).SubItems.Count).ToString) Debug.WriteLine("# items = " & List.Items.Count) List.Items(currentTimer - 1).SubItems(List.Items(currentTimer - 1).SubItems.Count).Text = …  |
 | |
| | And if you add ORDER BY CustomerCount DESC to the end of the query then you will get the records ordered from highest to lowest customer count |
| | Have you tried [google Daniweb](http://www.google.ca/#hl=en&tbo=d&sclient=psy-ab&q=vb+excel+site:www.daniweb.com%2Fsoftware-development%2Fvbnet&oq=vb+excel+site:www.daniweb.com%2Fsoftware-development%2Fvbnet&gs_l=hp.3...33851.38588.3.39908.8.8.0.0.0.1.236.1745.2-8.8.0.les%3B..0.0...1c.1.3.psy-ab.F98pty3_PcI&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&bvm=bv.42553238,d.b2U&fp=42cb4bbfcb1d9416&biw=1206&bih=728)? Using Excel from VB.net has been discussed many times. |
| | You might want to use a backslash instead of a forward slash as a separator. |
 | Hello Mistah Taylor. I'm not sure I understand. Do you want the string "Sample Text" to appear in the combo box and when the user selects it, text from a file gets copied to the textbox? Or do you want text from the file to be loaded into the combo … |
| | The format of an If statement is If <expression> Then where <expression is expected to be something that eventually boils down to a boolean. For example If str = "abc" Then the expression str = "abc" when evaluated results in either the value **True** or **False**. Your statement If Me.TbmembersTableAdapter.ScalarQueryCardID(cardid) … |
| | Try SERVER\SQLEXPRESS (back slash). When I connect to the SQLEXPRESS on my computer I use JIM-PC\SQLEXPRESS If you are connecting to a SQLEXPRESS on another machine then you will have to check that you have been granted access rights for you as currently logged on. If not then access rights …  |
| | Re: Valentine's Day We cook a special Valentine's Day meal together. Lobster, shrimp, cheese fondue, stir fry, etc. |
| | I get periodic pop-ups from a company called Scorecard Research asking me to complete a survey. This only happens when I am on Daniweb. is this legit? If so then how can I make it go away? The questions were innocuous so I answered them but the pop-up keeps coming … |
| | How are you copying the control? Copying complex objects require you to do a deep copy. There is a detailed explanation [here](http://programmingcorner.blogspot.ca/2007/01/deep-cloning-in-net.html). |
 | Re: Set timer It's probably easier to use an application setting instead of the registry. If you are using VB 2010, go to Project -> Properties, then go to the Settings page. You'll have to pick an appropriate variable type. You can access it by My.Settings.varname You can keep track of elapsed time … |
| | In order to relate two tables they have to have a common column. You'll have to include the EmployerID as a column in the Employee table. You described the tables as follows: Employer Table: I have two field EmployerID (pk Key assigned to it) Employee Table: EmployerID(pk Key assigned to … |
| | You can also download (free) the SQL Management Studio which greatly simplifies the creation and management of databases. However, installing it is tricky unless you [follow the step by step instructions](http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx)  |
| | It's broken again. I've completely cleared the cache and still there are no text entry/browse buttons. |
| | Rake some leaves, shovel some snow, wash somebody's car or walk their dog. You can make 9$ doing just about any trivial chore. It doesn't take a lot of imagination. |
 | This error can happen when you have a parameter in your connection string that is not valid for the given provider. Try changing Persist Security Infor=False to Persist Security Info=False and see what happens. What type of database are you trying to open?  |
| | A minor suggestion. Assuming you are using radio buttons then you can simplify your code because if (for example) the male button is not selected then the famale buttom **must** be selected. So instead of If (maleRbtn.Checked = True) Then gender = 0 ElseIf (femaleRbtn.Checked = True) Then gender = … |
| | Re: 2 notices... I think you can clear out saved text by clicking the dropdown box and moving the cursor over an option. When it is highlighted, press the DELETE key. |
| | Show us what you have so far. If you don't have anything then it's time to do some research. Use google to find some tutorials (there are several good ones) or get a book.  |
| | This thread was marked as solved five years ago. |
The End.