Search results

it should be pointed out that the days are stored as numbers. 1 = sunday and 7 = saturday. How would that change what you've suggested?

If i were well versed in making queries that might be something I could do. However I am not sure how to create said queries, would you know the proper sql syntax for that?

I tried this query but I keep getting a syntax error message. SELECT [tblEmployee].[txtFName],[ tblEmployee].[txtLName] FROM [tblEmployee] left JOIN [tblDepartments] ON [tblDepartments.pkDeptID] = [tblEmployee.fkDeptID] Left JOIN [tblEmpDaysOff] ON [tblEmployee].[pkEmployeeID] =...

I don't know exactly what I need in terms of how it is done in access. In real word terms what I need is a query to show how many employees are scheduled by department. How do I create a query that will count the number of employees in that department that aren't off on that particular day...

That would be true I suppose. Ultimately I will being using forms instead of the queries themselves. But I'm having trouble getting the forms to behave the way they should. Once I get that sorted out then I will use forms. Basically what the forms are supposed to do are show employees...

Ok i guess I had the wrong control source. Should have been fkJobDescID but I had it set to the wrong field. got it, just panicked heh.

jz I have no idea what I did but on the jobs tab it says this whenever I try to add a job for someone: Control can't be edited; it's bound to AutoNumber field 'pkEmpJobDescID'. How do I fix this?

I have a query that keeps opening wider than that looks nice how do I reduce the width of a query via VBA code?

figured it out, query sql view. and this is the sql statement that worked for what I needed: SELECT tblEmployee.pkEmployeeID, tblEmployee.txtFName, tblEmployee.txtLName FROM tblEmployee LEFT JOIN tblEmployeeJobDescriptions ON tblEmployee.pkEmployeeID = tblEmployeeJobDescriptions.fkEmployeeID...

using a website I think I constructed the sql statement I will need to do the check to find missing entries. However now that I have this statement. I do not know how to apply it to a query. Using VBA how do I apply this to a query? Also does the sql string look ok? sqlString = "SELECT...

I have found a few things on this on the internet but none of it makes sense to me. I need a query that will look for persons that are missing jobs. The setup is as follows: tblEmployee contains the following fields: pkEmployeeID as Autonumber txtFName as text txtLName as text...

thanks that solved it.

I'm trying to use this macro (not designed by me) to try to archive records older than 1 year. The part that is erroring out is directly below, the entire macro is below that. Keeps telling me that there is a syntax error. the origin table is tblEmployeeAttendance, the table being inserted...

Thanks for all the help on this. I will look into those sites and try to learn the rest of what I need. Truly thankful for all the time and effort you have put into helping me on my way.

How can I toggle the filters to show / hide inactive employees (with vba code). Would a report based on the employees points be created using a query? How can I modify a queries parameters with vba code when a command button is clicked? thanks so much for the help you've given so far as always.

IsError() is supported? No matter how I wrap the formula it still gives an error. The textboxes in question are the days off name text box and the one I created. For the name for the employee on the newly created Attendance Marks tab.

Actually you know what I have added another page to the frmEmployee and made a new form called frmPoints. Added that form to the frmEmployee, finally got a dlookup working now that I have the syntax correct. To lookup the employee name from empid, and to lookup the attendancetypeID, from there...

Thats what I meant actually, to use code filters. Hiding inactive employees is good, but would there be code that could be assigned to a toggle that would show inactive employees? So they could then be reactivated if needed. UPDATE! This part is partially solved right now. The only thing I...

Thanks for your help. I'm no longer feeling like this is pointless (mainly because you have done most of the hard work heh). Actually since I no longer intend to track days employees are present (because I agree with your logic, the point of this database is to know when someone isn't here...

I'm new to access and have little idea how to lookup a name from an employee ID. Below is the formula I'm trying but it is erroring out and I don't know how to fix it. Can anyone help? Employee Name: DLookUp("txtFName","tblEmployee","Criteria =" & [tblEmployeeAttendance.fkEmployeeID]) Below...