User Profile

Collapse

Profile Sidebar

Collapse
RAM022
RAM022
Last Activity: Jan 26 '16, 04:33 PM
Joined: Jan 6 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • RAM022
    replied to How to show percentage of records showing up on report from total on master table
    in Access
    Thank you JForbes, I did it, and is working perfectly. I had to change the field and add two Dcount functions because I couldnt figure out how to add multiple criteria in one Dcount.

    I truly appreciate all your help! Thanks, Let's see how long it takes me to come back with another issue lol.
    See more | Go to post

      Leave a comment:

    • RAM022
      replied to How to show percentage of records showing up on report from total on master table
      in Access
      I tried it but I don't think I undesrtand it perfectly.

      my table name is : 81st EDUCATION
      Primary Key is: Employe ID

      I already have the total amount of employess in my table on a query and that was I was trying to reference on the text boxexpression. So with the Dcount I don't need this anymore right?

      I tried using the Dcount like this:

      =DCount("Employ e ID","81ST...
      See more | Go to post

        Leave a comment:

      • RAM022
        replied to How to show percentage of records showing up on report from total on master table
        in Access
        I created a query that counts the number of records on my main table and added a Count(*) to the report.

        Then I added a text box on my form next to the button that opens the report and on the expression builder on "Control Source" I added:

        = [QUERY]![Column] - Reports![Nameof report]![Total] / [Query]![Column]

        I thought this would work, but it returns an #Name? error.

        Please help, thanks....
        See more | Go to post

          Leave a comment:

        • RAM022
          started a topic How to show percentage of records showing up on report from total on master table
          in Access

          How to show percentage of records showing up on report from total on master table

          Hello,

          I have a report from a query that lists the employees that do not meet certain standards. The source data is coming from an linked Excel spreadsheet.

          I want to show on the report or form the percentage of employees on that report in relationship with the total of employees on my main table, but I want to do it automatically so it adjusts itself when the numbers change.

          I know how to do something...
          See more | Go to post
          • RAM022
            replied to Open and Email Report from Combo Box
            in Access
            Thanks,

            I am using Access 2013. I got everything working right now on a pop up form from my main form. It looks like this:

            Code:
            Private Sub EmailReport_Click()
On Error GoTo EmailReport_Click_Err

DoCmd.SendObject acReport, Forms!ByDirectorates.ComboReports, "PDFFormat(*.pdf)", "", "", "", "", "", True, ""


EmailReport_Click_Exit:
            ...
            See more | Go to post

              Leave a comment:

            • RAM022
              replied to Open and Email Report from Combo Box
              in Access
              Thanks,

              My combo box is is getting the values with a query like HVSUMMER said.

              I managed to also get the button to open the report with an Onclick event:

              Code:
              Private Sub OpenReport_Click()
    DoCmd.OpenReport Forms!ByDirectorates.ComboReports, acViewReport
End Sub
              But when I try to create and additional button and write on the code bulder, it messes up the one tha I already have on the...
              See more | Go to post
              Last edited by zmbd; Jan 7 '16, 09:27 PM.

                Leave a comment:

              • RAM022
                started a topic Open and Email Report from Combo Box
                in Access

                Open and Email Report from Combo Box

                Hi,

                I have over 10 reports from queries that I want to open from a Combo Box. The combo box is working perfect with the name of the reports, I just need to create a button that opens and emails the selected report on the combo box.

                I appreciate any help. My experience with access is very limited. Thanks.
                See more | Go to post
                No activity results to display
                Show More
                Working...