• Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Where to download dataset of UKM06-1.slt

    If the file isn't there then you will have to contact someone [here](http://www.ftsm.ukm.my/).
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Is it moral to switch from one Q&A to another one

    I agree with you on the first comment. If I was just left to my own programming I'd get better in only a few areas at the expense of many …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to vegaseat in Memorable Quotations

    “Oh Beautiful for smoggy skies, insecticided grain, For strip-mined mountain's majesty above the asphalt plain. America, America, man sheds his waste on thee, And hides the pines with billboard signs, …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to vegaseat in There is an elephant on the loo!

    Every person has a unique tongue print.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Memorable Quotations

    The rise of addiction is a symptom of a deeper sickness in the way we live–constantly directing our gaze towards the next shiny object we should buy, rather than the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Undeleted a Post in Union from 2 or more db and Sum with alias

    Try SELECT (SELECT SUM(total) FROM icm.sales) AS branch1_sales, (SELECT SUM(total) FROM hism.sales) AS branch2_sales
  • Member Avatar for Reverend Jim
    Reverend Jim

    Deleted a Post in Union from 2 or more db and Sum with alias

    Try SELECT (SELECT SUM(total) FROM icm.sales) AS branch1_sales, (SELECT SUM(total) FROM hism.sales) AS branch2_sales
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Union from 2 or more db and Sum with alias

    Try SELECT (SELECT SUM(total) FROM icm.sales) AS branch1_sales, (SELECT SUM(total) FROM hism.sales) AS branch2_sales
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Memorable Quotations

    >"Nobody taxes the sun yet." Actually, several states have passed legislation that effectively financiallyy penalizes those inconsiderate "takers" who have invested in solar panels. So, yes, the government has found …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Limit Text box input

    I know but I couldn't just leave a bad answer as the last post in a thread - even a ten year old one.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Limit Text box input

    A better method is to use the KeyDown event to suppress unwanted keys Private Sub TextBox1_KeyDown(sender As System.Object, e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown Select Case e.KeyValue Case 50 To 59 …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in exe to delete a folder based on User Account

    Use the USERNAME environment variables. On my machine with my current account it is USERPROFILE=C:\Users\Jim You can see the resulting command by echo rd %USERPROFILE%\\.digilabs\ubuildabook\data If you use two backslashes …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Random Facts

    Albuterol is one of the oldest asthma medicines being prescribed. A decade ago an inhaler of Albuterol cost under $15. Today, after being "repatented" the same inhaler costs $50 to …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in select count

    Is your database set to use case sensitive strings? Try SELECT COUNT(*) FROM route WHERE van = 'van1' SELECT COUNT(*) FROM route WHERE van = 'Van1' and see how many …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in So then I wasn't paying attention and destroyed my NTFS.

    Try [testdisk](http://www.cgsecurity.org/wiki/TestDisk). It's free and open source. I haven't had the occasion to try it out but I've read good things about it. There is a [step by step here](http://www.cgsecurity.org/wiki/TestDisk_Step_By_Step).
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in student

    There is nothing wrong with using MS Access for student project database. It's when you want to make a database of any significant size that it becomes a problem. As …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Pop Up On screen keyboard when you click/touch textbox

    Any time. The questions I like the best are the ones where I get to learn something new.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Pop Up On screen keyboard when you click/touch textbox

    Further research shows you should use the following... Public Class Form1 Declare Function Wow64DisableWow64FsRedirection Lib "kernel32" (ByRef oldvalue As Long) As Boolean Declare Function Wow64EnableWow64FsRedirection Lib "kernel32" (ByRef oldvalue As …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Pop Up On screen keyboard when you click/touch textbox

    Apparently it has to do with launching a 32 bit app (osk). Try the following... Public Class Form1 Declare Function Wow64DisableWow64FsRedirection Lib "kernel32" (ByRef oldvalue As Long) As Boolean Private …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in split long string at occurence of a particular word

    To finish... Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click Dim rex As New Regex("\bgo\b", RegexOptions.IgnoreCase) Dim str As String = "Please, go Mr. Gofer and good bye" …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Marked Solved Status for split long string at occurence of a particular word

    Hi Consider the string "Please, go Mr. Gofer and good bye" I want to split the string at the specific word 'Go' (not Go in 'Gofer' or in 'good') in …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to Smalls in Bad Grammar

    Guess I should have said abbreviation instead... Well, brb, I'm going to go blind a fish with my light amplification stimulated emission of radiation while wearing a self-contained underwater breathing …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Islamic State down: Anonymous drops social media bomb on ISIS

    Awesome.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in combo box

    We don't provide code on demand, however, if you show that you have put in some effort to solve the problem yourself we can help you work toward a solution.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Character Identification

    Just make sure that any block of text you write is terminated with a vbCrLf.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in split long string at occurence of a particular word

    By the way, here is a handy [regular expression tutorial](http://www.regular-expressions.info/wordboundaries.html)
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in split long string at occurence of a particular word

    What you want to do is identify all occurrences of the word "go" (ignoring case) while ignoring any occurences of the string "go" that are embedded in a word. A …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Bad Grammar

    >Its much quicker to put what you are going to say in an acronym. That brings something to mind. LOL is an acronym. TTYL, BRB and the like are not. …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in split long string at occurence of a particular word

    This sounds like a homework question so I won't post the code but I can suggest that you use a regular expression to match "go" between two non-alphabetic characters.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Pop Up On screen keyboard when you click/touch textbox

    You can find osk.exe in C:\Windows\System32. Run it and play with it. You will probably be able to avoid writing a lot of code.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Marked Solved Status for Update Database Records From Listview Items

    Hi again, I'm having a trouble in updating an item from listview to database I try this code , but it says syntax error in Update nod=name of dish , …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Update Database Records From Listview Items

    Not a problem. When asked "do you know what time it is", it is easy to guess that the actual question is "what time is it." With code it is …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Create folder/files using VB code

    That doesn't address the question of whether you **should** be storing the file at that location. Just because you **can** do something doesn't mean that you should. What is the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Update Database Records From Listview Items

    Perhaps if you explain what you are trying to do we can suggest how you might code it. You showed us the code but that only shows us what you …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in VB.NET

    That's certainly possible. I've written many applications that take data from one data source and update another. That requires two different connection strings (using two simultaneous connections). However, the OP …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Retrieve an ID with an Autonumber Dataype

    @shark_1 - as for Dim SQL As String = "SELECT ('RQ' & Format(MAX(ID),000)) FROM ReqItemList WHERE ReqItem ='" & inputin & "'" You use MAX to get the maximum value …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Update Database Records From Listview Items

    Try sql = "Update TBLORDERS " & " set qty = qty + ?," & " price = price + ?" & " where nod = ?" You were missing …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Pop Up On screen keyboard when you click/touch textbox

    If you mean a button from the on-screen keyboard then reread my post. However, I suspect you are meaning that you created your own keyboard. In that case you will …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Retrieve an ID with an Autonumber Dataype

    If the column is AUTONUMBER then the value being stored is a simple numeric value, not a string. You are getting back the exact contents of the field in the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Retrieve an ID with an Autonumber Dataype

    What happens if you use the actual column name in the query like SQL = "SELECT ID FROM ReqItemList WHERE ReqItem = " & inputin When you are doing a …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in VB.NET

    It's just a string. Change it like any other string. If you don't know what to change it to please refer to [connection string reference](http://www.connectionstrings.com/).
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in I need to populate a combobox with all the table names from one specific d

    To get the table names depends on your database. For MSSQL you can do SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' or SELECT name from sys.tables I think …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Non-Existant Folder on Deaktop

    You might need to do it from the command prompt running as Administrator. Assuming your logonid is Eileen you will have to check both C:\Users\Eileen\Desktop C:\Users\All Users\Desktop Do a `dir` …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in i cant install the blue tooth driver on ma pc

    I haven't seen a driver update utility that was worth installing. Most come with so much crap (or are nothing *but* crap) that they cause more problems than they (supposedly) …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Pop Up On screen keyboard when you click/touch textbox

    I'm not sure I see the problem. If you run osk.exe then click in a textbox to give it focus, whatever keys you click in osk will be sent to …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Things I hate about TV shows

    As much as I love James Spader I will be crossing The Blacklist off my watch list. It's gone the way of Lost and The X-Files and several other shows …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Windows 10

    You might want to check out [Top 10 tips for Windows 10](http://www.infoworld.com/article/2692094/microsoft-windows/top-10-tips-for-windows-10.html) and [Keyboard Shortcuts in the Windows 10 Technical Preview](http://blogs.windows.com/bloggingwindows/2014/10/03/keyboard-shortcuts-in-the-windows-10-technical-preview/). Also [Windows 10 gets a fresh command prompt and …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Windows 10

    I just came across [this](http://www.hanselman.com/blog/HowToSignIntoWindows8Or81WithoutAMicrosoftAccountMakeALocalUser.aspx) for Windows 8.x which will probably work for Wibdows 10. It looks like MS would prefer a domain account but will allow a local account. …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in vb.net cannot allow changes

    And we have yet another thread where the OP goes away without posting the solution that he/she figured out.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Windows 10

    I've been running it in a virtual machine and the one thing that I really don't like about it is that it wants me to create a "domain" account with …

The End.