Search results

so yes as its overtime hours available for future 10 days post today, dont want to show anything before 10 days, dont think its possible anyways

:(

So i am wondering if you can hide a field in a form if the title which is a date if its not 10 days from today field title = a date in the future with a count of available hours like 10/03/2022 14.5 11/03/2022 22.5 so i now need to hide 10/03/2022? as its 11 days from now?

thanks i had already setup a table and it all works fine :) "I have all then dates in a table called "BankHolidays""

thanks this all worked and i have tested :)

So i have this code that creates a date 12 working days from today, but i now need for it to check if the date its offering as a Bank Holiday and if so move to the next weking day. Public Function addDays(ByVal iDays As Integer, ByVal dteStart As Date) As Date Dim i As Integer Dim m As Integer...

Thanks changing this to < [Forms]![Requests].[Date] worked

So i need to have a query being back all records added before a date on a form. Tried this but didnt work <[Requests].[Date] get a prompt

So i need to add this to any numbers that are only 5 string long CorrectNumber:"2000" & [InvoiceNo] but i only want to correct if the current number is less than 6 ? how would i go about this please

did the job thanks :)

Is it possible to have on a form something that will prompt the user entering if the number of characters within a field is less than 10, is so then pop a message to say

this did the job Left([ACTION],2)

Hi, I need to trim all expect the numbers 03: SET ACTION 04: SET CALL BACK 05: CLOSE just need 03 04 05 any ideas please

what's the best way to say if two fields in query match [ID]=[SID],Yes,No ?

So i have created a query and Max on the Record ID - this query stand alone works fine. I have another query that i then bring in the above query but its not giving me the latest record Query1: ID CustomerID Install Date EngineerNo Query2: Customer ID CustomerOrderNo CustomerInstallDate...

yep thats sorted it cheers

I am getting this error when exporting the Query to excel I have changed this: New Order Live: IIf([22].[Serial]=[New_Order]=True,"Yes","No") Results are Yes or No to New Order Live: IIf([22].[Serial]=[New_Order]=True,Yes,No) Results are 0 or -1 Which has now stopped the error, but i...

Thank you that did the job :)

nope

doesn't seem to work getting syntax error on CDate