User Profile

Collapse

Profile Sidebar

Collapse
beginneraccess
beginneraccess
Last Activity: Mar 13 '19, 02:05 PM
Joined: Feb 5 '19
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • beginneraccess
    replied to Efficient way to compare data in 3 tables and only show the discrepancy
    in Access
    I think I got it!
    Code:
    SELECT tbMaster.EmployeeID, tbMaster.Amount, tbMaster.DatePaid, tbMaster.[Advance/paid], tbMaster.CID
FROM (tbMaster LEFT JOIN tbCID ON (tbMaster.DatePaid = tbCID.DatePaid) AND (tbMaster.Amount = tbCID.Amount) AND (tbMaster.CID = tbCID.CID)) LEFT JOIN table3 ON (tbMaster.CID = table3.CID) AND (tbMaster.DatePaid = table3.DatePaid) AND (tbMaster.Amount = table3.Amount)
WHERE (((tbMaster.[Advance/paid])="Paid
    ...
    See more | Go to post

      Leave a comment:

    • beginneraccess
      replied to Efficient way to compare data in 3 tables and only show the discrepancy
      in Access
      Hi twinnyfo
      I am just someone who makes the frame and am told what to try to make it do. The tables are one for before they pay, when they pay, and a table of receipts to check if what they say they will pay/have paid is what the receipt says? if that makes sense. Yes we are hoping that the data should be the same but I guess there were instances where someone fat fingered an extra digit and got paid extra.
      See more | Go to post

        Leave a comment:

      • beginneraccess
        replied to Efficient way to compare data in 3 tables and only show the discrepancy
        in Access
        Thank you for your response twinnyfo. I agree I would rather just handle one table. Unfortunately I do not control the tables being added and was informed they wanted to triple check the amount, date, and ID so have three tables where they will ask the employees to fill 3x...
        I guess I can append query all three tables into one table then do an unmatch query?
        See more | Go to post

          Leave a comment:

        • beginneraccess
          started a topic Efficient way to compare data in 3 tables and only show the discrepancy
          in Access

          Efficient way to compare data in 3 tables and only show the discrepancy

          Is there a way to triple check that the data is consistent between the three tables and show if there are any discrepancies in any of the three tables? Each table is not completely the same but they all have an EmployeeID, amount, datepaid, and CID column. When I did with two tables I thought I had the SQL as:

          Code:
          SELECT tbMaster.EmployeeID, tbMaster.Amount, tbMaster.DatePaid, tbMaster.CID
FROM tbMaster LEFT JOIN tbCID ON (tbMaster.CID
          ...
          See more | Go to post
          • beginneraccess
            started a topic cascading combo box not in use disappear-Nevermind
            in Access

            cascading combo box not in use disappear-Nevermind

            Couldn't find a way to make cascading combo box to disappear/cascading combo box not in use disappear... but now found the answer...
            Code:
            If DCount("1", "queTask1") = 0 Then '[Forms]![Assistance Menu]![Task] & cboTask.Value = " "
    Me.cboTask.Visible = False
Else
    Me.cboTask.Visible = True

End If
            See more | Go to post
            • beginneraccess
              replied to Can a button check password and filter?
              in Access
              Thank you for your quick reply!

              Ok I will look further into User-specific productivity. I may have questions in a bit, but I will try my best to understand!
              See more | Go to post

                Leave a comment:

              • beginneraccess
                replied to Can a button check password and filter?
                in Access
                Dear twinnyfo,

                Thank you for the compliment! I actually have been taking bits of other people's code and putting them together

                Do you think it will be ok to have a separate database that holds just the comments for the employees separately? I was planning to have the tables perhaps linked to another database in which they would need access to. That way they cannot look up other people's password and can only see their...
                See more | Go to post

                  Leave a comment:

                • beginneraccess
                  started a topic Can a button check password and filter?
                  in Access

                  Can a button check password and filter?

                  Sorry to bother you all again...
                  I am trying to create a login page where upon inputting the correct UserName AND password, it would filter a subform below so that they could see only their comments. Is this possible? I have it so that there are two buttons where one checks the Username and Password via VBA code and another button filters using a Macro... But I would like for one button to do everything so that if the password is incorrect,...
                  See more | Go to post
                  • beginneraccess
                    replied to How to separate PDFs in one report
                    in Access
                    Thanks Twinnyfo

                    Code:
                    Private Sub cmdprintsep_Click()
    Dim rs As DAO.Recordset
    Dim myPDF, myStmt As String
    Dim gstrReportFilter As String

    myStmt = "SELECT distinct EmployeeID from queBalance"
    Set rs = CurrentDb.OpenRecordset(myStmt)
    gstrReportFilter = ""
    Do While Not rs.EOF
        myPDF = "C:\Users\user\Desktop\reports\"
                    ...
                    See more | Go to post

                      Leave a comment:

                    • beginneraccess
                      replied to How to separate PDFs in one report
                      in Access
                      Thanks twinnyfo for the info. I tried putting a filter into the query itself by putting
                      Code:
                      fGetID()
                      into the criteria, then making it a public function in a separate module. Then calling upon fGetID to equal EmployeeID. When that failed, I have tried to put a filter called strFilter upon opening the public sub report_load then adding the code you gave in above to my code. And now I'm totally confused... Are either methods I used what you are referring...
                      See more | Go to post

                        Leave a comment:

                      • beginneraccess
                        started a topic How to separate PDFs in one report
                        in Access

                        How to separate PDFs in one report

                        Hi after my last question I am trying to separate PDFs in one report based on their Employee ID and have them saved to a folder and named based on their EmployeeID. I have made a query to make a report
                        I have two codes that I am trying but both keep coming back with an error. This one at
                        Code:
                        DoCmd.OpenReport "Balance", acViewPreview, , "EmployeeID = " & myrs.Fields("EmployeeID").Value
                        comes back with the error...
                        See more | Go to post
                        • beginneraccess
                          replied to Outlook vba connected to Access Error-help
                          in Access
                          Thanks twinnyfo!
                          I have looked into two issues of downloading ClickYes app or just doing a mailmerge :)
                          See more | Go to post

                            Leave a comment:

                          • beginneraccess
                            replied to Outlook vba connected to Access Error-help
                            in Access
                            Thanks twinnyfo!
                            I was hoping the code in Outlook would be a work around... Do you think the "Compile error: Variable not defined" in Outlook is due to IT as well?
                            See more | Go to post

                              Leave a comment:

                            • beginneraccess
                              started a topic Outlook vba connected to Access Error-help
                              in Access

                              Outlook vba connected to Access Error-help

                              In my last question (https://bytes.com/topic/access/answers/972172-split-ms-access-reports-into-separate-emails) I wanted to make separated reports from one big report and have them sent matching the EmployeeIDs and Emails... However after every email I get a message from Microsoft Outlook:
                              "A program is trying to send an e-mail message on your behalf. If this is unexpected, click Deny and verify your antivirus is up-to-date...."...
                              See more | Go to post
                              • beginneraccess
                                replied to Split MS-Access reports into separate emails
                                in Access
                                twinnyfo

                                Thanks for the reply! Someone informed me to change

                                Code:
                                DoCmd.Close acReport, "test", acSaveNo.
                                and
                                Code:
                                EditMessage:=False
                                And it works! Yay!

                                Thank you for your time.
                                See more | Go to post

                                  Leave a comment:

                                • beginneraccess
                                  replied to Split MS-Access reports into separate emails
                                  in Access
                                  Thanks Phil

                                  Unfortunately EmployeeID is a text
                                  See more | Go to post

                                    Leave a comment:

                                  • beginneraccess
                                    started a topic Split MS-Access reports into separate emails
                                    in Access

                                    Split MS-Access reports into separate emails

                                    Hi,

                                    I am trying to send separate Employees a PDF of their section/page of their report. The information is based on their EmployeeID. So each person has their balance information on a page then there's a page break, and then next page shows the next person's details. With the code below, it does email each of the employees one page but it so happens to only email the first person's page to EVERYONE. Is it possible to somehow automate...
                                    See more | Go to post
                                    • beginneraccess
                                      replied to How to add multiple records to a table via a form?
                                      in Access
                                      Nevermind it WORKS! Thank you all! Sorry of all the questions
                                      See more | Go to post

                                        Leave a comment:

                                      • beginneraccess
                                        replied to How to add multiple records to a table via a form?
                                        in Access
                                        Hi Phil
                                        Thanks for the catch! So it keeps making errors... Even if I add all the [] and . and correct the code to what I see on SQL from queries... the error states that "The specified field 'EmployeeID' could not refer to more than one table listed in the FROM clause of your SQL statement." So I have tried to add table name in front of every variable but to no avail.

                                        Code:
                                        Option Compare Database
Option Explicit
                                        ...
                                        See more | Go to post

                                          Leave a comment:

                                        • beginneraccess
                                          replied to How to add multiple records to a table via a form?
                                          in Access
                                          O whoops Thank you.

                                          It still appears as "JOIN expression not supported"
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...