Search results

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

Hi, So i have form with a combo box, but it doesn't show all options to select its hiding some of the works as the length is greater than the box size, anyway to get around this?

yes i am so please just now need to have it check against the Bank Holiday Table next big challenge ok so got this now working with this function code Public Function addDays(ByVal iDays As Integer, ByVal dteStart As Date) As Date Dim i As Integer Dim m As Integer m = Abs(iDays) While m > 0 If...