Search results

  1. V

    Subform/Subreport

    Hello! Can you please advise on how I could have the following show up by default in the subform for every single person? I have (1) table with: Firstname LastName EmpID The second table with: EmpID AntennaType AssemblyNumber TaskName Here is an example of the data: Thank you for the help!
  2. V

    List Box Help

    Hello, I would like for the Process Area and Description to auto populate based on what I enter under Cert Code. I am unsure how to do this with a List Box? Appreciate the support, thank you
  3. V

    Database Records By User Login

    Hello, I need to develop an access database that will only allow users to see records based on their login. Could someone please refer me to a sample database, video, etc on how to get this done. Thanks you
  4. V

    How to create query across multiple tables

    I have a database with a: (form, table, and subform) for each MFG Supervisor. The Prod Manager does not want the supervisors to have access to each others employee information. How would I then create a query that will run a report to capture the data from the various supervisors under (1)...
  5. V

    Unable to email report

    I'm sure its something simple and I am just overlooking it. I am using ACCESS 2010, and when I generate my Report under Preview this is what I see: The ability to attach it and email it is not available. Appreciate the advice on being able to email any report I generate. Thank you
  6. V

    How to count entries by month

    Hello, I need advice on the following: I have a table with a field called "Month" as a Text field, then the entries are January, February, March, etc. I am trying to see how many applicants I had by month. I did the following: My result: First, not sure what 231 is since this is not the...
  7. V

    Solved Login Form Access 2010

    Hello, I am trying to have a user login with a Username and Password in order to access the frmMain. I have the following code: Option Compare Database Option Explicit Private Sub btnLogin_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblUser", dbOpenSnapshot...
  8. V

    Solved List Query Results From Partial Entry

    Hello! I have a table with fields that include supervisor and department. I have a query with [Enter Supervisor Name] Currently, I have to enter the Full Name in order to see the result, same issue with Department. Appreciate the advice, thanks you.
  9. V

    Solved Between Two Dates - Display Years and Months

    I am building an employee database. Under the field "Seniority" I need it to display their tenure in Years and Months, (days) is optional. I have a field with the date of hire (DOH) for every employee. How may I achieve this? I am using Access 2010. Thank you
  10. V

    Import Excel Data

    I am in need of advice in regard to importing Excel sheets. The Excel sheet has data that is copy/pasted directly from our ERP. This data contains columns that I do not need. I then select all the columns I do not need and delete them all at once. I save this Excel sheet, then import it to...
  11. V

    Due Date Based on Purchase Date

    Hello Geniuses! I have a "Purchase Date" field and a "Due Date" field. I need the "Due Date" field to auto populate +7 working days excluding the weekend. How would I accomplish this? Thank you
  12. V

    Auto Date Based On Checkbox

    Hello! I have a checkbox called "Received", and a field called "Received Date". I would like the date to auto populate in the "Received Date" field upon clicking the checkbox. I went under properties for the checkbox, event, code and entered the following: Private Sub Received_Click() If...
  13. V

    Locking Fields

    Question: I have a field called "PartID" which has exclusive information. I need this field to be locked, and accessible only when entering a new PartID, then locked afterwards. Is there a way to do this? Thank you!
  14. V

    Uncheck a check box

    Hello, I have a database I use for ordering parts. I have a field that asks, "Open PO?" and a check box if "yes". Is there a way when I enter a date under the "Received" column that it clears the "yes" check box versus clicking on it manually? I worry about forgetting to do this and having...
  15. V

    How to omit expired data from report

    Hello, Can someone please tell me what criteria I need to enter to omit expired data from the report? Example: When an employee is late, leaves early, or is absent they receive either a .5 or 1 point. This point cancels after 1 year. Currently the report captures all of the information and...
Top Bottom