@Plater you have no idea how grateful I am for the link to examples you've sent.
I was never too good with XPath but that helped me to understand it.
Currently I've achieved what I wanted with two XPath queries - one for all book nodes that have 'ForceUpdate' attribute set to true and another query that selects all Book nodes whose Parent nodes have ForceUpdate set to true.
What I need to do now is just to combine them...
User Profile
Collapse
-
Thanks for your responses guys.
@vekipeki - I should have mentioned that I am able to select a node and test for attribute's value, but I am more interested in some sort of xpath statement that will get select all nodes that have a parent node with attribute ForceUpdate set to 'true' and store them into XmlNodeList variable.
@plater - would you be able to sketch statement in Javascript that does that?
Thanks,...Leave a comment:
-
Select XML Nodes by Parent attribute
Hi Guys,
I have an xml similar to this one:
...Code:<?xml version="1.0" encoding="UTF-8"?> <SystemUpdate ForceUpdate="false" > <A ForceUpdate="false"> <Book name="Black" /> <Book name="BlackRed" /> <Book name="Red" /> <Book name="Green" ForceUpdate="true"/> -
Sorry for wasting your time but I manage to find a solution to my problem - I just removed the line where I execute PopulateListBox es() function after creating new record and put it under AfterInsert() Sub of the form. That seem to fixed my problem - for some reason running my function right after creating new record didnt allow me to address subform's controls - like they haven't been created yet. Now everything seems to be ok.Leave a comment:
-
No it's not a problem actually - Calendar is not bound to rDate so if you open form with rota I need Calendar to show what day is the rota for. It's under Form_Current because before I had "move to next" and "move to previous" record selectors so also needed to show what date is the rota for....Leave a comment:
-
Thanks a bunch, I feel like I am slowly moving in a good direction but the problem is that Me.NewRecord is set to 0 at this point for some reason. @puppydogbuddy would you be interested in looking into the database file itself? I can share them somewhere on public location and send you link if you are interested....Leave a comment:
-
Like I wrote in my first post - Error message is
"You entered an expression that has an invalid reference to the property Form/Report." and it comes up under line 9 of PopulateListsBo xes() function but only when condition from line 14 (If rs!Rcount >= 1 Then) of "Private Sub Calendar1_Click ()" is False - meaning: there is no rota in tblRotas with date (rDate) specified by user (value of Calendar1) if condition from...Leave a comment:
-
-
Subform requery problem
Hi guys,
I recently rewrote onClick procedure for Calendar on my form (frmRota). It opens record from tblRotas where field rDate is equal the one selected on Calendar. If such a record doesnt exist I want it to be created. Before only way to create new record was to click on NewRecord button that I created using Access2003 button wizard. Calendar is not bound to any field in recordsource but on this form I have text box rDate that is bound... -
Thanks guys!! You're awesome - both resolutions sound fine. As you said - my fault of trying to change begining of the week by (-1). Thanks again!Leave a comment:
-
U can install CutePDF client on his machine and set it as default printer, when user tries to print this report CutePDF will popup asking where to save .pdf document.
Hope this helps.Leave a comment:
-
Weekday from Date problem
Can someone tell me why this query works:
and this one doesntCode:SELECT WeekdayName(Weekday(#17/02/2007#)-1) AS [Day]
what I am trying to achieve is to get weekday from date obviously. aCode:SELECT WeekdayName(Weekday(#18/02/2007#)-1) AS [Day]
Appreciate any help
No activity results to display
Show More
Leave a comment: