User Profile

Collapse

Profile Sidebar

Collapse
falcs
falcs
Last Activity: Aug 21 '13, 03:22 PM
Joined: Nov 14 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • falcs
    started a topic Create search URL when the website uses <select> function
    in HTML CSS

    Create search URL when the website uses <select> function

    I am using a search engine www.sciencedirect.com in part of my code. I want to search for keywords and find how many results there are.

    My code works fine, all I need is the URL to submit search queries, Initially I tested the code with the basic search function and got it to work, basically its just:

    http://www.sciencedirect.com/science?[inputname]=[value]

    I can't just use the URL of the results page, as you...
    See more | Go to post
    • falcs
      replied to No Current Record Error in Access 2010 while using a self join
      in Access
      Here is the whole code

      Code:
      SELECT People.ID, People.aacode, People.PERSNO, People.HRP, People.DVHsize, xMarSta.Marital, People.AgeCat,
[Marital] & " (" & [AgeCat] & ")" & [RAL2] & [RAge2] & [RAL3] & [RAge3] & [RAL4] & [RAge4] & [RAL5] & [RAge5] & [RAL6] & [RAge6] & [RAL7] & [RAge7] & [RAL8] & [RAge8] AS HsTyp, (SELECT Fam2.R01 FROM People AS Fam2
      ...
      See more | Go to post
      Last edited by NeoPa; Nov 18 '11, 06:29 PM. Reason: Never any need to quote the whole of the previous post

        Leave a comment:

      • falcs
        started a topic No Current Record Error in Access 2010 while using a self join
        in Access

        No Current Record Error in Access 2010 while using a self join

        I'm replacing a subquery with an self join to improve performance of my query.

        The old subquery was like this:
        Code:
        (Select FAge2.AgeCat FROM People AS FAge2 WHERE FAge2.aacode = People.aacode AND FAge2.PERSNO = 2) AS RAge2,
        The new self join is like this:
        Code:
        (SELECT [People].[AgeCat] FROM [People] INNER JOIN [People] AS P2 ON ([People].[aacode] = [P2].[aacode] AND [P2].[PERSNO] = 2)) AS RAge2,
        ...
        See more | Go to post
        • falcs
          replied to Left Join in a subquery not working in access 2010
          in Access
          Could you give an example please?
          See more | Go to post
          Last edited by NeoPa; Nov 16 '11, 01:43 AM. Reason: Removed redundent quote

            Leave a comment:

          • falcs
            started a topic Left Join in a subquery not working in access 2010
            in Access

            Left Join in a subquery not working in access 2010

            I have a table called people which has a row for each person. Their address is represented by aacode and their number in the house is PERSNO there are then fields which represent the relationships between people. e.g. PERSNO=1 relationship to PERSNO=2

            I want to produce a query which return a single row for each house which includes columns for each relationship between PERSNO=1 and the other residents, something like this.
            ...
            See more | Go to post
            No activity results to display
            Show More
            Working...