Search results

The problem is your WHERE statement. Month(Date())-1) is always going to return the number of the previous month, i.e., a number between 0 and 11. You would be better off using the DateDiff function.

Step 1: create a query that shows all pitches that are booked on the date specified Step 2: create a query that joins your master pitch list to Query1, looking for all items in the pitch list. Set the criteria for the pitch name in Query1 to "Is Null". (In other words, create an unmatched query)...

What is the purpose of the option buttons? How do they influence what report gets generated? Are there 28 separate reports, or just 7 reports that, say, get sorted 4 different ways?

If for any reason it is vital for you to reset your AutoNumbering, what you could try is deleting the AutoNumber field from your table, then reinserting it. The new field would be sequentially numbered. This is extremely dangerous, of course, if you have any other tables that refer to the ID...

To record the time the moment the user starts typing, use the On Key Down event. In order to make sure you're not overwriting the time every time a key is pressed, however, you first need to check to see if this is the first time something was entered. For example: IF isnull(myTextField) = True...

You absolutely can run an Append Query on a linked table. The problem you are experiencing stems from the fact that the RecordSet generated by your query is not updateable. This is usually caused by the way the joins between tables are set up. Can you change the Query Properties to read "Yes"...

Unchecking multiple records can be done easily by executing an Update Query. Unchecking check boxes on a form is easily done in code, along the lines of: Me.Check1=0 Me.Check2=0 Me.Check3=0 etc.