Ken Sheridan's latest activity
-
Ken Sheridan replied to the thread Solved Sorting with DISTINCT.You might find the attached little demo file useful. Note that where data is in a tree structured hierarchy, only the lowest level in... -
Ken Sheridan replied to the thread Multi-Column Value List Combo box issue?.It looks to me like you might be assigning a date of the first of the month to the column, but returning it in the control formatted as...
-
Ken Sheridan replied to the thread Speed Up Query.I don't think that will work. Firstly you need tables to model the principal entity types. In broad outline: Employees ....EmployeeID...
-
-
Ken Sheridan replied to the thread Solved Form Record Cloning In MS Access.If by that you mean that you want to number the rows in the subform as an unbroken sequence regardless of the insertion to or deletion...
-
Ken Sheridan replied to the thread Speed Up Query.Further to Minty's post in which they suggested a simple model in which the many to many relationship is modelled by a third table which...
-
Ken Sheridan replied to the thread Open a form and insert data SQL.Rather than setting the Value property of each control, which is the default property, so is usually omitted, I would suggest that you...
