Search results

  1. L

    Help With List Box Options

    Hi There, I hope someone can help me figure out how to write the code for my problem. What I want to do is a bit complex (to me) so I will try and explain it well. Scenario [/U] I have courses employees can take eg: Oreintation NHL information Snowboard Anatomy I have 100 employees that...
  2. L

    Calender question

    Hi There, I am hoping someone can help me with this question. It might be very easy. What I want to do is beside all my date fields, instead of typing in a date, I want to be able to click on a small icon that would bring up a calender and then the user simple clicks the date that he wants...
  3. L

    Very Strange Date problem

    Hi There, I am having a very strange issue that has popped up that I can't explained. I thought my client was nuts, until I view this problem for myself. Problem: At my clients office, Dates switch to MM/DD/YY At my home and other computers I have tried, Dates switch to DD/MM/YY The dates...
  4. L

    if statement

    Hi There, I am having major problems with getting my query to filter data using a yes/no field. What I am trying to do is in the form, I click mark off employees from the "Select" field to say that I have completed their 90 day review. But once I check mark somebody off, I don't want them...
  5. L

    If statement

    Hi There, I having been trying to have an if statement work, but have no success. I have attach a pic of what I am trying to do. I have a form that has data in it and a yes/no check box at the end. The form is looking at data from a query. If there is a check mark in the box, append those...
  6. L

    Complex If Statement

    Hi There, I am still having major troblems trying to get my query and form to do what I want. I have had some suggestions and I have tried them without success. I have tried the following and It doesn't do anything. Field: IIf([EmployeeStartDate]+90>=Date()-14 And...
  7. L

    Complex Query

    Hi There, I am hoping someone can help me with my problem that I am having. I have a query that is using the fucntion DateAdd. What I am trying to do is have the query pick through the list of employees who's 90 probate period is up and display them. The problem that I am running into is...
  8. L

    Drop and Drag in a list box

    Hi There, I tried posting this yesterday, but I can't find it. I have a problem with my code for Drop and Drag from one list box to the other. What i am trying to do is Pick a trainining course, put in the date, and the length of the course. Then I need to add the people that Attended the...
  9. L

    Drop and Drag List Box

    Hi There, I need help on making my drop and drag list boxes. I can send anyone the example that I am trying to get to work. I can't get the code to work right. I want to be able to pick a course, enter the date, pick the length of the course and then choose the employees from the first list...
  10. L

    Between function using DateAdd

    Hi There, I have a query that is for filtering people that their 90 day review is coming up. Field: nintydayreview: DateAdd("d",83,[EmployeeStartDate]) Criteria: [forms]![frm-90dayreviewtime]![meetingdate] This only bring up the people exactly 83 days, how do I pick the people from 83 days...
  11. L

    An Add Button

    Hi There, I was wondering if anyone could help me. I want to have a setup up of a list box that contains names, a list box that contains courses. I want to be able to choose a course like managament course and click on a name, add, choose another name who took the course, add and so on. How...
  12. L

    One more Qry six month question

    Hi There Again, Just one last question, I have set up my query to look up every six months. Then I append that date to a history table. then I need it to look at the Last Review date field. Can I still have the following in the StartDate (when the employee started with the company) and have...
  13. L

    Query to calc. every six months

    Hi there, I have employee data that includes a start date, personal info, ect. I need to have a qeury to calculate and filter people for the employee's six month review's from there start date, and then six months from their last review. I don't have a clue on how do go about doing this...
  14. L

    Printing help

    Hi there, I have a database that allows you to filter last names. How do I setup the report to just display the filter choice and print that choice? For example, you choose B and all people with last names with B's come up. When I preview the report, it shows A-Z, how do I get it to just...
Back
Top Bottom