Recent content by valgore

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

ok this was my fix. i haven't tested it a whole lot, but it seems to work for the ones i've tested. Private Sub Report_Open(Cancel As Integer) Dim strstartdate As String Dim strenddate As String Dim month As String Dim year As String Dim counter As Integer counter = 1...

i figured out how to fix my problem. might not be the prettiest but it works. ill post the code when im done. thanks for your help

i have. the problem i think is that the month's in the report is the month field i have in the table. the Table fields are month, year, and month/year. the month field is just a number which corresponds to the month, and the month year is a combo of the two fields (01/2012, etc) so on the...

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

ok, so in my listbox, it only has EmployeeID, first, and last name. but in the AddAssignment i want to bring over EmployeeID, project, department, salary. i currently have the OpenArgs bringing over the EmployeeID so is it possible to open the EmployeeID's whole record and pull stuff from it...

ok thanks, ill check it out and ill post back if i have any questions

So, i did something similar where i pulled the EmployeeID from the listbox and it successfully inputs the data into the AddAssignment ONLY if on the DoCmd.OpenForm i set acFormEdit. if i change it to acFormAdd, nothing is populated. and i need to add a new record on this form. any thoughts? Josh

thats not entirely what i want so let me explain a little bit more. right now i have 4 tables. one is Employees which holds their basic information, the second is Departments table that holds all of our departments. the third table is Projects, which holds all of our projects. The last table is...

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

got it to work thanks! i think i was trying to do too much by using the ADO stuff when Access pretty much does it for you. thanks for clearing things up!

my form is bound to the employees table so when i bind the CurrentDepartment combo box to the Department table, i get a #Name and i can't select anything. Do i need to bind my form to three different tables? If so, how do i do that. as to your second question, no, none of those tables use lookups

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

wow.... i feel stupid haha. thanks

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