Search results

How would I go about this without asking from the user the month end date. I would like the command button to automatically show the items that end at the end of the current month. What sort of code am I looking at? Cheers

Hello, How would I go about in making a command button bring up a report to show a result of items for the end of the month? For example, when a user clicks on this button it will bring up a report showing all the items that are out of date for the end of the month. I am having problems with the...

Cheers Cheers. It appears that is the line I wanted and all seems to be working. John.

Yes it is the last day of the month

Does anyone know how to do a query so that the user can find all the things that will expiry at the end of the current month? The user will click on a command button and it will show the results of a product that will expiry at the end of a current month. Have tried with parameters to which the...

Cheers Cheers for that, ill have to try it out

I wonder if you can help. I am trying to make a combo box with peoples ID numbers in which links to a table with that persons details. I have made the combo box with the names in but now trying to link the table to it. For example: Fred is in the combo box with ID number 1 and the user selects...

Hello. Can someone please describe what an Automatic Counter is on a form? How do you set one up or input one on? Cheers :confused: