Search results for query: *

Wow... It's embarrassing how EASY that turned out to be... :) Thanks! All I had to do was to add an extra '(' after the 'IIF' statements.

Hi, This is the situation: I have a table 'results' with the following field names: 'ID', 'Date', 'F', 'A' F and A stand for the number of goals for or against the home team. On every day there can be 1 or more matches played. From this table, I created two queries: 'Games lost per day' 'Games...

I've placed two rich textbox controls and one button on a form. What I want to achieve is that when I click the button, the 2nd textbox will display the HTML code for the rich textbox 1. Something like: richtextbox2.text = ConvertToHTML(RichTextBox1.Text) ConvertToHtml is a function that...

As part of an application that I am designing, I'm letting users enter all sorts of words and their descriptions (like a dictionary) into the application. The problem with this is that it's possible to use diferent languages and therefore also different character sets. In Windows it's possible...

In this article (http://support.microsoft.com/support/kb/articles/Q257/8/19.ASP?LN=NL&SD=gn&FR=0) they explain how AD) deals with Excel. "As stated previously, ADO must guess at the data type for each column in your Excel worksheet or range. (This is not affected by Excel cell formatting...

I'm trying to let VB extract data from an Excel file. For this I use the MS Jet OLE DB Provider. This works OK with most data. In one column however, I keep encountering the following problem. The column is used to store dates. It can have two different formats "mm-dd-yy" and...