Reply:

College Assignment Woes
Hello, 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 following table: Name Current Salary Percent Increase Effective Month 2004 Compensation. 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
Hi, I have some XML doc loaded in a C# Web Service. XmlDocument doc = new XmlDocument(); doc.LoadXml(myDoc); Code Missing to manipulate header (I would like to replace or manupulate all these XXXXX): <mso-XXXXXX productversion="XXXXXX"> <mso-application progid="XXXXX"?> doc.Save(myNewDoc); Any idea on how to access and manipulate data within the doc header? Thanks vbdev vb6dev2003 wrote: > I have some XML doc loaded in a C# Web Service. > XmlDocument doc = new XmlDocument(); > doc.LoadXml(myDoc); > > 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 allowed, or B) make it impossible for checks to be accepted on his account? Hi Meralee, Would you be interested in custom alert solution?. if so please drop a email. Regards, nj.tech@hotmail.com "...

Almost Worked
Almost WORKED !! Excelent - almost worked like a charm. ======================== Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim wks as worksheet set wks = me.worksheets("sheet1") with wks.range("A1") if .value ="" then .value = date .numberformat = "MM/DD/YYYY" end if end with End Sub ======================== Issue: The sheet is password protected. The cell in question is locked s users can't change the date it was crrated. Problem: When I try to save it I get the DEBUG because it is a locked cell an the sheet...

Read XHTML into XML
Hi all, 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, JA Reyes. 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! Mike Mike, 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. Regards, Dan "Mike" wrote: > 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? Bill * billsahiker@yahoo.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
Hello, 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? -- Regards... cincode5, 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. ~ ~ Next X 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 help. ME wrote: > 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: <record> <Field1>value1</Field1> <Field2>value2</Field2> <Field3>value3</Field3> </record> What I'm aiming to do is to show the data in a report as in the following example: record: Field1 value1 Field2 value2 Field3 value3 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. Any suggestions? On Jun 26, 10:25 am, Anoymous <Anoym...@discussions.microsoft.com> wrote: > 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 datatypes). 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 Thank you Regards Raj Raj wrote: > 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 http://msmvps.com/blogs/martin_honnen/ ...

String to xml document
Hi there, 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 Sjeems wrote: > 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 individually. 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 "allisons" wrote: > 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 last transaction. 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? Regards, Bill Bill: 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? Please help. ...

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 http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=298 Custom shapes and Autoshapes are similar, 2003 Autoshapes are better... -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ 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? Musawwir Spiegel mms@spiegel-law.com There are no user assigned shortcuts in Excel The default ones can be found in Help - keyword SHORTCUTS best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Musawwir Spiegel" <mms@spiegel-law.com> wrote in message news:1lat51t9a0o86fa6mln39vsp8eic7709r0@4ax.com... > 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 statements. 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 - [afshin@retailrealm.co.uk] CEO - Retail Realm -- URL http://www.retailrealm.co.uk "jord...

auto-update cells with this week/last week's totals?
Hi there! 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 =IF(ISERROR(AVERAGE(E1528:E1534)),"PACE!",AVERAGE(E1528:E1534)) 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 response.write(reader) loop thanx chumley 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 click.. 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...