Hello. I have an asp:Button that in the click event I would like to have it
the following in the click event;
This is not working. Am I missing something or is this not the correct way
to reference it in the click event of the button (C#)?
> Hello. I have an asp:Button that in the click event I would like to have it
Can anyone point me why the following code is not working for me? Its giving
me an error while executing "SelectNodes" ...
I have strugled for almost one full day.. I am comaratively new to XSL and
I appriciate any kind help.
Private Sub Save()
Dim xmldocRoot As New XmlDocument()
Dim xmlnodeChildNode As XmlNode
Dim xmlnodeAttributeNode As XmlNode
'Dim xsltcon As Xml.Xsl.XsltContext
Dim ns As New XmlNamespaceManager(xml...Need Help with Sumif Function including dates
I need some assistance with tracking my commissions that are due to be paid
each month. The "Comm Due Date" is in column "C", rows 3 - 30 which list by
date all of the Commissions Due to be paid and the "Comm Balance" is in
column "H", rows 3 - 30 which has the Commission Balance due for each sale.
I tried utilizing a formula from a post that I found from April '05 but for
some reason I keep receiving a #NAME? error. I'm not sure what I am doing
wrong. I want to find the total due by month so that as I add additional
sale...Error 1004 using array in Sheet select.
If I select a sheet with its real name:
Sheets("Sheet1").Select >>>>>- Works fine
Sheets(Array("Sheet1", "Sheet2")).Select >>>>>- Works fine
If I assign the sheet name(s) to a constant
Public Const TSGSheet1 = "Sheet1"
Public Const TSGSheet2 = "Sheet2"
Sheets(TSGSheet1).Select >>>>>- Works fine
Sheets(TSGSheet2).Select >>>>>- Works fine
Sheets(Array(TSGSheet1, TSGSheet2)).Select >>>>>- fails with Error 1004
My macro's/V...Text box
I want to add a text box for a email address at the begining of my all my
The Email address must be inserted into the 1st text box before anyother
text box can be completed. I am using MS FrontPage 2003.
If you are using the standard FrontPage Form Field validation, the best you
can do is to require that they enter something in the field before the form
is submitted. Right-click the email one-line text box and select 'Form Field
Validation'. Check the 'Data Length' 'Required' checkbox.
~ Kathleen Anderson
Microsoft MVP - Expression...How to download & use old product key
I bought my version of Office 2007 in Nov. 2008. New laptop came today. I
still have the old product key, but can't access my purchase history on the
website. How can I download & install Office 2007 on this new computer with
my old product key? I'm ONLY going to be using this new laptop from here on
Did you keep all the downloaded files on the old laptop? Do you have the
original e-mail with the download instructions? Have you tried contacting
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intac...using outlookweb access
Hi, i don't know if any one can help me on this. Here it
is. I am using microsoft Outlook webaccess to access my e-
mail from the office while i am at home. But i also want
to be able to browse my company's network at home also,
and have access to files and folders,so that i can do work
from home. Is this possible. Please resond, this is very
They could set up VPN for you...
"Anna" <email@example.com> wrote in message
> Hi, i don't know if any one can help me on this. Here it
> is. I am using micros...Why is it defaulting to plain text for replies and forwards?
All of a sudden, my Outlook is set whereby all replies and forwards open in
plain text, even though when I compose a new e-mail it opens in HTML.
...COUNTA function in VB
I can use the COUNTA function successfully within my worksheet to get the
desired answer but I am having trouble using it in VB even though the help
file says it can be used in macros.
Any help would be greatly appreciated.
This is from an armature but I was having trouble using VLookup in
macros and learned here that the syntax is:
Application.WorksheetFunction.VLookup(...... Suspect that is the
solution to your problem.
"Phillip Topping" <firstname.lastname@example.org> wrote in message
> I can use the COUNTA fun...Numbers are automatically rounding off
When I type in data in my form, the numbers are rounding off like 42.36 will
round off to 42... How do I change this
Check the data type of the bound field. If you select Number, the default is
Long Integer, which doesn't support decimals. You need to use a data type
that does support decimals, such as Single, Double or Decimal.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"jtidwell" <email@example.com> wrote in message
> When I type in data in my form, the numbers are ...Converting variable text strings to numeric
I've imported some word tables into excel, the 'numbers' have spaces instead
of commas and consequently are read as text.
The 'numbers' vary from single integer to millions
1 101 335
While I can use the left, mid and right functions for the millions that
formula is unworkable for other numbers.
Any ideas, or do I have to get a VB programmer to write a function for me?
Try using Find/Replace
Select the range
Find What: enter a space by hitting the space bar
Replace With: nothing..."Thickening" text
I am using Access 2003.
I created a form for my database to edit/enter new data. Within the form, I
inserted a tab control box with three pages, and within each tab page, there
are various fields and labels.
My problem happens when I open the form in Form View and scroll through the
records. As I scroll, the text in the labels gradually "thickens", to the
point where it appears to be in bold and is difficult to read.
What is strange about this problem is that 1) it only occurs on the second
and third tab pages (not the first), 2) it only happens with True Type fonts
in ...use of Staionery for replies and forwards
I am using the "stationery" function rather than the "signature" function to put a header and a Sincerely Yours in my outgoing emails. That way the spell checker still functions. Problem is that it doesn't come up in when I reply or forward an email. I would like it to
You cannot have the Stationary to be functioning while you reply o
forward to messages. This is because the Stationary tends to be th
background and so for a forward or a reply you cannot have tha
-----------------------------------------------------------------...Modify RM HATB by Document Number
Our receivable orders either start with SL which means sales or MN which
means maintenance or RN which means renewal.
we want to run the HATB separately for each of these order sequence. I tried
to add a restriction but do not know how to add a 'begins with' restriction
as I only see equal to operator available.
Also, say if the restriction works, how can I duplicate the report into 3
copies and run it with different restrictions in the same reports dictionary.
Try using the SUBSTRING function, e.g. SUBSTRING=("SL*")
See Knowledge Base article: 856861
...convert number format to time format
I have a whole column in which I need to be able to enter a number an
it should convert it to the time format. If I enter 100 it shoul
convert it to 1:00. Similarly entering 2300 should automatically b
converted to 23:00.
Message posted from http://www.ExcelForum.com
No need to send the same question to different groups.
The answer given in programming was:
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax...number formats that allow you to format the appearance of negativ.
I don't understand what it means to List two number formats that allow you to
format the appearance of negative numbers using parentheses?
There are up to four parts to a format in Excel, separated by ;, so
So if you want two decimals and parenthesis for negatives, you could use
Notice you don't need one for text so I have not included it. If you miss a
format type then you should still include it's separator
Has only set a format for positive numbers and zeroes.
You could...Auto Invoice numbering
I need a auto invoice numbering on a new worksheet that can add a
consequence invoice number from the previous worksheet number.
Any help is greatly appreciated.
see your reply in Excel.programming
P.S.: please don't multipost
"unkown" <firstname.lastname@example.org> schrieb im Newsbeitrag
> I need a auto invoice numbering on a new worksheet that can add a
> consequence invoice number from the previous worksheet number.
> Any help is greatly appreciated.
For the benefi...How to use Outlook express
is it possible to set up outlook exp. but not allow it to be the
default mail client? i'd like to 'check' the link on a page that says:
'contact' and have that email address come up in outlook exp., then
copy/paste the address to my own AT&T mail service but not use outlook
express for anything else. as of now, i have outlook exp. disconnected
altogether and do not wish to use it other than to open up a link.
all responses on this are welcome.........
This is an Outlook News group not Outlook Express - since you asked , here
is the info for th...User defined function calls over linked servers
We are running SQL Server 2008 SP2 Build 3282 and we have have tried using a
user defined function over a linked server. We did not have success getting
"Remote table-valued function calls are not allowed."
We have looked into this and found that UDF calls are not allowed over
Are there any workarounds for this?
Use a stored procedure instead, or bring the data from the remote
server over to a local table before calling the table-value function
against that local data. If multiple users are at play, add a GUID to
the row of data ...[vba-newbie] testing cell text for specific characters?
I would like to test the text value of a cell to determine if i
includes a certain string of characters and set a variable to true whe
In other words, something like this (unknown method in human syntax an
-If Range["A1"] text string includes 'thisText' Then-
boolVariableName = True
Is there a built -in way to do this with VBA? I'm sure there is, but
haven't been able to locate the appropriate funtion in the help files
this forum, or via google. Can anyone assist
Message posted from http://www.ExcelForum.com
boolVar...How to change column titles from numbers to letters.
The columns are labeled in numbers. How do I change this to letters.
> The columns are labeled in numbers. How do I change this to letters.
Tools > Options > General > switch off R1C1 reference style
Deselect R1C1 reference style
> The columns are labeled in numbers. How do I change this to letters.
Go to Tools>Options>General>unselect "R1C1 reference style"
Casey'...How do I set up a text insert?
We are fairly new outlook users running acting agency. We want to know how
you set something up so that when emailing appointments to people we can just
insert the following text
I was shown how to do this but have since forgotton.
Can anyone help??
You can use templates for this such as Quick Parts or AutoText.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, A...Different Number on Printing
I am trying to set up an excel file for my work orders. When a customer
comes in I want to open my excel file and have a number show up at the top of
document that is like from 1001-1100. But I do not want it to be random, I
want it to go in order every time i open the document or better yet print the
document. So if I open the document and fill it out and print it it will
show 1001 at he top. then when I open it again and print it again it will be
at 1002, all the way to infinity.
I think this may be what you are looking for.
"Neemer...Importing number format problem in Excel
I am trying to import numbers from a table in Access that
is stored as a number format into Excel and Excel does
not recognize the numbers as numbers. I have to manually
convert the numbers format via the Excel error checking
I have this problem when trying to paste any type of
number format in Excel.
How can I change the default settings in Excel to
recognize number formats and automatically paste them in
I am using Excel XP in case it matters.
Debra Dalgleish has posted a couple of techniques for fixing this after the
http://groups.go...using Entourage 2008 but keeping Word/Excel/PowerPoint 2004
My Exchange host (Intermedia) offers a free download of Entourage 2008
with its small business hosted Exchange package. I am running Office
2004 for now. If I download just the Entourage application, will this
work even though the other Office applications are 2004? Should I do
anything with the Microsoft User Data folder or something else to
prevent file conflicts? If there's any chance of an issue I'll
probably just get the full 2008 suite so it's all consistent, but just
wanted to know. Thanks. --Russ, NYC
> My Exchange host (Intermedia) ...