• Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in What are you eating/drinking right now?

    Never heard of it. What is it?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How is the weather today in your country?

    You can say the same thing about bullets (no - I'm not trying to start that up again) - perfectly harmless unless you happen to get in the way of …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How to check if there already exists an id in a main table

    If a field has been designated as AUTONUMBER then you cannot include it in the insert query. If you want to insert all records from the temp table into the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Help with Inputbox!

    If you only need the values available for the duration of the calculation (once the button_click exits the variables can "go away") then you can declare the array in the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Help with Inputbox!

    The standard deviation is the square root of the variance and the variance is the squared differences from the mean. So to get the variance you must 1. calculate the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Select only two records from a ID number

    >filter up every Company ID on keeping only two records What exactly do you mean by this?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to diafol in Get row before SELECT query

    (SELECT * FROM times WHERE id IN (SELECT onerows FROM (SELECT (@rownum:=@rownum+1) -1 AS onerows, a.* FROM times AS a, (SELECT @rownum:=0) r) AS t WHERE cycle = 1)) UNION …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How is the weather today in your country?

    I saw that on the news yesterday. I'm glad it missed you. I think I'll stop complaining about the snow now.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How to check if there already exists an id in a main table

    I don't believe the first query will do anything. The syntax is WHERE [SOMEVALUE] NOT IN (LIST OF VALUES) however your syntax is WHERE [SOMEVALUE] NOT IN (RECORDSET) What exactly …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Help with Inputbox!

    To start with, you do strInput = InputBox("Please Enter Test Scores", "Enter Score") which prompts the user to enter the test scores. Then (supposedly once the user enters the scores) …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How to check if there already exists an id in a main table

    Try doing a `SELECT COUNT(*)` on the record with that ID. If you get a result of 0 then the record does not exist.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to khal3d in Assignment

    Write a VB app that has two forms. On the first form create six labels and four text boxes, four buttons and a main menu The label text properties are: …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How i make ERD Diagram for payroll salary for employees

    I have a feeling that this is a homework assignment.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Button Click Event Within Another

    In the last week or so I posted a new tutorial on creating and managing background threads. You can find it [here](http://www.daniweb.com/software-development/vbnet/tutorials/477520/how-to-use-backgroundworker-to-create-threads).
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Removing individual NTFS permissions from a folder

    >You can set the attributes in vb.net. I don't think that allows you to play with the access lists, just the regular attributes (read, hidden, system, archive). If you go …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Removing individual NTFS permissions from a folder

    Go to a command prompt (running as administrator) and type icacls /? I think you want the /remove[:[g|d]] Sid removes all occurrences of Sid in the ACL. With :g, it …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Data type mismatch in criteria expression.

    Try removing the single quotes from the numeric fields as in qry = "SELECT * FROM [per_diem_accomodation] " & " WHERE [project number] = " & projcode & " AND …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in how to make translator ?

    What's wrong wih google translate?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in how to make translator ?

    Not to mention idioms. How do you translate "have a ball" into another language and have it mean the same thing? There's a big difference between knowing the words, knowing …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to happygeek in How to remove malware from a Windows PC

    There are two very obvious truths which need to be stated before going any further: Truth 1 - prevention is better than cure, so don't visit 'dodgy' sites or download …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to ddanbe in What are you eating/drinking right now?

    Drinking a Duvel ![9a8efd5a45d6639220ffed744de1206b](/attachments/small/1/9a8efd5a45d6639220ffed744de1206b.jpg "align-left")
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in cacls unlock fail

    You could download and burn a Linux LiveCD, boot from it, then copy the folder/files to a FAT32 partition. Then delete the original files and copy the copied folder/files back …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in how to make translator ?

    Of course it only works on individual words. What did you expect?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in What are you eating/drinking right now?

    Lime chili peanuts.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Get paid to answer questions

    If one of the ways people can target expertise is via endorsements then that will have to be revisited (is there anyone here who didn't expect me to bring this …
  • Member Avatar for Reverend Jim
    Reverend Jim

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

    @Stuugie - I know of one application at Dovercourt when I retired in 2008. It was running, believe it or not, in a Windows 98 virtual machine.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Get paid to answer questions

    If a thread goes dead without being marked as solved then after a suitable period the bounty could go into general revenue. Another thing to consider is hijacking. We have …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Gave Reputation to jwenting in Anyone in for homeopathy?

    sadly those crooks get a lot of support from 'celebs', and many people are foolish enough to take anything their group of favourite 'celebs' claims as gospel.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Control in TabControl

    You can also see from the \*.Designer.vb file that there are other properties that you may want to set. You will also have to add event handlers at runtime. You …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Control in TabControl

    I find the easiest way to figure this out is to place the controls in the IDE then look at the <form>.Designer.vb file that is created when you save. If …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Get paid to answer questions

    I agree with pritaeas. In order to help avoid gaming the OP should pick which answers, if any, were helpful. I have occasionally posted in a thread, not with a …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Syntax error in INSERT statement

    Weird. Perhaps it is something specific to Access. If I ever install it again I'll have to try it out to see for sure.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Syntax error in INSERT statement

    When I try to create I get Error:: CreateDatabase ( Inventory): Class not registered I don't have Access installed. I thought it might be somethinig I could figure out without …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Syntax error in INSERT statement

    There must be something very different between your system and mine because when I run your code I still just get Must declare the scalar variable "@parm". I'm running vb.net …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Microsoft confirms it's dropping Windows 8.1 support

    I think they tried that more than 10 years ago. As I recall the intention was to split them between OS and apps. It didn't stick. Too many friends in …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Writing code to average quiz scores

    If you start wiith a class level variable to contain the running total, and another to contain the number of scores then you can have a textbox for entering the …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Microsoft confirms it's dropping Windows 8.1 support

    I think we should all agree that Microsoft terminology sucks. They released Windows 7 followed by numerous Windows updates. After that came Windows 8.0. No problem there. Then they released …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Anyone in for homeopathy?

    We have an elderly friend who takes medication for a heart problem. Unfortunately, she believes all the nonsense spouted by the modern snake oil peddlars so whenever something new comes …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Writing code to average quiz scores

    We can't say whether or not you are doing it right if you don't show us what you have so far. You say you want to find the average of …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Background Worker Thread error

    That tells me that **_Req** is of type **HttpWebRequest**. That does not tell me the type of **WebRequest**. I am assuming the error is caused by accessing WebRequest from a …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in ER/EER

    Sounds like you want someone to do your homework for you. That's just not going to happen.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Background Worker Thread error

    You sent me Dragon.rar which does not contain the code that declares WebRequest. Unless I know what WebRequest is I can't say whether or not I have a solution.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in How is the weather today in your country?

    T-shirt weather yesterday and today, and the snow is almost all gone. And only a month late.
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Anyone in for homeopathy?

    For the record, I do not believe doctors should write prescriptions for sugar pills. Pharmacists are paid a dispensing fee for their expertise. I do not think they should be …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Anyone in for homeopathy?

    >Also in placebo-surgeries if you tell the person a few months later that it was a sham the benefits don't go away. Do you mean like the "psychic" surgeons who …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Undeleted a Post in Anyone in for homeopathy?

    >If some-one gets relief from their chronic pain by taking sugar pills is it right to stop them from taking them? If the pain is being caused by some underlying …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Deleted a Post in Anyone in for homeopathy?

    >If some-one gets relief from their chronic pain by taking sugar pills is it right to stop them from taking them? If the pain is being caused by some underlying …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Anyone in for homeopathy?

    >If some-one gets relief from their chronic pain by taking sugar pills is it right to stop them from taking them? If the pain is being caused by some underlying …
  • Member Avatar for Reverend Jim
    Reverend Jim

    Replied To a Post in Background Worker Thread error

    Is WebRequest declared in the main thread?
  • Member Avatar for Reverend Jim
    Reverend Jim

    Edited How to degrade from Windows 8 pc to Win 7

    Please I really need urgent assistance here., I got a brand new pc and want to degrade it from win8 and install windows 7.. The computer system will not allow …

The End.