Search Results - VBForums

Search:

Type: Posts; User: IanRyder

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    13
    Views
    215

    Re: help on count rows.

    Hi,

    Now I understand exactly what you are trying to achieve this is how I would go about it:-

    Create a query which Sums all the Admissions which can then be used to calculate the percentages....
  2. Replies
    13
    Views
    215

    Re: help on count rows.

    Hi,

    Not sure which Percentage you are referring to but if you just want the Sum of Admissions then you can just say:-


    SELECT TOP (100) PERCENT...
  3. VS 2012 Re: Need help converting For If Loops to Do While Loops.

    Hi,

    The first thing to do is to turn Option Strict On and never turn it off. It will help you to identify and correct Type Conversion errors in your code as you make them.

    The reason why the Do...
  4. Replies
    13
    Views
    215

    Re: help on count rows.

    Hi,

    What you need to do is to create a Query which identifies the Top 5 Results and then Excludes these results from a Second Query. As an example have a play with this:-


    SELECT TOP (100)...
  5. Replies
    5
    Views
    148

    VS 2013 Re: Error Creating Window Handle

    Hi all and those possibly reading in the future,

    It has been 24 hours now since I implemented my own fixes in my application and at this point there has NOT been a single instance of the dreaded...
  6. Replies
    5
    Views
    148

    VS 2013 Re: Error Creating Window Handle

    Hi Kebo,

    Thanks for the insight but I think that I have also got that one covered now by ensuring that all the User Controls are now Disposed before they are remove from the FlowLayoutPanel.
    ...
  7. Replies
    5
    Views
    148

    VS 2013 Re: Error Creating Window Handle

    Hi dday9,

    Many thanks and Yeah, I have definitely got that bit sorted since I have seen many examples of memory leaks over the years and I am hoping that I have got this one right now but I am...
  8. Replies
    5
    Views
    148

    VS 2013 [RESOLVED] Error Creating Window Handle

    Hi Guys n Girls,

    I am after a bit of advice or experience if possible. I am still relatively new to .NET with just about over 2 years of professional experience now in the .NET Framework and over...
  9. Replies
    14
    Views
    276

    Re: Timer spanning multilpe forms

    Hi,

    Are you actually talking about a Timer component which actually allows you to run some separate code on its Tick Event on each Form or are you actually talking about a Stopwatch that will...
  10. Replies
    2
    Views
    108

    Re: [RESOLVED] Number formatting issue

    Hi,

    There is nothing wrong with the .NET principles that you are using there and being advised to use FormatNumber as opposed to String.Format sounds like your Teacher has come from a VB6...
  11. Replies
    10
    Views
    266

    Re: Rock paper scissors code problem

    Hi,

    The first thing to do is to switch Option Strict ON now and never turn it off. With Option Strict set to on the compiler will help you to identify and correct Type Conversion errors as you...
  12. Replies
    6
    Views
    158

    VS 2013 Re: how use character string and converting

    Hi,

    For you second question it sounds like you need some sort of conversion routine whereby “a” = 0 and “z” = 25 and all the letters in between increment by 1 each time and then the numbers are...
  13. Re: newbie problem with while ..end statement..

    Hi,

    Things actually work fine but you have just got a few things in the wrong places or you have doubled up where you do not need to. Try this:-

    Private Sub readValuesandNumbers()
    Dim...
  14. Re: newbie problem with while ..end statement..

    HI,

    I cant quite read that so post the code, using Code Tags, and one of us should be able to guide you better.

    Cheers,

    Ian
  15. Re: newbie problem with while ..end statement..

    Hi,

    Just use "If Cint(numberValue) = 0" and your done.

    Glad I could help.

    Cheers,

    Ian
  16. Re: newbie problem with while ..end statement..

    Hi,

    Here is a quick example to demonstrate a While loop working in the manner that you are expecting. Have a read through the comments to understand exactly what each aspect of the code is doing...
  17. VS 2010 Re: Adding integer values up in a listbox and then display them to another listbox?

    Hi,

    I cannot actually see where you have set the variable “dt” but assuming that you have set this correctly and set this as the DataSource of the ListBox then I would suggest that the column name...
  18. VS 2010 Re: Adding integer values up in a listbox and then display them to another listbox?

    Hi,

    As long as what is being displaying in your ListBox is just a List of Numbers entered through the use of the Add or AddRange methods then you can use this to sum the list:-
    ...
  19. Re: [RESOLVED] Read text file and sum a column of data

    Hi,

    Welcome to the Forum but please do not post to an old thread to ask your own question even though you may have used that thread to try and answer your question. At least you looked first...
  20. Re: StreamWriter - comma seperated - how to??

    Hi,

    Your biggest issue is that you have one too many elements defined in your array. You have actually defined 6 elements instead of 5 so you get an extra comma in the output. You then need to...
  21. Re: Real time updating of label in for each loop

    Hi,

    ShaggyHiker has explained the reason why this happens which can be demonstrated using the following simple example:-

    Private Sub Button4_Click(sender As Object, e As EventArgs) Handles...
  22. Re: [RESOLVED] text box - use value of number for equation

    Hi,

    That’s still not great and, as already explained, the reason why “TextBox1.Text + TextBox2.Text” did not work is because they were sting values and therefore the strings were concatenated....
  23. Replies
    32
    Views
    533

    Re: VS 2010 - Integer to Roman Numeral

    Hi,

    Then do not copy and paste. Learn the principle and write your own? That’s the same as any of us showing you an example of which there are loads out there so what the difference?

    Cheers,
    ...
  24. Replies
    32
    Views
    533

    Re: VS 2010 - Integer to Roman Numeral

    Hi,

    Use the internet, I disregarded posting to this earlier since there were so many examples on the there which explains how to do this.

    Cheers,

    Ian
  25. Replies
    14
    Views
    351

    VS 2010 Re: importing text files line by line

    Hi,

    I am aware of Teachers being asked to take classes that they are not qualified to teach but I am not aware of Teachers that have to then specifically Learn a subject that they are not...
  26. Replies
    14
    Views
    351

    VS 2010 Re: importing text files line by line

    Hi,

    Just to be clear, you are Joking, Right?

    If not, and you may be a great Teacher in your chosen field, but how on earth are you supposed to teach this subject if you are asking these...
  27. VS 2008 Re: adding items from a string to a listbox ?

    Hi,

    The “c” character converts the preceding character to type Char which is then compatible with the First overload of the Split method.

    Hope that helps.

    Cheers,

    Ian
  28. Re: Trying to exchange values between a datetime picker and acess BD

    Hi,

    Gimfort is correct in his comments but there is a bit more going on here that you may not be aware of.

    If “Fill_Date” is of type DateTime in your Access Database then the correct syntax for...
  29. VS 2010 Re: Problem removing spaces/blank lines from a text file.

    Hi,

    If I were doing this I would first of all read the file into the project using File.ReadAllText and then call Split on the file to split the file at the CRLF character and at the same time...
  30. VS 2010 Re: Please explain why this does what it does

    Hi George,

    I am not even going to try and explain that one in a single post to the forum. It’s better to know at this point that References definitely have their place in any language and is best...
  31. Thread: Game

    by IanRyder
    Replies
    2
    Views
    146

    VS 2013 Re: Game

    Hi,

    You imply a lot of things in your statement and no one is just going to write this for you. So, what have you done so far? The things to consider are:-

    1) Have you created an array for your...
  32. VS 2010 Re: Please explain why this does what it does

    Hi,

    When you do variableArrayX = variableArrayY then what happens is that a Rreference is created in variableArrayX which then relates to the values in variableArrayY. Therefore when you change an...
  33. Replies
    11
    Views
    319

    VS 2010 Re: Clear all TextBoxes in series

    Hi,

    Again use the Tag property, but in this case use a numeric sequence of let’s say 1 to 50 so that each textbox is numbered in sequence in the Tag Property. You could then run the same code but...
  34. Thread: 2 questions

    by IanRyder
    Replies
    4
    Views
    169

    Re: 2 questions

    Hi,

    The difference between “Do While” and “While” is that a Do Loop will ALWAYS execute at Least once whereas a While Loop may never execute at all depending on the conditions that you are testing...
  35. Replies
    11
    Views
    319

    VS 2010 Re: Clear all TextBoxes in series

    Hi,

    One of the easiest ways to do this it to Set the Tag Property to something for each of the TextBox’s that need to be cleared. Let’s say then that we set the Tag Property to “Clearable” we...
  36. VS 2010 Re: Draw image every so many pixels on form... Please help?

    Hi,

    My interpretation of what you are asking for is as passel has suggested being tiled images on a background? If so, then have a play with this example. It may not be exactly what you need but...
  37. Re: Finding the MODE of a list of integers

    Hi,

    I did not really understand Post No.9 and I do not work in VB6 anymore but here is one way to do this in Access SQL:-


    SELECT TOP 1...
  38. VS 2008 Re: Noob Question About Structures

    Hi,

    You can use LINQ to Objects with a Lambda expression here to do what you need. To also make things easier to read you should also create your Structure Name in the Singular and your Array in...
  39. Re: MySQL query AND Statement Question..

    Hi,



    No your not since that does not actually make sense?

    This is what your SQL query should look like and I will leave it to you to work out how to add the Parameter values to the SQL Query...
  40. Re: MySQL query AND Statement Question..

    Hi,

    There are a few things wrong there but the best thing you can do right now is to put your SQL String Concatenation into a message box and see what you are actually sending to the Database. You...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.