I have a form that I am using to input data.
I also have a button on that form that opens another form.
Issues:
1. I maximize the Main Form. I want this maximized to increase the real estate (Space)of the form
2. When I click the button to open the second form it also opens maximized...
you also have to look at the XML output...based on the case of ITEM you might have to modify the above XSL file to replace the two occurances of
ITEM to item
OH I forgot....here is the XSL file that does the Transformation....
XSL FILE:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:geo="http://www.w3.org/2003/01/geo/wgs84_pos#"...
Freakin unbelievable....darn syntax again....
hey tsuji you think you are confused....I do thank you for your thoughts...I am very new to this and trying my best...
k5tm once again thank you very much....that was it...darn syntax..
I look back on this now and it seems to simple....but I did...
Yea I was reading that section...No real example...its hard when you are new at something and they dont show examples...
Am I correct to think that because it is not in the Export/Import Method that I have to run an Export, create the XML and then use the TransformXML Method?
1. I ran a basic...
This is what I am trying for the Automatic Export.
Private Sub Command2_Click()
Application.ExportXML _
ObjectType:=acExportTable, _
DataSource:="ITEM", _
PresentationTarget:="F:\TEMP\TemplateNew_WORKING_Test.xsl", _
DataTarget:="F:\TEMP\ExportsXML.xml"
End Sub
RESULTS...
I was confused because we just placed the namespace in the RSS section I didnt think it had to be repeated in the xml:stylesheet section.....
Sweet....Im up and running...now for the automated part of this...going to look at that link you put on above nad see if I can figure this out....for a...
Well I am getting there.....
I reference the field geolat (my latitude coordinate) and I am getting an error....I appolgize for my ignorance....
Error:
Reference to undeclared namespace prefix:'geo'
See Below
<geo:lat><xsl:value-of select="geolat"/></geo:lat>
geolat is the field name
I need...
ahhhhhhhhhhhhh I was so close...I was horsing around with the rss adfter you mentioned it. ALthough I was placing it near the <xsl:stylesheet and it was giving me errors.
Ok now...I saw that you repeated the encoding="UTF-8" twice. My Output 1 did not have this represented.
I then deleted...
Boy I tell you...now I am starting to confuse myself...ok one question at a time....
Didnt see the link "Process TGML"
1. I changed the Method to XML and the Version to 1.0 and I am getting a good output...this seems to fix the issue on the other entry about everythign being on the same line...
One more thing...I swear this will be it for a while....
I need to tag something
<geo:lat> </geo:lat>
But it seems to be bombing out on the : how do I get around this?
I have an XSL file that I am using to output to XML....
Thanks to the help from k5tm....
The below example creates tags <tr> and <td>
<tr>
<td><xsl:value-of select="Title"/></td>
<td><xsl:value-of select="Description"/></td>
</tr>
But I need my tags to read...
Damn Syntax again.....ONE last question....
Is there a way I can get this to appear at the begining of the Output XML....I just dont know how to tag it out so it appears exactly as I have shown below...
<?xml version="1.0" encoding="utf-8" ?>
<rss version="2.0"...
It seems the example I am trying to use is referencing HTML output not an XML output....I do not know why I am gettign an error on the apply_templates
This is very simplistic and if I can just get this to run I can modify it to include other fields....
Thanks again and I hope to hear from...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.