Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rufusjeep

    Query between dates regardless of year

    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...
  2. Rufusjeep

    Query between dates regardless of year

    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...
  3. Rufusjeep

    Query between dates regardless of year

    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...
  4. Rufusjeep

    Filter form with cirteria that changes.

    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...
  5. Rufusjeep

    Have two forms each of which are ba

    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...
  6. Rufusjeep

    Cancelling openning of report if no data is in the report

    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...
  7. Rufusjeep

    Prinit contents of a group

    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
  8. Rufusjeep

    Filter report based on a query using combo box

    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...
  9. Rufusjeep

    Do While Loop not producing expected 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...
  10. Rufusjeep

    Duplicating record and change only one field in new record

    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...

Part and Inventory Search

Back
Top