User Profile

Collapse

Profile Sidebar

Collapse
Joelle
Joelle
Last Activity: Apr 23 '08, 08:26 AM
Joined: Mar 11 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Joelle
    replied to How to reteive data of a primary key with duplicate value
    in Access
    Hi Piano,
    Sorry for getting back to uyou so late,i was out of town for a while.
    Thx again for your response ,i checked my tables and restructured my table.Thx for your help
    Joelle...
    See more | Go to post

      Leave a comment:

    • Joelle
      replied to How to reteive data of a primary key with duplicate value
      in Access
      Hi ,
      thanks for getting back to me.Here is the structure of my query from which i have generated a report

      [CODE=sql]SELECT Requirements.Re quirementId, Components.Comp onentTag, Products.Produc tTag, Releases.Releas eVersion, Statusses.Statu sTag, RequirementCate gories.Requirem entCategorySyno psis, RequirementCate gories.Requirem entCategoryL1, RequirementCate gories.Requirem entCategoryL2, RequirementCate gories.Requirem entCategoryL3,...
      See more | Go to post
      Last edited by Scott Price; Mar 31 '08, 01:28 PM. Reason: code tags

        Leave a comment:

      • Joelle
        replied to How to reteive data of a primary key with duplicate value
        in Access
        Hi PainoMan64,
        Thank you for your reply but my problem was not if i do not select something from the second or third listbox.
        May be i did not explain my problem well,In my database i have a tables named Requirements, Products.there is a many-to-many relation between those two which means that i have an intermediate table named ProductRequirem ents that show which requirement belongs to which product.i do also have a table named Obj...
        See more | Go to post

          Leave a comment:

        • Joelle
          started a topic How to reteive data of a primary key with duplicate value
          in Access

          How to reteive data of a primary key with duplicate value

          Hi all,i will strongly appreciate if someone could help me,to figure out how i can handel my problem.
          I have this report :" RequirementQuer y_Report" and i have a command button that opens this report according certain conditions.
          My report hodls all information regarding the requirements in my database such as the producs,status, and release version( this last three are listed in a listbox each)
          so whenever i select...
          See more | Go to post
          Last edited by Scott Price; Mar 31 '08, 01:27 PM. Reason: code tags
          • Joelle
            started a topic Filter a report
            in Access

            Filter a report

            Hi everyone,
            i am really stack!i need help
            I have this report:"Require mentObjects_Rep ort",i have also a multiselect listbox whicg contains a list of products.what i want to do is to filter the above report based on the products that i have selected.
            here is my code but it seems that my filter does not work properly and get the entire report back(Requiremen tObjects_Report )

            [CODE=vb]Private Sub GenerateReport_ Click()...
            See more | Go to post
            • Joelle
              replied to Really need help with VBA
              in Access
              Hi,
              I am facing a problem now and am not that familiar with vba couls some hel pem?
              i have a listbox named ProductList which contains all the products,and based on the selection i made i would like to have only the report of the product(s) i selected.the listbox is Multiselected
              The report that i have to filter is" RequirementObje cts_Report"
              here is the code i wrote but whenever i click the command button...
              See more | Go to post

                Leave a comment:

              No activity results to display
              Show More
              Working...