Recent content by ttdobj

I have created a Ribbonbar for Excel, where the labels for the various controls are programmatically generated in the VBA. This is done so that we can have the ribbonbar in different languages depending on the users settings. If I open Excel, click on our tab the ribbon bar displays and...

Hi, We have created a custom ribbon bar for excel, it is loaded via an xlam adding. Occasionally when we edit spreadsheets, the buttons lose their label text. I have looked in the vba, and our code behind this, but cannot find a reason why it is doing this. Has anyone experienced anything...

Here goes TempDate as Date Dim MyDate as String 'The value to be parsed. ' Validate the Quantity. If Date.TryParse(MyDate, TempDate) = True Then ' Validation succeeded. MessageBox.Show("The date: " & MyDate & " is valid") ' TempDate now holds the parsed date. Else '...

Okay, so now I realise that date.tryparse recognizes it as the ISO standard format anyway. do'h!

We are taking in a text file that has the dates formated in the ISO 8601 date standard. FOr example: yyyy-mm-dd How do I parse this value? I wondered about using cultures, but I cannot find a way of specifying that the culture is an ISO date standard. Can any one help ? Ta John

But also, if an element is present in the file but is empty. For example: <foobar /> is that the equivalent of an occurance of once or no occurance? Yours confusedly John

If in an XSD, an element does not have minOccurs specified, what default value is that element assumed to have? I am running Stylus Studio, which seems to think that the it therefore defaults to a minOccurs value of 1. Is this right? Ta John

danno74 - have you checked out this micrsoft knowledgebase page? MS kb328306 it lists some possible reasons for encountering that error message In the past I have encountered PC's that act differently to their siblings, and it turned out to be an MDAC issue. I'm not saying this situation is...

It depends whether the form is modal or not. If it is modal, it "refuses" to go away unless you deal with it.

on the mark, and closing... then using the exit sub methods that artyk suggested, you can control which messages are shown, and what priority they have over each other

really cool though, m c escher-like you know those times when you're checking some values in a, say datagrid loop, and cause you were lazy you set up a messagebox to tell you the value, and its gonna pop up about 200 times, and your bashing away at the enter key ... d*#n I need a widget to...

Make sure that any of the arrays that will be multi-dimensional are set up as multi-dimensional. For example: public MyArray(,) as date so when you ReDim Preserve the number of dimensions is not altered ?? J

In another thread it has been mentioned that a messagebox can close itself, I personally have never known this. What are peoples thoughts on this?

Never known a messagebox to close itself before ...

Your code says this: If cashpointscreen.Text = objDR.GetString(4) And accountID.Text = objDR.GetString(0) Then Screen.Enabled = True Screen.Visible = True found = False correct = False 'Else 'found = True 'correct = False End If What you could try instead is...