Recent content by girky

I figured this out for future reference: I store the current position in a variable then just to that position on the above node <xsl:variable name="position_number" select="count(preceding-sibling::*) + 1"/> <xsl:value-of select="../../../ColumnNames/ColumnName[$position_number]"/>

Hello, I'm trying to loop through values in an above node to get the "columnname" and can't seem to get the syntax correct. Any help is appreciated! XML: <Data> <Check> <DetailedData> <ColumnNames> <ColumnName>UserName</ColumnName>...

Hello! I currently am able to send a lotus notes email from access. Now I need to add hotspot buttons in the body of the email that polls the recipent for various responses and emails out their response. Can anyone help with this? I need a button to use this but don't know how in VBA...

That's what I need! And i also found this article about how to transform within Access "You cannot import attribute-centric XML in Access" > http://support.microsoft.com/kb/285329 I'm on my way! Thank you so much tsuji!

OK, so when I put that line in I get the output I want when I open the xml file itself, but Access gives me an error if I try to import that xml "A text/xml declaration may occur only at the very beginning of input". So I think I still need to generate a txt file or html file that i could...

So I'm a bit confused and obviously this is my first attempt at xsl. I have an xml file that I need to import into MS Access daily. I've created an xsl file to transform it into the format I need. How do I automate the xsl transformation to create my file so I can have it for my Access import...

Hello, I'm having a problem with the syntax of a subquery. This is what I have: SELECT tblErrorDetail.ID FROM tblErrorDetail WHERE tblErrorDetail.[Reason Code] In (select [tblReasonCodes].[Reason Code] from tblReasonCodes where [BA]= "P"); I'm getting a type mismatch error. Reasoncode is a...

Hello, After working on this for a while I actually found another way to do it: For i = 0 To (remoterec.Fields.Count - 1) localtable.Fields.Append localtable.CreateField(remoterec.Fields(i).Name, remoterec.Fields(i).Type, remoterec.Fields(i).Size) Next i...

Hello, I'm looking to create a table dynamically from a recordset that I created. For example, I have a select query from an external database and have the results in a recordset object. For my project, the fields of this recordset are different based on the different datasources that I am...

Hello, I have 2 tables that I need to link based on dates and I'm not sure the most efficient way to do it. One table is contains: Table1 Type Dateofoccurance 1 1/2/06 4 3/8/06 1 6/9/06 the other contains rates for each type and an effective date: Table2 Type Rate...

Yes, I did. That fixed my problem. Thanks so much lbass!

Hello, I'm having trouble creating a new group in crystal. Currently I have a report that displays billing data and is sorted employee, project, date. Then it displays a total for each employee. There are multiple detail lines per day that i suppress and display totaled in group footer for each...

Hello, I have a pdf made in Professional 7.0 that was enabled for commenting in reader. In Reader 7.0 notes and comments were added. When you try to print "document and markups" in reader all you see is text edits, but not the notes that go with it. When this file is opened in Professional 7.0...

I'm new to crystal so I hope this makes sense and someone can point me in the right direction, b/c i dont know where to begin. I hope it's a simple solution. I have a report that groups phases of a job and displays their totals: GH1 Phase Name : Shows Phase Name (alphanumeric field, not in...

Awesome, that worked. Thanks so much for your help!!