Search results

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?

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

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

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

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

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

Hello, How can I use 2 ++ on one line in a query? Thanks, Holly

Hello, I am trying to return records that are past due if not paid right away when the invoice terms are “Due Upon Receipt” below is the code I’m using. I keep getting an error saying you entered invalid syntax. Any ideas? PaymentStatus: IIf(Date()-[invoice date sent]>=1 And [tbl report and...

Below is the expressions broken down into 1 column each. CABIHours: IIf([work hours]![work code]=60,[hours]) CABIOTHours: [CABIHours]-8 TotalCABIRate: IIf([CABIHours]>8,(500+([CABIHours]-8)*93.75),[CABIHours]*62.5) ProjectManagerHours: IIf([work hours]![work code]=14,[hours])...

I need a query to calculate the following. CABIDayNormalRate: IIf([CABIDayHours]<=8,[ CABIDayHours]*62.5) CABIDayOTRate: IIf([CABIDayHours]>=8,[hours]*93.75) When I run the query. It’s only calculating if there is less that 8 hours. I need it to be able to take those 8 hours or less and...

Hello, I would like to be able to have an individual form that people could use as there time sheet. This form would need to be separate from everything in my database. I don’t want these employees to access to the rest of my database. Is this possible?

Hello, How do I save a report to PDF with VBA code? Name that File with a project number and the Report Name Then send it to a certain File Path? All with the click of a button. Any ideas? Regards, Holly

When I enter the vendor, then media type, then project expense TAT. It should give me the correct price when it has met all the criteria however it is not matching with the correct price for the entered criteria. Any thoughts? strsql = "SELECT * from [tbl sr lab rates] where [lab] ='" &...