Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cft
  • Order by date
  1. cft

    Security - limit access to forms within db

    I have a database in which I would like to have a Password as the "gatekeeper" to forms within the database. When a particular form is selected from the Switchboard I would like it to request a password that is selected by the primary user of that form. This is an accounting database...
  2. cft

    Input to 2 Subforms thru Data Entry into 1 Criteria Box

    I have a form with 2 subforms. One subform autopopulates with Employee data upon input of the Employee ID. Another (single field) shows which, of 12 entries into the employee file, is the current one. Upon opening the Main Form thru the switchboard, 2 Criteria boxes pop up sequentially. The...
  3. cft

    Linking Table or Query to Updatable Excel for read only

    I am unable to do the simplest thing - Link a table / query or form to an Excel spreadsheet exported from the Access object. The xls asks if I want to update the linked spreadsheet, but it only updates if the Access source is open. I need the data available to multiple users (120 or so) even...
  4. cft

    Syntax for calculated field to return specific records

    I am creating a Data Entry Form for Employee evaluations. On the form I have a calculated field called "Record". This field is to show the cumulative number of entries within a given month. Each Supervisor has Employees whom they evaluate 12 times a month. The form confirms the...
  5. cft

    Calculated field to return count (to-date) for current month

    GingerR - Thank you. I used =DCount("EmpID","TblAudPerf","[EmpID]"="forms!FrmEmployee!EmpID")but it came up zero where the records should read 6 total. I think this is the right path, however. There is a sub-form called Employee data that autofills upon...
  6. cft

    Calculated field to return count (to-date) for current month

    Thank you - I am creating a Data Entry Form for employee evaluations. On the form, I have a calculated field called "Record". The Record number is the number of the newest entry of evaluative data into the Employee's record. Each Supervisor has a number of Employees whom they...
  7. cft

    Calculated field to return count (to-date) for current month

    I am developing a form that has a calculated field to display the number of the current record as: "X" OF 12. Each employee of a group is evaluated 12 times each month. The Data Entry form needs to display this so the user can know which record they are entering. Criteria is based on...

Part and Inventory Search

Back
Top