Search results

Thanks Rich, but its not the selection of the date I'm concerned about, its passing a year or month to to a query. Cheers

I am trying to code a generic query that will use a year provided by the user on a combo box. The user will select a year (I hope to do this for months as well) then the query will run using the between function. My problem is supplying the dates for the 'Between' statement. Here is one of my...

can anyone help with this? Thanks in advance

The text editor doesn't always remove character when using backspace. Is this problem local to me or a 'feature' of Access 2000.

I thought it would be more user friendly, but didn't realise how programmer (novice) unfriendly it would be. Sorry, one more thing; what event should I add this code to, so that the dates are updated once all fields in the form are complete and accepted? [This message has been edited by nigelh...

Thanks Travis. My main problem is writng the dates to the table, as the date combo boxes are not bound. This is the code I am working on at the moment. Private Sub Form_Close() Dim dbsCurrent As DAO.Database Dim rstDate As DAO.Recordset Set dbsCurrent = CurrentDb() Set rstDate =...

I have a table which requires start date and end date. The feeder form has combo boxes for Start Date i.e day month year and the same for End Date. How do I concatenate the dates and transfer them to the table & ensure the end date is later than the start date. ACCESS 2000 [This message has...