Getting closer to the results that I am looking for.
My date format is 9/04/2000.
The code that I am using is sort of working, however when I input 4/18 as start and 5/1 as end date. The problem is that it returns hire dates of 4/13, 4/5,... not 4/20, 4.25,.. like I was expecting it to do...
You suggestion gives the results that I am looking for, however is there a way that I can just enter in the two dates, the begining and end dates ( i.e. 9/25 and 10/8).
That way there would be 4 boxes that have to have number entered into them.
This is what I have got going on so far...
Have a table with all of the employees in it with their hire dates. What I need to be able to do is query out any who was hired between 9/15 and 9/29, do not care what year they were hired in.
Tried using "Between [First Date] and [Second Date]"
This does not give me the resultes...
Have a search results form that is setup as a continuous form, when user double click on the case number it is to open a case review form for them to the set that they had select from the continuous form.
Problem is that I can get the form to open, however when applying the filter I get an...
Have two forms each of which are based upon their own tables and are linked by a case number that is the primary key in the case table and a foreign key in the hearing table. Button on the case form that opens the hearing and let the user enter in the information that is needed for the hearing...
Have a report that is based on a query, use a form with an option group to determine what information is needed to be reported. Using filters to restrict the information that is displayed on the report.
What I want to do is have a message box pop up on the screen and tell the user that there...
Is it possible to print out contents of a group? Tried a few different things and all I been able to do is print out the address book itself.
Any ideas would be great.
Thanks,
Mike
Have a form on it with a combop box on it where the user can select the training topic that they would like a see all of the details on. After they select the topic and hit the generate report button, the report opens empty.
Here is the code that I am using to filter the report results...
Want to query table to get a list of all employees who have had a particular training then take their employee ID's and find them in the Worker table and change the field "Selected" to true. Was able to get it to mark the first record in the Worker table for the recordset but not the...
Have a user that wants a form that they can enter in information about trainings then select multiple people for a list box and put them into another list box. Then have a button that would duplicate the training information in the training table and put the person's ID number into the table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.