Search results for query: *

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...

You have four situations that could happen: 1 - Both account number and PIN are correct. 2 - The PIN is correct, but the account number is wrong. 3 - The PIN is wrong, but the account number is correct. 4 - Both the PIN is wrong and the account number is wrong. Depending on which situation...

When either the pin is wrong or the account number is wrong, how do you think the code acts in a different way?

My advice would be to ignore the code for the time being, and just work out how the program flows, and how you want it to flow.

This is an example of the xml: <?xml version="1.0" encoding="UTF-8"?> <!--Sample XML file generated by XMLSPY v5 rel. 2 U (http://www.xmlspy.com)--> <REPORT_LOCATION xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="Location.xsd"> <CITY ID_CITY="Strin">...

We have an xml file with a reference to the xsd. In the VB code we ask for the xml file, which we want to load into a dataset at a later stage. But to validate the xml file against the xsd, it seems that I need to specify the location of the xsd in the VB code. Why can't the xml methods...