why doesn't this modification to XML receipt work?
how can i modify the fullpage.xml file so that if the sale is charged to the
customer's store account, the title of the receipt is 'SALES INVOICE' -
otherwise we want the title to be 'SALES RECEIPT'...i tried modifying the
file as shown below without success:
<IF><CONDITION> Tender.Descriptor.TenderType = 4 </CONDITION>
<TEXT> "SALES INVOICE" </TEXT>
<TEXT> "SALES RECEIPT" </TEXT>
In eConnect, I tried adding an additional XML node to the existing XML
schema. I like to have these to be added in line item level. When I tried
this, it worked fine when I added a node (along with a procedure in db) at
the header level. But it fails to perform at line item level. Please help me
with the steps to achieve the same.
Thanks in advance.
...Sequence Not populated for the MO Numbers during Data Collection
When data collection is done for the MO Numbers by using the Data Collection
Window under Manufaturing, the Sequnce look up does not show the whole list,
it only shows NOTES, for the user to select and enter the necessary data. why
does this happen in the case of some MO Numbers and in the others it shows
all the sequnces as NOTES,MAKE READY, PRESS RUN, WASH UP, MAINTENANCE,
REPAIRS, REWIND/INSPECTION, etc. Any information would be much appreciated
It should show all of the router steps. Are some of your steps possibly
marked to backflush labor? These steps would not...GetXml from DataSet
I transfer data from a dataset to an XML-document by
using the GetXml-method in VB.NET. I noticed, that for
datafields, which are empty (have no content) in the
dataset, no elements are created in the XML-document. How
can I force to generate elements (with no content) for
this kind of datafields ?
Check out http://www.topxml.com/sqlxml/default.asp It has some excellent
information on this.
"em" <email@example.com> wrote in message
> I transfer data from a dataset to an XML...optional parameter query
I have a form with start date and end date parameters that the user
can input to run a query. I would like the query to be set up so that
null parameters means to ignore that constraint. That is to say:
if a is not null and b is not null
then c between a and b
else if a is not null and b is null
then c >= a
else if a is null and b is not null
then c <= b
else do nothing and move on
except using iif because if/then/else doesn't work in sql as far as i
What is the real code for "do nothing and move on?" I tried using
wildcards (else a = *), but it didn't work, pr...Drill down pivot table data via VBA macro
I am trying to create a macro that will drill down subtotals from a
pivot table. Since the number of rows, and colums, changes frequently I
need to reference the total for the row or column. Can this be done via
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=204538
Excel 2007 PivotTable
Show subtotal details via macro.
Define subtotal with PivotField...Update to Access Multiple tables via VBA
I'm somewhat familiar with updating from Excel to Access via VBA. How
can I update to multiple tables in Access that have a one to many
relationship using VBA. Table are linked via key.
tbl_One is one Many with tbl_Two via Foreign Key
tbl_One is one Many with tbl_Three via Foreign Key
Set db = OpenDatabase("C:\LinkedTest\LinkTestDB.mdb")
' open the database
Set rs = db.OpenRecordset("tbl_One", dbOpenTable)
..AddNew ' create a new record
' add values to each field in the record
.Fields(&...Loosing parameters via xml control
I have an xslt that accepts parameters. In my code I set these paramaters
and pass them to the xml control to transform and display the xml according
to the xslt.
When I throw the form directly into the response.write it shows my
paramaters just fine. Since I altered the code to use the Xml Control, these
parameters are not received by the Xslt upon transformation via the xml
Here is my code.
'*CTE00 - Throw the Document into a xml navigator.
NavApproveCondition = DocApproveCondition.CreateNaviga...ms crm startup sap document via .Net Connector
Has anyone used the SAP .Net Connector to show account details based on
the sap customer id ?
Any example or info is more than welcome
...Populating Excel from CSV
I need to know how to populate an Excel template with data from a
external CSV file. Let's say I have this nice pretty colourful templat
that is far more pleasing to the eye than the usual chunk of importe
CSV data, what are some methods to populate it with data from a CS
Any ideas or suggestions or redirections would be much appreciated.
Thanks in advance :
AJMorgan591's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2777
View this thread: http://www.ex...Dlookup in query
I have a query in which i want to use a dlookup which i have embedded in a
function. Strange thing is that the first record returns the correct value
and after that i get a invalid use of null.. ??
scenario (for testing purposes)
MyDate (set to date time)
MyAmount (set to currency - standard - two decimals)
Dummy (text field)
FutureDate (Set to date time)
Created a query with the two fields from table2
both fields added to the querygrid. Third field added as follows: Amount:
function GetPrice(FutureDate) as d...query LDAP
I'd like to make a worksheet with the following columns:
Username Full name Email
This data is somewhere inside our address book server, an LDAP server
I have Googled this but have not yet found interesting results.
Amedee Van Gasse using XanaNews 220.127.116.11
If it has an "X" in the name, it must be Linux?
How To Ask Questions The Smart Way
How to Report Bugs Effectively
Only ask questions with yes/no answers if you want "yes" or "no" a...Subform Linking via Code
I am trying to change the child/master links for a subform at the click of a
button. The reason for this is to switch between current and completed
projects in the subform. There is already a filter on the parent for which
proved too difficult to amend.
My problem occurs when I click on the button. I get a warning that tells me
that the master and child properties must contain the same number of fields.
Is there a way to bypass this warning so that the rest of my script can run?
Here is the code I have so far:
Private Sub Toggle_Current_Complete_Click()
Me.PMInterfaceSub.Li...how do populate empty cells with the contents of populated cells .
I have this worksheet problem. The work sheet is thousands of rows long. One
of my columns has cells not populated. I would like to get any empty cell in
this column to populate itself with the contents of the next populated cell
Kind of a "find and replace" action where by an empty cell says to it
self;"I'm going fill myself in with the next thing I find below me"
I would greatly appreciate if someone can relate how to do this.
Select the column, use Edit | Go To... Special , Blanks, OK. Then type an
equal sign, press the down arrow...Help : Using Parameters with External Date Query
For some reason, whenever I do an external data query, the Parameters
button/feture is ghosted and unavailable. Can someone explain why this might
...The kerberos client received a KRB_AP_ERR_MODIFIED error and Failed to query SPN registration on DC 'hostname_ho.domainname.local'
We have various branches connected to our main branch, but one of the
domain controller from one of the small branches is having issue and
is not replicating with DCs in the main office. It is also generating
the event ID #4:
"The kerberos client received a KRB_AP_ERR_MODIFIED error from the
server host/name_host.domainname.local. The target name used was host2/
name.host.domainname.local. This indicates that the password used to
encrypt the kerberos service ticket is different than that on the
target server. Commonly, this is due to identically named server
accounts in the tar...Autoplay for Pictures Not Populated
I inserted my XD card in to my card reader today and the autoplay pop up
window asking what I wanted Windows to do was blank. For Video, Music and
Mixed content the options are there but not for Pictures - it is just blank.
I have tried running autofix.exe but this has not fixed it. Any ideas? Is
this a Microsoft problem or has something else caused this? It worked fine
until today. Thanks.
> I inserted my XD card in to my card reader today and the autoplay
> pop up window asking what I wanted Windows to do was blank. For
> Video, Music and Mi...Query parent elements (newbe question)
I have a XML file where I want to query elements but id of the element is
buried deep inside child elements for example:
<PositionDescription>Some sample text here</PositionDescription>
...Microsoft Query in Excel
I am trying to set up some queries in excel that reference an access
database. Problem is that the location of the database and the name changes
based on what project I am working on. What I guess I want to do is set up a
query template and then change the location where those templates pull data
The database objects will not change when copied, only the database name and
Is this possible? Feel free to contact me with any questions. 518-464-1717
...City and State Populated by Zip Code
Does anyone know of a way to load a program that when you type in the
Zip Code the City and State are automatically populated?
I have seen a MSCRM add-in from a company called QAS (http://www.qas.com/).
This is more than just Zip Code/City&State. It's a full address validator along
with streamlined data entry. They have integrated with CRM via an ISV pop-up
and it seems to work fairly smoothly.
MVP - Microsoft CRM
On 15 Apr 2005 11:13:56 -0700, "Morgan" <firstname.lastname@example.org> wr...Pass cell data to Query
Anyone know how to pass the contents of a cell to an sql query? I have a
worksheet that I have connected to an SQL database that I want to query to
get data. The worksheet is like an invoice. What I want is the user to input
a product code and currency then the query to return the price. It sounds
simple enough to do with a nested function but the price list is made
complex by prices in different currencies so the level of nesting allowed is
insufficient. I thought a database query would be a more appropriate
solution but I can't find any information on how to do it in this way.
-...query with insert but how
I have two tables with this structure:
1) ID (Counter + primary
2) lfd_nr (integer)
3) Field1 (Text)
1) ID (Integer)
2) lfd_nr (integer)
3) Field1 (Text)
ID from the first and second table are in 1:n Relation
Now I would like to insert the records from the first table where lfd_nr=1
in the same
table with lfd_nr=2. Further I would like to insert the records from the
second table where lfd_nr=1 in the same table with lfd_nr=2 but so that the
in new records (lfd_nr=2) corresponds the ID-field in the first table where
...cannot add user into Active Directory via c#.net
My System Have 2 Computer:
Frist Computer act as A domain Controller that has a Active Directory,RADIUS
Server,DHCP and DNS
Second Computer act as A Web Server(join domain with a first computer already)
and use Microsoft Visual Studio Team System 2008
I create a website on a second computer to add user in active directory. I
have 3 file:
1.Default.aspx - Let user fill their privacy information
2.ViewRegisterdata.aspx - Let user confirm their information before it's
added to active directory. In this file,there is a Viewregisterdata.aspx.cs
which collect user information...Populating a field
I want to populate a description field based on a par number that is entered
in the field before it. In other owrds, you enter a part number and presto,
in the next field, the description is entered for you.
Can you help??
On Thu, 6 Dec 2007 08:48:01 -0800, Tom <Tom@discussions.microsoft.com> wrote:
>I want to populate a description field based on a par number that is entered
>in the field before it. In other owrds, you enter a part number and presto,
>in the next field, the description is entered for you.
>Can you help??
If yo...Web Query HELP!!!
I am using Excel 2003 Web Query. I have an ASPX web page that prints a
Database table, and when I enter the URL in the "Data->Import External
Data->Web Query" wizard, the Page displays correctly in the preview pane.
But, when I am done (hit import button), Excel tries to retrieve the data
but fails with the message:
"The Web query returned no data. To modify the query, click OK, click the
name of the external data range in the name box on the formula bar and then
click Edit Query on the External Data toolbar."
I have not been able to trace the problem.