Search results

Sorry if I am not posting this the usual way Eligibility Table ID Employee (lookup to employeeID) EligiblePosition (lookup to positionID) eg. 001 Joe Smith CEO 002 Joe Smith CIO 003 Joe Smith Janitor In my final table, I want to be able to select (via a form) Joe Smith as a possible...

Hi guys, I need help with the Validation Rule expression. I have a table like follows: ID Position (lookup to position table) Slot1 (lookup to employee table) Slot2 Slot3 In the field "slot1" I want to lookup a name of a person in the Employee table, but ONLY IF, in a third table...

I am starting to understand - thank you for your patience. Two followups: a) data entry side. In access, on teh data entry side, i assume we would use forms to tie this all together somehow, but I'm unclear as to how the forms would then write back data to all these separate tables. b)...

Hi Plog, Just so I am understanding, would the recommendation be to have additional tables for the base data as follows: Table1: Positions Divide into way more (?) tables: 1a. Contains positions info 1b. Competency1 table (contains Position field, baseline required score field) 1c...

Ok! Thank you sir! So my process .... I would take this and build a macro with it, correct? What parts would I need to modify for my own use? Sorry for the newb questions.

Hi again. I have had another request, would adding another table be the way to go? Reminder of Setup (simplified) Hey - Hope you're having a good weekend! Did you get the WoT credit I sent ya? Wasn't sure if you needed gold or premium time more, so went with the latter for this one. If you...

I have some tables in an Access database linked to SharePoint. Is there a way to automate having to right click on each table and refreshing the data? Thanks!:D

Ok. At the end of the day I can be overruled (or just fired lol). How do I explain to them the cons of doing it their way. IE. the bad way?? If they choose to accept these, that will up to them to live with.

Sorry! My limited understanding of basic database design is that in a setup with tables such as -Company Jobs -Company Employees You want a way to link the data between someone in the Employees table, to a unique Job in the Job table. To do this, I believed I needed to use a lookup on the...

Update: (Sorry!) What if there was no longer the link between Employees and Positions, by there being the lookup from Employees to the Positions table? Reason I ask is they are telling me they don't want to bring in the entire list of positions, as they number is in the thousands. They wanted...

Wow, I would not have thought of a new table. So if someone here proposes storing the data in a column (or multiple) in the Employee table, I should dissuade them, correct? Thanks again. I hope this is the last time i need to bug you, but I doubt that will be true!

Hi again, New request came in today for the comparison feature. What they want is the ability to specify upfront (in the Employee) table, which 3 positions (jobs) are particular employee is driving toward. The query will then spit out a report for that individual and indicate, only for the...

Hi all, I want to keep my users out of the Access tables as much as possible, and instead keep their interactions with the forms. That being said, I'd like someone with more experience to give me some guidance on best practices when it comes to form design. What is the suggested approach when...

Thanks Plog I will do that!

OK. As for the criteria. Would I need to create 50 queries, one for each employee. Or is there a smarter way. Could you prompt the user somehow on which employee they want the query to run for? Would I need to use a method like this? Here

Hi again. Wondering if this is possible in access. Rather than having the query run and show all candidates and all positions, is it possible to have a dynamic query that returns all results for one given employee, or all results for one position? Could a drop down or something similar be added...

Got it working!! Yay! This is great, thank you so much Plog!

Hi again! Only two questions. a) Potential issue with last function? It seems the scores are getting ranked in reverse order, small scores are getting ranked #1 and larger score getting #2? b) I'd rather it show position name rather than ID. So i changed sub2 function to pull in the Position...

NVM got it working, had to delete the query, i think it didn't like losing the link to the old name. Will try this out now. Never done SQL but i think I can figure out what to do given what you left me.

Thanks so much Plog! I really appreciate the 'best practices' advice, this is very valuable. Is there a good way to rename fields after the fact, or must it be done right from the beginning? I'm getting errors trying to remove spaces. :(