How do you get the attribute value using XPath in VB.Net 2003?
How do you get the attribute value using XPath in VB.Net 2003?
"aushknotes" <email@example.com> wrote in message
> How do you get the attribute value using XPath in VB.Net 2003?
Prefix @ to the name of the attribute value.
XmlAttribute attrib =
Anthony Jones - MVP ASP/ASP.NET
> How do you get the attribute value using XPath in VB.Net 2003?
...How to change the string value in the registry?
How to change the "string value" in the registry from the code? As
there is a functionality in my application that the user can change
the "string value" with some GUI. But I m not able to change it as
there is a function RegReplaceKey but its only to take the backup of
old file and to replace it with new one and even i dont know how to
use this functin to suit my case.
RegSetValue/Ex() should do it I think.
Look at the Registry APIs. Also, take a look at my Registry class on my MVP Tips site.
On Sun, 26 Aug 2007 23:59:33 -0700, HItz <hitesh_im...Getting rid of #value
How am I able to add a column of numbers when one of the numbers in the
formula is itself a formula that results in #VALUE (because that number the
product of zero times another number)?
First, the product of zero and another number shouldn't be giving you
Your best bet is to fix or bypass whatever is causing the #VALUE! error.
If you can't do that for some reason, array-enter (CTRL-SHIFT-ENTER or
In article <_e6dnZvUCo7b1mHdRVnfirstname.lastname@example.org>,
"Craig" <email@example.com>...'Counter' value of the 'Perflib' subkey
I have a program which queries the 'Counter' value of the 'Perflib' subkey in
the Windows registry using RegQueryValueEx. It used to work fine but now the
debug build of my program is broken on Windows 2008 Server R2.
The 'Counter' value is a REG_MULTI_SZ type data and is terminated with two
NULL characters. However, I found out for Windows 2008 Server R2, the value
returned from RegQueryValueEx has an extra character(0xcdcd) after the two
NULL characters, which ends the 'Counter' string value. And that extra
character causes my program to fail ...Behind the times
Behind the times, I know.
I have recently graduated from Office 2000 to 2003. In 2000, when I would
insert a picture I could format it with one or more items (line, line color,
position, etc) and then move on to the next jpg, hit the F4 key and the photo
would have the same formatting.
That doesn't seem to work in 2003. Help files discuss "repeat" on the edit
menu, but it doesn't seem to work on a pic. What am I missing here?
This is going to be a pain to format each picture individually.
I don't have 2003 handy to check, so I'm not sure what t...screen freeze after long time running
I have a program written in Microsoft Visual C++ .NET . Its interface
is based on CFormView. It includes three tabs to show information and
plots. The plots are made by BitBlt() which copies data from the
vectors to the screen around every 5 minutes.
The problem is that after the program runs continuously for more than
3 days the screen freezes. Nothing is updated. I have to minimize the
window and it may return to normal look. Some static labels on the
interface also freeze or appear strange look.
Does anyone have similar experience ? Thank you for your hints or
<e...retrive value from lookup screen
i hv small problem
i make refrence for smartlist (SL)in GP form to enable me open the SL lookup
form ,and i add lookup button to open that smart list but i want the retive
value from SL to be inserted in text box exist on GP form
please help me
...Adding Hyperlink to multiple values within a cell
My spreadsheet contains a list of people. The cell next to each nam
contains multiple numeric values for identifying a specific piece o
information. I would like to be able to click on one of those number
(value) and a comment window pop up with the information associate
with it, or be hyperlinked to the information further down th
I want to avoid using multiple cells for this.
Is this possible?
t2true's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=387
View this...automatically sending messages at set times??
Wondering if there's a way with Outlook to send a default message at a
ie: a message for my ex to repay me her debts on a weekly basis :P
"Adam Membrey" <firstname.lastname@example.org> wrote in message
> Wondering if there's a way with Outlook to send a default message at a
> specified time??
> ie: a message for my ex to repay me her debts on a weekly basis :P
Sure if you are willing to write code but chances are it would
be easier to do from the command line with one of the email
utilities like ...can i see the date the last time a cell was changed?
I am trying to figure out a formulla to make the date appear in one cell
everytime anouther cell's data is chaged.
Use a worksheet_change event to copy the cell address and put in a date
"JohnNuTek" <JohnNuTek@discussions.microsoft.com> wrote in message
>I am trying to figure out a formulla to make the date appear in one cell
> everytime anouther cell's data is chaged.
There really isn't a worksheet formula to do that. Typicall...Open excel sheet twice at same time?
Probably a question asked all the time, but I often have trouble opening a
file after making a desktop shortcut to an excel file. When opening, it
gives an error message about opening a file with the same name at the same
time (even though I'm not). The error message continues by saying that it
doesn't matter if the files are in different folders and suggests renaming
one of the files.
No reason I can think of that would cause Excel to load the file twice
irrespective of launching it from a shortcut. Couple of things to check:
- The file isn'...CLick on Box to enter time of day
I have a worksheet where payment is entered in column C. I would like to
use Column B as a time stamp. In other words as soon as data is entered
in C5 then the exact time comes up in B5. When data is entered in C6
then the exact time cones up in C5. I do not want this time to change
even when the page is saved and opened later on.
You can enter a static time in a cell by hitting CTRL + SHIFT + ;(semi-colon)
You could also use event code to enter a static date when you enter something in
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'when entering data in ...Time entered (and handled as data) in simple minutes and seconds.
Using Excel 2003.
How can I get Excel to display and handle entries for duration in minutes
and seconds only (without having to enter a 4'30" entry as 0:04:30)? I have
gotten as far as getting it to display as "04:30.0", but all I need is
single digit minutes (data on this spreadsheet will never go over 9:59) and
double digit seconds (and to be able to enter them simply as in "4:30"). I
couldn't find that as an option in the ones listed for time in the cell
format dialogue box. Right now I have to enter 0:04:30 in order to get it
to work right. Is t...Combo values from query based on form fields
I am setting the values for a combo box in a form(s) via a query that
'filters' the results with criteria based upon the values of other fields on
the form. The combo is a field that is bound. However, this is giving all
kinds of problems ranging from Access completely crashing to being asked for
the parameter values of those criteria fields when closing the form. I have
tried making the combo an unbound field and then setting the value of the
bound field to that unbound field after update, but that still leads to the
same issues. How can I do this?
As example - I have a form w...Microsoft Business Portal Project Time and Expense Software Compon
I'm interested in the time and expense functionality (called "Business Portal
Project Time and Expense") that is described under "Dynamics GP" domain.
However, I do not readily see the relationship between "Dynamics GP" and
"Microsoft Business Portal Project Time and Expense." What Microsoft
products do I need in order to reach my goal of operating "Business Portal
Project Time and Expense"?
In terms of what you need to purchase, the answer depends upon what you have
an what licensing method you are using:
The Time and...Add values in a column according to value in another column
How can I add the values in a column according to values in another
column? If there is any value in a row in column B, I want to include
the value of the corresponding row in column A. I'm flexible as to
whether this is ANY value (i.e. not empty) or greater than zero.
Maybe something like this =IF(B1="","",IF(B1>0,B1+A1))
"Paul Kaye" <email@example.com> wrote in message
> How can I add the values in a column according to values in another
> colu...CComboBox shows only one item at a time !
I am using CComboBox control and have tried both dropdown and dropddown list
styles. The problem is that I have several items in the combo box but
dropdown shows only 1 at a time (i.e. the arrows of v-scrollbar are stuck
together).. How do I remedy this ?
Thanks in advance.
"Ashish" <firstname.lastname@example.org> wrote in message
> Hi All,
> I am using CComboBox control and have tried both dropdown and dropddown
> styles. The problem is that I have several items in the combo box but
> dropdown sho...IS Mailbox Average Delivery Time
We are using HP Open View and are receiving messages stating:
“The IS Mailbox database instance 'SG2-Front-House'Average Delivery time
(13228 secs) for last 10 messages is too high (>=10 secs)”
We receive an alert approximately 4 times an hour with the seconds ranging
anywhere from 100 to 30,000. We had restriction set on a SMTP connector at
one point. We removed these to see if this was the cause. Nothing has
changed. I have looked online, but can’t find much information as to what
might cause this.
One theory I was leaning towards was the fact that we have some users w...lookup value based on multiple criteria
Banging my head on this one... can anyone help??
I've got several thousand rows of data in three columns,
structured similar to example below. Each set of ID
numbers represents a separate contact entry (person) in
an address book. FIELDNAME could include one or more of
about 200 fields, and VALUE may be blank.
ID FIELDNAME VALUE
1 FirstName Bob
1 LastName Smith
1 Company Tech Smith, Inc.
2 LastName Johnson
2 Company <blank>
2 FirstName Jim
I've got a second sheet set up with all of the 200
possible FIEL...List records that do not include specified value
I have a very basic select query that list all the records from a table
SELECT tbl_cngu.cngu_no, tbl_cngu_recalls.recall_no
FROM tbl_cngu LEFT JOIN tbl_cngu_recalls ON tbl_cngu.cngu_no =
ORDER BY tbl_cngu.cngu_no, tbl_cngu_recalls.recall_no DESC;
Now I need to apply a twist and do no know how.
The [recall_no] field is a numeric field 1,2,3,4,5,... and what I would like
to do is supply the query with a [recall_no] value and have the query return
those records for which there is no such [recall_no] for a each given
[cngu_no]. How would I do this?
T...Difference between two times in seconds
hi i need a favour regarding finding out the time spent between two times in
I need the current time like 12:35:45 PM in a cell A1 and after some time
put time in cell A2 as 12:37:50 PM.
I need the shortcut formula for putting in a cells (A1&A2) so that it should
come in Hr: Min: Sec format.
And after that I need the difference of this two times in Seconds (125
seconds above) in cell A3.
use a custom format in A3.
this will keep the time from rolling over to minutes and total the seconds.
"Radhakant Panigrahi" wrote:
...Copy Macro values to new sheet
I have a macro which creates a text file to an new excel document.
I have placed within this macro a function to put a button on this sheet, the
thing is, is that I can't find away to import the code needed for this button
to the sheet
If you know, can you help me please
Message posted via http://www.officekb.com
...time formula #2
I am trying to calculate in and out time for a time sheet spreadsheet.
Example: 9:00 am (in time), 5:00 pm (out time). I devised a formula:
It works for all senarios except if you begin with PM and end with AM.
5:00 pm (in time), 1:00 am (out time)
Can anyone help me!!
I've done something similar for Surgery in and out time for my
hospital. Our times never cross a day though.
Understand that time is saved as a faction of a day: a date/time raw
looks like 1000.0001
everything to the left of the decimal is date info, e...Average time from date column?
I have a column that is in general date format, 6/19/2007 5:34:23 PM.
In another column I have a value between 10 and around 50. What I have to do
is get the average of this number by time in a day.
So if the number is 10 all day, then the average is 10. If the number is
changed during the day, say its 5 for half the day then 10 for the other half
of the day, then the number I'm looking for is 7.5.
If the number is 5 for 1/4 of the day and 10 for the other 3/4 of the day
then the number would be around 8.5..... if you follow what I'm trying to say.
So far I have been a...time adding in excell
according to the help in Excell-2000 it says to add time
use this formula if the result is to be over 24 hours---
=Sum(cell:cell)*24 the problem is it doesnt work --the
only sum it comes up with is 0:00
The problem here is that by multiplying the sum by 24, you are changing to
a decimal number of hours, but because you are summing time, the result cell
format defaults to time.
Solution, format the result cell as number, or leave it as time and don't
multiply by 24.
... looking out across Poole Harbour to the Purbecks
(remove nothere from the emai...