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

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

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

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.

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