Search results

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

I am not sure what the reference was for, but I just used the example from an old Northwind Database 3 or 4 years ago. I do have a form which opens subforms based on whether there are any records in the sub form using RecordsetClone and this works fine. Private Sub Form_Current() With Me![Club...

Many thanks for response. I have deleted the Macro and included the following code: Private Sub btnA_Click() On Error GoTo Err_btnA_Click Me.FilterOn = True DoCmd.ApplyFilter , "fieldName like 'A*'" Exit_btnA_Click: Exit Sub Err_btnA_Click: MsgBox Err.Description Resume...

Hi, I have been using the Alpha Buttons Macro in Access 2002 with no problems. I have now updated to Access 2007. The Macro still works, but when I click on a button I get an error message The object doesn't contain the Automation object 'RecordsetClone' How can I remove the error message...

LastNDay Many thanks for this post, and it 'nearly' achieves what I want. However, I need the previous Sunday only if the current day isn't Sunday. If the current day is Sunday I simply require Date(). If I use LastNDay(Date(),1) it works for all days except Sunday. Today is Sunday the 22nd...

Many thanks for your help. Yes, the answer was to run 2 queries for updating each table. A Delete Records Query and an Append Records Query rather than a Make Table Query. These queries run succesfully while the BE is open. Regards John