Search results

Solved :rolleyes: Sorry for such a simple error. Thank you for replies :)(y) ' Check Skilled Labour Combo box If (ChkSkill = True) Then If IsNull(Me.CboSkill) Then txtmessage = "Skilled Labour has been chosen for this Job, Please Select Type of labour" & vbCrLf &...

Thank you, Tried that and still error.

yes it is

Hello, I've had a look thru some of the forums, but nothing to match my current error if I could get some advice please. I have a check box and then a combo box. On form close I go thru some checks to ensure certain fields are filled out correctly. This particular one is given me grief...

ok cool, thank you. working! I've done similar code on previous stuff that hasn't got your additional code. Can you please educate me in what this does? :) 'arnelgp If Len(txtmessage) Then MsgBox txtmessage, vbInformation + vbOKOnly, "Scheduling" End If

hmm ok sort of working. when I delete the date I get my message box and the field is highlighted. all good. But then I get this: when shed mins is 0 or empty i get my message box. all good. and then ticks get done there after. not sure what the additional message box is?

sure.. Private Sub LblScheduled_Click() Dim txtmessage As String txtmessage = "" If Len(Nz(Me.TxtCustomerPreferredDate)) = 0 Then ' Check for Delivery Date txtmessage = MsgBox("Please enter Delivery Date." & vbCrLf & txtmessage)...

Im a knob, thanks. ok the back and forecolors working. not getting my text message when empty or 0

G'day mate, I adjusted the code to Private Sub LblScheduled_Click() Dim txtmessage As String txtmessage = "" If Len(Nz(Me.TxtCustomerPreferredDate)) = 0 Then ' Check for Delivery Date txtmessage = MsgBox("Please enter Delivery Date." & vbCrLf & txtmessage)...

Yes the colours etc are fine. I dont think its picking up the 0 maybe? If I comment out the TxtSchedMins of the code everything moves forward and functions. also even if i put a number in there, still no action.

Hello, Not sure why this is not functioning correctly. I have a check box, LblScheduled_Click(), when I click it (True) then it checks 2 conditions before moving on to the next piece of code. The first one works no problem, the second one elseif, is not producing the txtmessage, not...

Cheers Mate.

That'll do :) Thanks Mate

nope. i have to click into calculated fields to get numbers

Unfortunately that's not working for me. i have to click out of the date field and alot of the time have to click in the calculated fields for the numbers to appear. The calculated fields I will be making not enabled/locked. Users wont understand or get the wrong figures when changing date.

Ok, cool. Looks like it is working :) Thank you so much. What's the best way to make this refresh? Form event? or an event on TxtDateFilter Im Finding i select the date. tab out (Not what i want to do) but have to click back in date field to make numbers work.

So I don't use a query? go straight to the Table?

in the sample database the fields are blank. in my database the field is error.

Ok, Ill Try that, thanks.