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...
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
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
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...
We have a client who has supplied an xml file that I think is not quite right, but I'm not sure how to word my reason why I think this.
There file is structured in a similar way to this:
<root>
<item_number>1</item_number>
<item_description>a widget</item_number>
<item_number>2</item_number>...
We are attempting to retrieve a list of available SQL servers on the network and locally.
It works fine if the PC we are running on is connected to the network, such that the smo objects retrieve network and local SQL servers.
But if we disconnect the network, the smo objects fail to retrieve...
We are attempting to retrieve a list of available SQL servers on the network and locally.
It works fine if the PC we are running on is connected to the network, such that the smo objects retrieve network and local SQL servers.
But if we disconnect the network, the smo objects fail to retrieve...
So if I create the following query:
select t2.field1 from t1 right join t2
on t1.field1 = t2.field1
where isnull(t1.field1, 'xxx') = 'xxx'
If I have written this right, this should return all those values in t2.field1 that are not in t1.field1
But what if instead of a table called t2, I just...
I guess this is probably a silly question:
I know I should upgrade from vb6, but should I upgrade to 2002, 2003 or 2005?
I currently have VS6 and VS 2002 installed on my PC - shall I just leave it as is and carry on on 2002?
Thanks
John
We have a table that has about 2,000,000 records in it. It has an ID field (integer) that is the Primary Key, but it does not auto-increment.
To insert a record you have to specify the new ID number. Which since we have multiple users inserting information with various applications, means I...
I want to generate a reference number based on the following format:
ddddd/nnnnn
where ddddd is a unique number for the day, which is increased by 1 every day.
nnnnn is an incremented number for each item and is zeroed every morning
given the table:
CREATE TABLE [ReferenceNumberTable] (...
How do other people deal with their call centre's agents treatment of headsets?
Our agents are continually on the phone, as such the headsets are lasting just over a year.
How long have other people seen headsets lasting?
Does anyone know any durable makes?
We have some platronics, and other...
We have some odd things happening with our main ACD queue. Occasionally operators who should be next in the queue to receive calls are skipped by the system.
The queue has been looked at by our SP and by ourselves and there are not any problems with the set up. But still occasionally the next...
I am trying to configure our call center supervisors phone so that her MWI light responds to three general voicemail boxes as well as her own.
I'm having problems setting up the xmwk key for the main acd queue.
Being a supervisor she is part of a managers queue which is seperate to the main...
We are having some sort of network failure on one of our unix machines, which results in the above error message. Including mention "serious error in ./pciconsvr.ip (PID 485), will try to continue unrecoverable error on interface " then our IP address.
The network card has been...
I have a VB app that gets telephone call information from a comms port using Gport.input. This is then printed to a file and also displayed in a textbox, but the problem is that there seems to be some characters are being supressed from the textbox. For example in the file it might say the...
We have some premium rate numbers routing to various of our DDI range. Is there any way of our option 11 telling us (through CDR) what the premium rate number that was called was. I wondered if DNIS would solve that, but asking BT product support replied a very terse "no".
Anyone...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.