Recent content by johnsqftwr

Many thanks for all the help. Yes, the dates that were not working all worked in the US date format thus 06/10/11 was being interpreted as June 10th 2011. Changing stLinkCriteria = "[Date]= #" & Me![Date] & "#" to stLinkCriteria = "[Date]= #" & Format(Me![Date], "dd-mmm-yyyy") & "#" solved the...

The following works for 15/09/2011, 22/09/2011. 29/09/2011 It does not work for 06/10/2011 Both source tables are dates with the same format, but somehow it thinks that the 2 matching 06/10/2011 are different. I am tearing my hair out with this one and hopefully someone can let me have some...

Many thanks, Simple when you know how!

All, I have a form from which you can select the start date and end date to then open a report based on this criteria. The source of the report is: SELECT CallLogRef, CallDateTime, WarehouseNo, DCEmployee_No, First_Name, Last_Name, CallReason, ReasonDescription, CallLog FROM qryCallLogsUnion...

Sorry for late reply. Have been away. Many thanks for your help. Got there in the end.

Many thanks for your reply. When I open the form now all buttons are enabled. As soon as I start data entry, the New Record & Close Form buttons are disabled. I am not sure where to go now. I assume I need something in the OnCurrent event with the criteria? If IsNull(Me.CallReasonComents)...

I am totally lost here! I have the following in the Dirty Event of the FORM Private Sub Form_Dirty(Cancel As Integer) If IsNull(Me.CallReasonComments) Then Me.cmdNewRecord.Enabled = True Me.cmdClose.Enabled = False End If End Sub Could you help further? many thanks

Many thanks. I will give this a try

Hi All, I have a form with 2 Memo Fields. CallReasonComments and HowResolved. TheCallReasonComments must always be completed and the HowResolved must be filled in if the Resolved Check Box is ticked. I have searched the threads and the form before update event is as follows: Private Sub...

Many thanks for your help. So simple when you know how :)

Thanks for your prompt reply. I am OK with the hidden field but am struggling with the on click event. I have: Private Sub Resolved_Click() End Sub The field that needs updating is: tblIncomingCallLog.DateTimeResolved Many thanks

Hi All, I have a form logging problems and when the problem is resolved I have a check box which needs to be ticked. The form is bound to a table. When the check box is ticked I need a timestamp to be entered in the underlying table timestamp field. Any help greatly appreciated. Regards John

Hi All, I have a query which has 3 fields Employee No:Emp_No MonName: Which Has the employee's name if he is in on Monday or if not then the filed is blank. MonNum: This gives a value to the field ie If the employee is in then 1 if not then 0. If the same employee appears twice then I ONLY...

Hi, Yes, it is a row of labels but the text varies for each label. I neen the text to be aligned in the the centre. Many thanks for your reply John

Hi All, I Have a report which is outputting as labels and I need the text to be aligned centrally and vertically. Using the top and bottom margins is of no use as the text can be of variable length. John