Search results

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

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

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

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

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

I have a Front End Database and a Back End Database. Certain tables in the BE are linked to the FE. Once or twice a day I need to run Make Table Queries in the FE, but I am unable to do so if someone else has the BE open. Best solution would be greatly appreciated Many thanks John

All, I have 7 unbound calculated fields in the footer section of a subform. [Text1], [Text2] etc. Does a VBA guru have a bespoke function which will calculate the maximum of these fields in the same subform? Any help greatly appreciated. John

Hi, I need a report that produces what skills are available to a department each week. As can be seen from the attached file for W/C 5/09 there are 3 people all with the skills, Counter Bal, Problem Pal & Reach Truck. The Field Min_No denotes the number of staff required for that skill and...