Recent content by all7holly

  1. A

    Straight time and overtime question

    Thanks for you help.
  2. A

    Straight time and overtime question

    If an employee has the following. .5-hour lunch 45.16-hours Worked hours minus lunch=44.66 StraightTime should be 40 OverTime should be 4.66
  3. A

    Straight time and overtime question

    Hello, I would like to calculate straight time and overtime in a query. The names of the fields are “Hours” and “LunchAndUnPaidTimeOff”. Any ideas how I can show if a person has worked 40 hours or under and how many overtime hours after the 40 worked hours?
  4. A

    Export to PDF Question

    Perfect it worked!! Thank you!
  5. A

    Export to PDF Question

    It is an existing folder. The file just needs to be sent to that existing folder.
  6. A

    Export to PDF Question

    The file path is below. C:\Users\hmartinez\Desktop\Katie Weekly Sent Invoices
  7. A

    Export to PDF Question

    I is creating a folder inside the folder that already exists. I want it to just send the file to the existing folder on my desktop.
  8. A

    Export to PDF Question

    Below is VBA I have used to create a folder, convert the file into PDF and name it. I would like to know what lines I need to remove to not create the floder, because I want to send it to a folder that already exists. Private Sub SendToKatieFolder_Click() Call...
  9. A

    Text Box Doesn’t Disappear When Creating PDF

    Perfect! It Worked! Many Many Thanks!
  10. A

    Text Box Doesn’t Disappear When Creating PDF

    Hello, I make it disappear with code when there is no data. When I open the report in normal view it works properly, however the code I listed above doesn’t open the report. It just converts it to a PDF and sends it to a folder.
  11. A

    Text Box Doesn’t Disappear When Creating PDF

    I now have a text box that disappears on normal view of the report. However the code below converts the report to a PDF. When I review the PDF the text box is there. Any ideas? Public Sub ExportPDFINVOICE(strRoot As String, strPropertyAddress As String, strprojectnumber As String...
  12. A

    Hide Text Box On A Report

    Prefect thank you!
  13. A

    Print 2 copies from non default printer

    The code below is still only printing 1 copy to the default printer. Any ideas? DoCmd.OpenReport "rptworkauth", acViewDesign, Null, Null, acHidden Dim oRpt As Report Set oRpt = Reports(0) oRpt.Printer = Application.Printers("Savin C3333 PCL Color") With oRpt.Printer .Copies = 2...
  14. A

    Hide Text Box On A Report

    I have already set it to shrink. I need to have the label (BillingWeeksLable) show when there is data.
  15. A

    Hide Text Box On A Report

    Hello, How do I hide a single text box on a report if there is no data? The label is called “LableBillingWeeks” and the control source is called “BillingWeeks”. Any thoughts?
See more
Back
Top Bottom