Search results

Im trying to create a customer details form that will take two user inputted dates (txtbookingstart and txtbookingend) and a room no. Then on the click event, edit the customerid field in the appropriate records in a different table "booking". Here is my code so far: Private Sub...

Ha! I've entered the between expression right, and assigned data types to the dates. This has eliminated the cannot bind message. Now, I receive the message "cannot evaluate expression" the date field, being the column header has the criteria: between [enter start date] and [enter end date]...

More problems! I have created the crosstab query. However, should I base it on the table or the query? The query requests a date period (start and end date) and brings up the records for that date. When I run the crosstab query, it cannot "bind name startdate ". Does this mean its not...

Sorry, but im struggling! How exactly do I make a crosstab query/report? The purpose of the command button would be to book a room, i.e. enter a booking id.

I am trying to display a calendar type form, cross referenced with room numbers (for the hotel where I work). I have got the table with a date field and roomNo being a composite key. I need the date along the top and roomNo down the side, and a booking ID field displayed in the intersecting...

Rich, You're a star! The date increment works ok. I was just making up the code from other fragments. Thanks for the help!!!

I am trying to create some code that, when command button clicked, records created in an existing table. I have two text boxes, startdate and enddate. In the table there are two fields, date and roomno. I want the code to enter a record for every date between the two text boxes, and for each...