Search results

doesn't seem to work getting syntax error on CDate

Hello, I need to change the formatting of this strange date layout to standard uk date 2021-11-24T01:00:00.000Z 2021-12-13T11:18:10.684Z

Yeah i think you are correct will create a query with Max just to show last entry Thanks always :)

So we have a table that gets updated every day with the last events. like a log on the processing of any order The field that gets updated is called [Order_Status] and the date gets updated within the [ImportingDate] - what i need to do is once completed delete (or archive) all earlier records...

sorted it using this... Dim strSQL As String Dim ctl As Variant If IsNull(Me.TelephoneNo) Then Dialog.Box "Please enter a Customer Telephone Number!", vbCritical, "Data entry error..." Me.TelephoneNo.BorderColor = vbRed Me.TelephoneNo.SetFocus Exit Sub Else

Thanks no we always have a telephone number so how would i get this setup

Love to hear about the best way to prompt the user when they leave a field black Message - Please Complete Customers Telephone Number! - This cant be leave blank!

thanks this worked i had to rebuild the database and its all working now thanks so much for all your help =IIF([BOOKED]="yes" OR [DELIVERED]="yes" OR [OUTSTANDING]="yes","Yes","")

Ill export it into excel and use my original formula thanks anyway

yeah i have =IIF([BOOKED]="yes" OR [DELIVERED]="yes" OR [OUTSTANDING]="yes","Yes","")

STILL DOES NOT WORK

changed to -1 still doent work

no its not working see... yes for those with a yes i can also seeing the same when all 3 are the no BOOKED DELIVERED OUTSTANDING Expr1 No No No -1

yes for those with a yes i can also seeing the same when all 3 are the no BOOKED DELIVERED OUTSTANDING Expr1 No No No -1

No does not work as i said in my first post?

No this does not work Test BOOKED DELIVERED OUTSTANDING Results No No Yes -1 No Yes No -1 same result even when a yes is present :)

so the form has a combo field that users can select 5 differnt templates all they need to do is add after -Contact Tel the customers details i want some to prompt if nothing has been added ?

how would i add this to the form please after update?

so i am looking for a way to check if the user has added the tel to a template they can select as ending xxxxxx -Contact Tel- if nothing added after this say a message?

So i need to build a query to show any records within the field called MTest that begins with a space (data enter error) I have this to fix it UPDATE DataRequests SET DataRequests.MTest = Trim([MTest]); but this runs on the complete table and is now slow, so need to set the criteria just to...