Search results

  1. 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
  2. V

    Import Excel Data

    I am trying to use the transferspreadsheet function and I keep getting error 3709. In the spreadsheet I am trying to import, not all columns have a heading. Is this a problem? Thanks
  3. 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...
  4. V

    Due Date Based on Purchase Date

    You Sir are a Master Mind!!! Thank you very much!
  5. V

    Due Date Based on Purchase Date

    Is the function declaration the content in Module 1?
  6. V

    Due Date Based on Purchase Date

    Ok, I did as instructed and copied the material under Module 1. I entered: Me.DueDate=fAddWorkdays(7,Me.PurchaseDate) in the AfterUpdate event of Purchase Date. When I entered 11/4/19 under Purchase Date, the Due Date says 10/20/2067.
  7. V

    Due Date Based on Purchase Date

    Yes I have it, please forgive my ignorance but I was not sure where to copy/paste the content. Would it be under Module?
  8. V

    Due Date Based on Purchase Date

    Any suggestions/help? Thank you very much everyone!
  9. V

    Hello from Kenya

    Sasa! Karibu karibu!
  10. V

    Due Date Based on Purchase Date

    I entered the code Me.DueDate=fAddWorkdays(7,Me.PurchaseDate) In the AfterUpdate event of Purchase Date and its not working?
  11. V

    Due Date Based on Purchase Date

    Hello, The due date is an "estimate" only. Example: Purchase Date Monday 11/4/19 Due Date would be 11/13/19, not including weekends on a basic Mon - Fri work week. Holidays may offset this date, but since it is an estimate I think it would be acceptable. I am looking for a general date to be...
  12. 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
  13. 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...
  14. V

    Locking Fields

    Could something like this work? If Me.NewRecord Then Me.Part ID.Locked = False Else Me.Part ID.Locked = True End If
  15. V

    Locking Fields

    "Locked property you can use." - I locked the field. How do I unlock it to add a new partid? Other than access the property sheet and manually unlocking it then locking it again? You can also use Conditional Formatting for this. - What would I enter here?
  16. 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!
  17. V

    Uncheck a check box

    I see what you are saying, so if I were to run a report for open po's, my query under "Received" would be "false" if empty or? Thank you for the advice!
  18. 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...
  19. V

    How to omit expired data from report

    Hello, I left my original formula in the query and for criteria I entered >=Now() and it gave the results I needed. Thank you for trying to help me!
  20. V

    How to omit expired data from report

    When entering the information as you gave it to me, I click "Run" and get nothing.
Back
Top Bottom