College Assignment Woes
I would GREATLY appreciate it if someone could guide me in some kind of
direction. I have been given the following data:
On a new sheet, named Salary Table, starting at cell A1, build the
My exact problem is that I must createa formula that can be used for
all to calculate the amount to each employee for the year 2004. The
increases take place on the first day of the month specified. This
means that if increase comes in July, the pay is six months at the old
rate and six months at the new rat...XML Header
I have some XML doc loaded in a C# Web Service.
XmlDocument doc = new XmlDocument();
Code Missing to manipulate header (I would like to replace or manupulate all
Any idea on how to access and manipulate data within the doc header?
> I have some XML doc loaded in a C# Web Service.
> XmlDocument doc = new XmlDocument();
> Code Missing to manipulate header ...Can you put an alert on a customer?
We have had a customer write bad check with us. He's since paid us, but he
was not all that cooperative in getting payment to us to cover the check. We
are hapy doing business with him if he's paying with cash or credit cards,
but don't want to take checks from him.
Is there any way to either have:
A) an alert pop up when his account is selected statinf that checks are not
B) make it impossible for checks to be accepted on his account?
Would you be interested in custom alert solution?. if so please drop a email.
Almost WORKED !!
Excelent - almost worked like a charm.
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Dim wks as worksheet
set wks = me.worksheets("sheet1")
if .value ="" then
.value = date
.numberformat = "MM/DD/YYYY"
The sheet is password protected. The cell in question is locked s
users can't change the date it was crrated.
When I try to save it I get the DEBUG because it is a locked cell an
the sheet...Read XHTML into XML
I need to read/parse XHTML aspx pages and look for certain tokens and
content. How can I use a XmlTextReader for this? If not, any other ideas?
Thanks in advance,
Jose Antonio Reyes wrote:
> I need to read/parse XHTML aspx pages and look for certain tokens and
> content. How can I use a XmlTextReader for this? If not, any other ideas?
If the pages are well-formed XHTML then it is possible to use XmlReader
(in .NET 2.0/3.0) or XmlTextReader (in .NET 1.x) to parse the XHTML
documents. You can also use the other XML APIs .NET provides so using
XPathNavigator and/o...Easy way to display custom entities?
Is there an easy way to display any entities that have been created or
customized outside of the default entity set that comes with CRM 4.0?
Thanks and have a great day!
If I were trying to find this information, I would go to Settings ->
Customization -> Customize Entities and sort by type. This will group custom
entites and customizable entities together. I don't know of a way to tell
whether a customizable entity has been customized, though.
> Is there an easy way to display any entities that have been created or
...Sorting in a custom view not functioning as expected
I just can't shake the feeling this is a stupid question, but I can't seem to
get it or find an appropriate Google response.
I have saved a custom view for my tasks. In it, I have a custom sort set up
for my tasks. (A custom field text field "Grouping" ascending, then "Status"
descending, then "Due Date" ascending, if you want to know.)
My problem is, it's often convenient to look at things by category, so I
(and my little users) click on the "Category" heading to get a quick view of
things sorted that way. Then, I want to...How to invoke the xml editor?
I installed vs2005 on a new xp pro machine, and installed everything
except C++. When I click on a file with a ".xml" extension it is
opened with IE. When I click file/Edit with XML Editor, it opens it
with Notepad. If I click File/Open With and select XML Editor, it
opens it with IE. So, where is the xml editor?
Can it be invoked from withing VS? Where?
* email@example.com wrote in microsoft.public.dotnet.xml:
>I installed vs2005 on a new xp pro machine, and installed everything
>except C++. When I click on a file with a ".xml" extension it is
>opened ...VB Assigning Values to a Series of Strings
In the VB Editor, I need to assign each letter of a 13 character string
(named JobScope) to individual Variables (K1 through K13). I'm using a
For/Next Loop to extract the indiv characters but cannot figure out how to
define the Variable K(x) where x = 1 to 13. Any suggestions?
Try making K an array with 14 elements (VBA numbers the first element as 0)
Then you can use the method you're trying at the moment.
For X = 1 To 13
K(X) = etc.
The only other change you'll have to make is how you address the variables
elsewhere. E.g, K5 w...Wndws XPsp3: Auto Update ON but system nags all day to Install Upd
I have my Auto Update set for AUTOMATIC to download/install at 3 am daily BUT
I get at least 4-5 messages per day that "Updates have been found formy
computer". Constantly updating/restarting. This is driving me CRAZY. Please
> I have my Auto Update set for AUTOMATIC to download/install at 3 am
> daily BUT I get at least 4-5 messages per day that "Updates have
> been found formy computer". Constantly updating/restarting. This is
> driving me CRAZY. Please help.
We now know the following blanks in the puzzle...
Windows XP ______ ...show XML schema and values
I have an XML document that looks like the following:
What I'm aiming to do is to show the data in a report as in the following
The "Field1-3"-elements can have any name, so I'm trying to get a table that
has in one result column the element name, and in the second colum...Turn Off the Right-Click Customize option?
I am using Access2003 and,
I need to turn off the Right-Click Customize option on my toolbars.
I was told I could use /runtime in the command line and it would turn off
the Right-Click option. But it didn't work.
On Jun 26, 10:25 am, Anoymous <Anoym...@discussions.microsoft.com>
> I am using Access2003 and,
> I need to turn off the Right-Click Customize option on my toolbars.
> I was told I could use /runtime in the command line and it would turn off
> the Right-Click option. But it didn't work.
> Any suggestions?
Look around your s...Offline synch using XML web-services
This is a bit long-winded. Can somebody read thru these 2 use cases, and
tell me if it is feasible ? :-
Use Case : Replication before Offline Synch
Scenario 1 : Oracle Server , MSDE client
1. User clicks on 'Go Offline'. System creates a MSDE SQL database in
laptop (client), gets the schemas of the tables in Oracle, creates
corresponding tables in client's MSDE SQL (mapping Oracle datatypes to SQL
2. Offline replication program reads in the tables of the server into a
typed datasets, converts the typed datasets into XML, and stores the XML in
the client. (XML serial...XML Serialization ... how to truncate <?xml...
While xml serializing object how can I truncate <?xml ...?> this line alone?
I need to send the serialized xml data to a web method ... since SOAP
already have <?xml tag there was some confusion
Any help would be greatly appreciated
> While xml serializing object how can I truncate <?xml ...?> this line alone?
Serialize to an XmlWriter created with XmlWriterSettings where you set
OmitXmlDeclaration to true.
Martin Honnen --- MVP XML
...String to xml document
I was hoping someone can help me with a little problem I can't seem to find
any answers to.
I've got a form wich will be posted. On receiving the post I would like to
parse a formvar to a xml document.
The contents of this formvar (string) will be a valid xhtml document.
Can someone give me a startertip (or more :-)) on how to achieve this?
tnx in advance,
James van der Veen
> I was hoping someone can help me with a little problem I can't seem to find
> any answers to.
> I've got a form wich will be posted. On receiving the p...Change salesperson for mutiple customers
We fired a salesperson and hired a new one, I want to do a mass change on the
customer cards to put in new salesperson. I don't want to enter each change
Unless they fit neatly in a customer class, you will probably want to use a
tool to update the records. You could use a SQL query (Update RM00101 set
slprsnid = 'new' where slprsnid = 'old' and Update RM00102 set slprsnid =
'new' where slprsnid = 'old') or MS Access or some other tool.
Charles Allen, MVP
> We fired a salesperson and hired a new on...Marking Customers Inactive based on last transaction date
Is there a way to mark customers inactive based on the date of their
For example make all the customers that have not ordered within the
last year would be flagged inactive.
If there is not an automatic way to do this, is there a last
transaction date in the DB that I could use to create a sql script on
the customers that meet the criteria?
I looked at the RM00103 table (summary table) and it holds a field called
LSTTRXDT which is last transaction date so I would think you could go ahead
and build an update statement on the RM00101 and set the INA...Beginner of XML
I am a beginner of XML.
I want to group some files together with a xml file. (it includes a text
file, and an image file and a video file)
Can someone show me some guidelines?
...Custom Shapes & PhotoEditor
Is 'custom shapes' in Office 2000, 'autoshapes' in Office 2003 Publisher?
Also is 'PhotoEditor' in Office 2000, 'Picture Manager' in Office 2003?
You can re-install Photo Editor. Picture Manager is okay for collecting all your
images in one place for viewing and elementary editing.
MS Photo Editor, Wherefore Art Thou?
by Herb Tyson, MVP
Custom shapes and Autoshapes are similar, 2003 Autoshapes are better...
Mary Sauer MSFT MVP
news://msne...How do I display all assigned keyboard shortcuts?
Using Excel 2002, is there a way to display all keyboard shortcuts
presently assigned, both those assigned by default and those that have
been user assigned?
There are no user assigned shortcuts in Excel
The default ones can be found in Help - keyword SHORTCUTS
Bernard V Liengme
remove caps from email
"Musawwir Spiegel" <firstname.lastname@example.org> wrote in message
> Using Excel 2002, is there a way to display all keyboard shortcuts
> presentl...Customizing RMS customer statements
Does anyone know how to add verbage to the customer statements? ie. I want
to note what our finance charge policy is on the bottom of the customer
In our Store Misc Utility we have many features one of which is enhancement
to A/R Statement that allows you to configure different Duning notices for
customer that have balanace over 30, 60, 90 etc... As well as allowing you to
soft configure and type hearder and footer messages.
If you want to know more contact me.
Afshin Alikhani - [email@example.com]
CEO - Retail Realm
"jord...auto-update cells with this week/last week's totals?
I have 3 cells - C2, D2 & E2.
C2 contains the formula =SUM(C1528:C1534).
D2 contains the formula =SUM(D1528:D1534).
E2 contains the formul
C2 shows the total number of miles I have run from Monday of th
current week to Sunday inclusive.
D2 shows the total hours I have run over the same period of time.
E2 shows the average pace I've run at, again over the same period o
time. (I added the ISERROR function for neatness as I had to kee
amending the column width when I get the DIV0 error).
C3, ...Valid xml to read from an xml file?
I'm using vb.net, i get an error at the reader line saying the remote
server can't be found. Is the below even valid?
dim reader as XmlTextReader
reader = new XmlTextReader ("http://www.mysite.com/my.xml")
do while (reader.Read())
'do some action here
XmlTextReader uses System.Net.WebRequest under the covers -- see if you can
figure out how to create a connection that way. Usually there's some proxy
server information missing that you can enable if you use WebRequest
directly, and then pass the result of GetResponse()...HOW TO MAKE THE FORM NOT AUTO SAVE
I want to make the form of the ms access to only save when a button is being
How can i make it to run on that way?
Message posted via http://www.accessmonster.com
...Example eConnect XML documents
MSDN says the following:
Installing eConnect schema
When you include the schemas component of the eConnect install, the
installer places schema files in a schemas folder on your computer.
The following schema resources are available:
The install places the .xsd schema files in the directory c:\Program
Files\Microsoft Great Plains\eConnect9\XML Schema\Incoming XSD
Individual Schemas. The files in the directory contain the schema for
each eConnect XML document.
The install places a file named eConnect.xsd that contains the schema
definition for all eConnect XML documents. The install typicall...