Search results for query: *

Good morning all, The query I am trying to create is a doozy and I could really use some assistance. Background Jobs in my office have a list of competency levels that an employee must achieve through testing in order to apply for a position. The goal of this query is to provide a count of...

Good morning all, I think I'm close to solving this puzzle but there's just one piece missing. I have a main form with a two continuous subforms on it. The subforms refer to required levels that an employee must have in different "competencies" in order to fill a certain job. So jobs have...

Good morning all, I can't seem to find the error in this, I'm hoping someone can shed some light. I am trying to filter a form to only show entries from this fiscal year. I have a fiscal year table that I am doing a DLookUp on. When I try to apply the filter, I get the following error...

Hello all, I have a DB that I use to track overtime hours worked by employees. The hours are sent to me from different departments in an excel spreadsheet form. I then manually key the hours into the database (I realize that I could probably import the spreadsheets as opposed to rekeying, but...

Hello all, Every year, employees receive a salary increase based on our collective agreement. I have a database that tracks salary costs and I need to update to the new salary values. The salary table is structured as follows: tblSalary EmployeeID (FK to tblEmployees) SalaryID (Autonumber...

Hello all, I am designing a DB that will track employee salary costs on an ongoing basis. The biggest snag I have run into is how to handle when employees receive a pay raise (which happens yearly). My thoughts are to use a join table that uses a dual primary key. Something like this...

Hi, I have some knowledge of Access and have read many articles on relational database design. I have created several tables and have established relationships between them to allow for cascading updates, etc. The difficulty I am having now though, is that my forms are requiring subforms and...

I apologize in advance for this question. My company has several terminals that are linked to a central server. My goal is to have our IT dept create a protected folder that only specific users can access. In that folder I wish to put the database I have created. I know that in macros that...

Hello all, I have created a database in Access 2000 that manages employees training and learning. This database has several reports that provide employee lists and statistics for management. I was recently asked to add a checkbox to the employee form that would denote if an employee is "Off...