Search results

  1. V

    Loop through Employees in report

    Hello, i've attached my DB because it's confusing to explain without having it. basically, i have three tables i'm worried about; Employees, AssignmentData, and EmployeeSalaryHistory. What our DB is used for is it tracks which employee is on which project on any given month. The AssignmentData...
  2. V

    Report Parameter

    Hello, i've been reading a lot of different posts on this and i still cant seem to figure it out. basically i have a report that shows data for the current year broken up by months. i created a crosstab query and i've attached what the report looks like (which is what i want). the numbers at the...
  3. V

    Add Button auto fills form based on listbox

    Hello, i have a form EmployeeAssignment. on it is two list boxes. the first is a list of the first and last names of all employees and the second filters all assignment records with that employees ID. what i want is when i click on an employee in the first listbox and click a button, i want my...
  4. V

    combo box data not being inputted into table field

    Hello, I have an AddEmployee form that is linked to my employee table. it has simple text boxes for the user to input information. i created two combo boxes, one pointing to the department table and the other pointing to the projects table. im using this code to add a new record, and it inputs...
  5. V

    Dbl-clicking prints a report

    Hello, i have a table that pulls all report names into it and i have a listbox in frm_Reports showing all the reports in it. when i double click the report name in the listbox, it prints instead of opening and i have no idea why. here is my code: Private Sub List0_DblClick(Cancel As Integer)...
  6. V

    Filter listbox from combo box

    Hello everyone, i've look at other posts about this, and i can't get it to work for my database. I have a combo box called Employee_ID that is linked to a list box. the list box has a bunch of data that is being pulled from the EmployeeData table. im using the combo box to allow me to sort the...
  7. V

    Button to generate 2 years worth of data

    Hello, I have a complicated question. I have a database that currently holds Employee data. I have a separate table that has their ID, the date (in days), the year, and the project they are working on for the given day. Basically, I'd like a button that populates these three fields with data for...
  8. V

    Edit records from listbox

    I have a form in Access 2010 with a listbox on it that displays a table of Employees. above that is all the fields that are in the table. what i want to do is be able to double click a name in the listbox and have it populate the fields above the table in order to edit the records. here is a...
  9. V

    Go to first record if on last record

    Hello, I've been looking around this forum and others for an answer, and I can't figure this one out. I'm using Access 2010 and I have a form populating based on a table. when the form opens, it displays the first record and the user can cycle through all the records until the end by using a...
Back
Top Bottom