Reverend Jim

It the OP manages to do this it would be the very definition of a cache cow.

If you do SELECT MailTypeName, LeagueName FROM MailTypes AS M INNER JOIN Leagues AS L ON M.MailTypeID = L.MailTypeID ORDER BY MailTypeName you get Pass 1 League4 Pass 1 League5 Pass 2 League1 Pass 2 League3 Pass 3 League2 Pass 3 League6 which, with a little formatting, is what you …

I don't know about newer versions of folder lock, but older versions relied on a rootkit. As such, folders were hidden only when accessing them from that machine and that OS. Folders and files were available if accessed from another machine (on the network) or by booting another OS such …

Considering the demographic this is a long shot but is there anyone else here who has been involved in the SPEBSQSA?

Function fact(n) If n < 2 Then fact = 1 Else fact = n * fact(n-1) End If End Function

I've been having a problem for (I'm guessing) a few months that I finally resolved and I'm posting it here as a warning. The problem occurs in Outlook 2003 but may also occur in later versions. **Symptoms** I'd start composing an email in Outlook 2003 and save it to the …

Another possibility would be to have a public property declared in the called form and have it set to a different value from each menu handler. Then the called form could use the value of that variable to do the appropriate initialization. That puts more of the logic in the …

SELECT JOB, GRADE FROM EMP WHERE GRADE <= 'O' ORDER BY GRADE

Run the command shell (cmd.exe) as Administrator then delete the file from there.

Try dtaTitles.Recordset.Find("Author >= '" & cmdLetter(Index).Caption & "'", 0, adSearchForward) It would also help if you specify what version of VB you are using. In my version (2010), Variant is not a valid type. You should be using "&" for concatenation rather than "+". And finally, instead of If dtaTitles.Recordset.EOF …

Same here.

Did MS ever officially implement the open doc format? If so, was it a "real" implementation or was it their typical "our version of ODF" which means "incompatible with real ODF"?

Is there a question?

Just checking your profile. Can you clarify something? You mention >Pretty mad individual Are we talking "monster raving looney" mad or "mad as hell and I'm not going to take it anymore" mad? Or possibly even "a little from column A and a little from column B"? Just curious ;-P

If you have downloaded the entire project file and it was built using Visual Studio 2010 then you may find an executable in either MyProject\MyProject\bin\Debug or MyProject\MyProject\bin\Release Just replace "MyProject" with the actual project name.

You could use a BackGroundWorker control to execute the code in another thread.

EA used to produce great software. They created some of the best software released on the Amiga. However, from what I hear about them these days they are pretty much evil incarnate.

Try objXl.Visible = True

Please post your code.

When you do Dim myarr(2) As Integer You are declaring an array of integers (indices 0, 1, 2). When you do Dim myarr(2)() As Integer You are declaring an array of array of integers. This structure can contain 3 arrays of indeterminate length as in Dim myarr(2)() As Integer myarr(0) …

I suggest using CTRL instead of ALT for two reasons: 1. CTRL-ENTER is used in many other apps for this purpose 1. ALT typically activates the menu

Is that a question?

This sounds like a homework assignment. We don't do your homework for you.

Try SELECT CASE fldname WHEN 0 THEN 'No' ELSE 'Yes' END AS fldname FROM tablename

Do you have a question?

Did you happen to notice that the code as posted is incomplete? For example, even though it starts with **Private Sub** there is no opening **If** statement. That means some of the code was left out.

It's hard to be specific without seeing the code but generally the problem is because you declared a reference to an object but did not actually create an instance. It's the difference between Dim myobj As SomeObject 'a reference to SomeObject and Dim myobj As New SomeObject 'an instance of …

Note that this does no error checking - it assumes that all of the strings represent numbers. Dim strings() As String = System.IO.File.ReadAllLines("D:\temp\test.txt") Dim numbers(UBound(strings)) As Integer For i = 0 To UBound(strings) numbers(i) = CInt(strings(i)) Next A version that checks but does not strictly speaking use an array is …

You can specify the sort order when you retrieve the records by using the ORDER BY clause in the query. SELECT * FROM mytable ORDER BY fieldname

Can you show us the code?

You need to account for all cases. Your function does nothing for Fact(0). You should also just return a value rather than assign it to the textbox in the function. Private Function Fact(no As Integer) As Integer If no > 1 Then Return no * Fact(no - 1) Else Return …

I think you are going to have to ask a more specific question. I really do not know what you are asking. Also, for future reference, daniweb does not use bbcode tags ([B], etc). We use markdown syntax. For details please see [here](http://www.daniweb.com/community/syntax). That page is also available by clicking …

In order to be useful it is necessary for dynamically created controls to be added to the form (or a container in the form). Typically you also want to add event handlers. There are examples of how to create controls at runtime, attach event handlers, etc. in the [code snippets](http://www.daniweb.com/software-development/vbnet/code/_/58) …

You can download Visual Studio Express for free [here](http://www.visualstudio.com/en-US/products/visual-studio-express-vs). This is VS 2013. You can download visual studio express 2012 [here](http://www.microsoft.com/en-ca/download/details.aspx?id=34673)

See this example (con is the connection object) Dim cmd As New SqlCommand("", con) cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "InsertRecord" cmd.Parameters.Add("@Details", SqlDbType.VarChar) con.Open() cmd.Parameters("@Details").Value = "Sample details 1" cmd.ExecuteNonQuery() cmd.Parameters("@Details").Value = "Sample details 2" cmd.ExecuteNonQuery() cmd.Parameters("@Details").Value = "Sample details 3" cmd.ExecuteNonQuery() con.Close() Just replace the centre block (between con.Open and …

I wrote this script a few years ago to do just that. You can modify it to restrict it to specific types of names. See attached. Usage: delete_older_than #days [folder] [-s] [-l] where #days number of days to keep folder name of folder containing files to delete (default is current) …

There is one post by you in the thread that is visible. The deleted post was a duplicate. It is still visible (but greyed out) to me because I am a moderator. What is the problem?

If you do a Split(line,"=") on each line you will get an array where element 0 has everything to the left of "=" and element 1 gets everything to the right. In actual code it looks like For Each line As String In System.IO.File.ReadAllLines("D:\test.txt") Dim fields() As String = line.Split("=") …

While browsing [this thread](http://www.daniweb.com/software-development/vbnet/threads/472112/increment-or-loop-how-help-me-good-sirs) I noticed that the code was unformatted. Mr. Waddell is well aware of how to format code so I was surprised. When I went to edit the code, however, I saw that it **was** formatted correctly. Here is a section of the code as originally entered …

From what I understand, fingerprints are not compared the way you would compare images. This is especially impractical considering the varying quality of fingerprints. Some are partials, others are smudged, etc. Instead, fingerprints are reduced to a numerical representation that describes certain characteristics (whorls, bifurcations, etc) and these represeentations are …

Start with this Dim sdate As Date = CDate("2014-01-01") Dim edate As Date = CDate("2014-01-31") Do While sdate <= edate If IsWeekDay(sdate) Then ListBox1.Items.Add(sdate & " " & WeekdayName(Weekday(sdate))) End If sdate = DateAdd(DateInterval.Day, 1, sdate) Loop Private Function IsWeekDay(d As Date) As Boolean Return d.DayOfWeek >= DayOfWeek.Monday And d.DayOfWeek …

You have to refer to a particular instance of an object. Use form2.TextBox1.Text rather then form2.TextBox.Text

Album art can also be embedded in the mp3 file itself as metadata so don't knock yourself out if you end up with album art but cannot locate a separate art file.