Search results for query: *

I have two distinct databases (Personnel and Revenue tracking) and I am trying to secure them and also create a switchboard for users (20+) to open and use. Some users need access to one or both databases. Some users need data entry/update rights to the tables/forms, and managers need read-only...

When I look at the table, just seeing the personnel# is sometimes confusing... I thought viewing the names also would help to clarify when there is an issue with a transaction. Thanks.

Hi, I have a table (tblEmpHistory) with fields that are updated from a form. The updated field are Personnel#, Date, Transaction Type. Name. I would like to add LastName & FirstName fields to the same table and the Names would populate based on the Personnel# that is entered. I also have a...

I reviewed each one the issues and the problem seems to be #3, Max Date. To fix the problem, I created two queries. 1. Qry_MaxDate using EmpHistory Table and selecting EmpHistoryID and EffectiveDate (Max) The second query from EmpDetails Table EmpHistoryID PosNumID VRBStatus VRBHistory (The...

Thanks for the information. I had read the article, but the problem I am having is how to fix it and to make it work.

Greetings, I am trying to create a form to update two fields (VRB-Status, and VRB-Notes) but the fields are not updatable. The form is based on a query (qry_VacantPositionsDetails) that is based on two other queries. The VacantPositionsDetails query is designed to only display those position...

Thanks. It worked!

How do I create a form so that it opens to a blank form and ready for data entry? The users should only see the data they are entering. The form consists of a main form and sub form. Both should be blank when the form is opened. Thanks.

How do I create "indexed as unique?" I have three tables: 1. tblSite with SiteID as the Primary Key 2. tblPosition with PositionID as the Primary Key 3. tblSitePosition with SitePositionID as the Primary key and SiteID and PositionID within the table. How do I set SiteID + PositionID indexed...

Thanks for the replies which helps me track the Employee History. How do I track the Position History. Example, Nancy was LCook1 at Site2 and promoted to LCook2 at Site3 on 2/1/05. Now the LCook1 position at Site 2 is vacant as of 2/1/05 and the LCook2 position at Site 3 is filled as of...

Kind of long question - I am new and need help designing a database to track current employees and turnover postions. Background info: Every employees is in a unique position number and there are multiple sites. Employees transfer from site to site creating constant turnover. A position # can...

I am trying to create a Access database to generate reports of Library collection fees. tbl_Library (libraryID - Text key field) has all the Library ID #, names, location; tbl_Receipts (ReceiptID-Auto#-keyfield), LibraryID-text, collection date tbl_ReceiptDetails (Number-key field) and...