Search results

Thanks for you help.

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

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?

Perfect it worked!! Thank you!

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

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

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.

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...

Perfect! It Worked! Many Many Thanks!

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.

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...

Prefect thank you!

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...

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

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?

Hello Friends, I have a form that contains to fields that are combo boxes. I would like to spell check the fields when text is entered that is not on the set list. However I’m am getting the error below. The current selection does not contain any fields that can be checked for spelling errors. I...

Its fixed! Thank you very much for your help!

how about if I enter the payment terms? Does this make more sense? PaymentStatustest: IIf([tbl report and invoices sending]![payment terms]="Due Upon Receipt","Due Upon Receipt Past Due", IIf(Date()-[invoice date sent]>=365,"365 Days Past Due", IIf(Date()-[invoice date sent]>=180,"180 Days...

Hello, The query I have below. Is returning records with the Payment Terms for NET 30 are showing as “15-30 Days Past Due”. The NET 30 payment terms should show as “31-60 Days Past Due” and the NET 15 payment terms should show as “15-30 Days Past Due”. I hope I’m explaining myself? Any ideas...

It Worked perfectly! Thank you!