User Profile

Collapse

Profile Sidebar

Collapse
AdrianGawrys
AdrianGawrys
Last Activity: May 6 '09, 10:25 AM
Joined: Nov 3 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • @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...
    See more | Go to post

    Leave a comment:


  • 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,...
    See more | Go to post

    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"/>
    ...
    See more | Go to post

  • AdrianGawrys
    replied to Subform requery problem
    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.
    See more | Go to post

    Leave a comment:


  • AdrianGawrys
    replied to Subform requery problem
    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....
    See more | Go to post

    Leave a comment:


  • AdrianGawrys
    replied to Subform requery problem
    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....
    See more | Go to post

    Leave a comment:


  • AdrianGawrys
    replied to Subform requery problem
    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...
    See more | Go to post

    Leave a comment:


  • AdrianGawrys
    replied to Subform requery problem
    Thanks but unfortuantely this doesn't help....
    See more | Go to post

    Leave a comment:


  • AdrianGawrys
    started a topic Subform requery problem

    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...
    See more | Go to post
    Last edited by Jim Doherty; Dec 2 '07, 03:09 PM. Reason: Code tags

  • AdrianGawrys
    replied to Weekday from Date problem
    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!
    See more | Go to post

    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.
    See more | Go to post

    Leave a comment:


  • AdrianGawrys
    started a topic Weekday from Date problem

    Weekday from Date problem

    Can someone tell me why this query works:
    Code:
    SELECT WeekdayName(Weekday(#17/02/2007#)-1) AS [Day]
    and this one doesnt
    Code:
    SELECT WeekdayName(Weekday(#18/02/2007#)-1) AS [Day]
    what I am trying to achieve is to get weekday from date obviously. a
    Appreciate any help
    See more | Go to post
No activity results to display
Show More
Working...