Search results

Hi there, I would create the crosstab query and then call it in a new, make-table query, just add the fields as if you were creating the make-table from any other table or query. Then if you wanted it to update you just have to have your code or macro run the make-table and any other queries...

Hello All, I've just re-read my post and I've missed out a vital piece of information: When the user has selected the relevant dates from the calendar control I am attempting to write the information to a table using an append query with [FORMS]![frmUpdate]![FieldName] syntax. This works for...

Hi RuralGuy, Thanks for the response: The reason for the line: Set cmbOriginator = cmbStartDate is that I am using the same calendar to choose dates for both cmbStartDate and cmbEndDate. Therefore, cmbOriginator is a variable. Also the reason I choose combo boxes rather than text boxes was...

Hi All, I'm in the process of creating a database that allows users to enter details into a form which includes a date range as start and end dates. I have used the inbuilt Calendar Control 10.0 control to allow users to select the date. It is linked to two combo boxes [cmbStartDate] and...