• Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Words and phrases I wish people would stop using.

    Alternative society? Why not. Alternative music? Sure thing (except for John Coltrane). But "alternative" medicine means medicine that is unsupported by evidence. "Alternative" science means the same - claims unsupported …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Why does Windows XP refuse to die?

    Even car companies are not required to continue making parts for old cars forever. Technology changes and while I **do** have a problem with deliberate obsolescence as a means of …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in trying to use var. to tell sql what to do

    But select * from Test_Table where date like '2015%' does not, at least if stored as a date. Actually it should be select * from Test_Table where [date] like '2015%'
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Why does Windows XP refuse to die?

    >We should be able to run anything we have. Get rid of the stupid idea that people don't need old files and software. You **can**. Just keep your old computer …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in i'm busted

    And?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Round function question need your help

    DOH! You are right. I had a typo which I have corrected.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Round function question need your help

    A quick check in vb.net and vbScript (sorry, do not have vb6 installed) gives the following results Math.Round(1.5) is 2.0 Math.Round(2.5) is 2.0 Math.Round(3.5) is 4.0 <edit> corrected from 3.0 …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in trying to use var. to tell sql what to do

    I'm also using MS SQL 2012 and using LIKE with dates returns nothing. It works with numerics, but not with dates. select @@VERSION Microsoft SQL Server 2012 - 11.0.2100.60 (X64) …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Marked Solved Status for how to create login form

    HI I have vb.net with ms access database application. I want to create log in form Here is my code but when enter the details and hit Login button it …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in vb school managment login

    Try adding ";Connection Timeout=60" to the end of your connection string.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Nature's Temper

    You mean the same pinheads who want to get rid of the EPA so that US industries (like fracking) can pollute the same water that we all have to drink? …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Random Facts

    Paul Winchell is best remembered as the voice of Tigger in numerous Disney Winnie the Pooh cartoons, as well as Dick Dastardly and Gargamel. He was also half of the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in trying to use var. to tell sql what to do

    I just ran that query as a test against an MS SQL database and it returned the desired results. What database engine are you using? My exact query was (using …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in What's the risk of running Windows XP?

    FUD from Microsoft?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in trying to use var. to tell sql what to do

    You can't use LIKE on numeric values. You can use DATEPART to extract the year portion. Your query string should be qry = "SELECT * FROM test_table" & " WHERE …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in What are your Other Hobbies Aside from Coding?

    Does Daniweb count as a hobby?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Edited Words and phrases I wish people would stop using.

    There are certain words and phrases that drive me absolutely bat-shit crazy. Some have been around for decades and others are relatively new. "It is what it is". Not the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Created Words and phrases I wish people would stop using.

    There are certain words and phrases that drive me absolutely bat-shit crazy. Some have been around for decades and others are relatively new. "It is what it is". Not the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in What are your Other Hobbies Aside from Coding?

    Mostly reading and music.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Marked Solved Status for [HELP]Calculations in VB.net[retail and wholesale(stocks)]

    Really need help please this is my code: Sub updteWS() Dim sql = "select Count(*) from ItemProduct where Code= ?" Dim cmd = New OleDbCommand(sql, conn) cmd.Parameters.AddWithValue("@Code", LVCart.Items(0).SubItems(0).Text) Dim result …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Edited To reload a form in vb6 without closing it .

    I want to reload my form in Vb6 without closing it. I am sending a data through serial comm and receiving it. Now i want the repeat the procedure again …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Edited Getting the nth number of a line in a ListBox

    I have object names in a ListBox. When a name(line) is clicked, I need to know which line (by number) has been selected. Using that number, I can then do …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in "Marked Read" Hotkey

    I don't understand what you mean by "break out of the editor". All you have to do is CTRL-A to select the text and DEL to clear it.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in relationships between tables

    Lighten up. diafol did not out-and-out accuse you of asking us to do your homework. What he *did* do was take the time to provide information on table relationships, something …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Created "Marked Read" Hotkey

    I see that ALT-M has no particular signficaance on Daniweb pages. I recall that there are one or more hotleys already defined so would it be possible to link ALT-M …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in [HELP]Calculations in VB.net[retail and wholesale(stocks)]

    For what it's worth, GOTOs are evil. Before the advent of structured programming constructs like IF-THEN-ELSE, GOTOs were a necessary evil, but used properly they could be tolerated. I, myself, …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Jokes

    Would it be possible for us to limit ourselves to posting jokes that do not make fun of the imagined stupidity of particular groups? In the same vein - I …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Random Facts

    Five percent of people surveyed admit to having checked Facebook *during* sex. [Source](http://time.com/36197/checking-facebook-during-sex/)
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in how to save array element in database table

    Are you doing an insert or an update? Are you using SqlClient or OleDB?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to Stuugie in Specializing further from a Computer Science degree

    I know a guy that got his degree in ACS and then minored in geographic studies. He now develops geographic systems used for topography. On the surface (bazinga) that seems …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Specializing further from a Computer Science degree

    >Is that a degree as in - a 3 year undergraduate one or a postgrad? Four year honors degree.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How to hack an election, Virginia style

    IMO, a better electronic voting system would be two-part. The voter would make selections on a touch screen. Once completed, the machine would print out a filled out ballot with …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How to hack an election, Virginia style

    When the party in power already benefits by gerrymandering and passing voter ID laws designed to minimize opposition votes, why should we be surprised when they also benefit from electroniic …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in What is your current motto?

    Carpe per diem (sieze the money)?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Specializing further from a Computer Science degree

    A friend of mine took his first degree in computer science then did a degree in medicine specializing in diagnostic imaging relating to cancer treatment.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in yahoo

    I strongly suggest you read [this](https://www.daniweb.com/software-development/vbnet/threads/424836/please-read-this-before-posting). It's titled **Please Rest This Before Posting** for a reason. Point 2 says, in part Create a meaningful title for your question. Your thread …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Wisdom Teeth

    I have two impacted wisdom teeth that haven't budged in 30 years. The dentist figured that if they didn't bother me then we should leave them alone. The chances of …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Anywhere Access to your server is blocked

    To rule out the router, why not connect a laptop on the same subnet as the server and try to connect?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in mute?

    Likely already answered [here](https://www.daniweb.com/software-development/vbnet/threads/494665/monitor)
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in EXPORT DATA FROM SQL TO NOTEPAD USING VB.NET

    What does your output look like with the above code?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Need help getting mouse to move to coordinates

    If the thing you want to click is a button you can always execute it by myButton.PerformClick()
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Auto filling textboxes based on an entry into another textbox

    You could clear the textboxes whenever you do a insert or delete. This is unrelated to the question but you might simplify the query as query = "SELECT StudentNo,Fullname,Year,Term,Class " …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Save Listview items to database

    The output of the Debug.WriteLine statement should look like INSERT INTO tblSales (proDescription, SaleValue) Values ... If you don't see it then replace the line with MsgBox(sqlQuery) I need to …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in HORRIBLE Malware / Virus Plus + Unknowlegable person caused MAJOR headache

    I don't know how your system is partitioned but what I have done for years is (on a single disk system) to create a C and D partition where C …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Marked Solved Status for Can someone help me with my logic for a bill program?

    I am trying to calculate a cable bill for a residential and business customer can someone point me in the right direction for my logic?For residential customers it is 4.50 …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in EXPORT DATA FROM SQL TO NOTEPAD USING VB.NET

    Sorry about that. My previous post had a typo. Try For Each row As DataRow In dt.Rows Dim line As String = "" For Each column As DataColumn In dt.Columns …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Save Listview items to database

    In order to determine what is wrong with your query we have to see the query and that depends on the values you are patching in from the listview. You …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in The future!

    Anyone can write a story about technology gone bad. There are a lot of stories about things going south when man decides "to play God" and is punished for it. …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Save Listview items to database

    Replace Dim cmd As New OleDbCommand with Debug.WriteLine(sqlQuery) Dim cmd As New OleDbCommand and post the output here.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Update program.

    @altjen - Please do not request help via Skype. Any answers provided through Skype would not be of use to anyone else on this forum.

The End.