Search results

  1. D

    Comparison of Candidates against a given Position

    Hello again Plog (and Forums!), I have put together a DB file with some of what you describe and I think I have gotten as far as I can and need help with the next step. FYI: I have attached the file for reference. Quick Summary: I have three tables (Employees, Positions, and Evaluations)...
  2. D

    Field Validation Based on Field in Another Table

    Appreciate it, thanks Marla. I'll investigate the hiding option.
  3. D

    Data Macros on Linked Tables

    CJ, Sorry maybe I misunderstood. If I am not accessing my DB tables in Access, where exactly am I working with them?
  4. D

    Data Macros on Linked Tables

    Thanks CJ! So one way around this would be to make the tables Read Only in SharePoint, and only editable by using the Access Client where I would also add my data macros. :) Thanks!
  5. D

    Data Macros on Linked Tables

    Hi all, I am going to be setting up an Access DB with linked tables into SharePoint. I want to be able to setup data macros but came across this note on a Microsoft page: "Data macro logic only works with local tables; not linked tables although you can work around this when you are using an...
  6. D

    Comparison of Candidates against a given Position

    Plog! Thank you very much, this is truly very helpful and I think will get me on the right path. I really appreciate your help! I may be back when I understand their HR setup better, and I hope you will still be available as your help has been invaluable. Thanks again.
  7. D

    Comparison of Candidates against a given Position

    Hi Plog, You are absolutely correct, the formula eludes me and it is not an area where I have alot of experience. I am new to Access in general. I had thought of a similar idea of coming up with a score, and using that score to rank candidates. I'm glad you had the same thought as it means I...
  8. D

    Comparison of Candidates against a given Position

    Hi everyone, I have an HR scenario here and wondered how experts would approach it. Suffice to say I am using Access on the back end (to be used by HR admin) and SharePoint on the front end (to gather data from users). SETUP -Let's say I have a table in Access which has a list of the positions...
  9. D

    Field Validation Based on Field in Another Table

    Hi guys, I have looked and looked and seen various threads like this but none that really answered my question and I want to determine if i'm doing something that is not recommended in some way. I am doing a simple mockup of an HR solution where I have two simple tables: -Positions (where I...
Back
Top Bottom