User Profile
Jbuff26
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Setting query as record source
I'm trying to redo my current training database by using the Access Faculty template as my guide. I noticed that the forms are all set to the query "Faculty Extended" as the record source, which has become a little annoying since I'm obviously changing the column headers. Whats the reason behind using a query as the record source?Default value not recognized
I will preface by acknowledging the amount of code written to accomplish a very simple task is likely sloppy and entirely unnecessary, but I'm very new and entirely self taught by forums such as these. With that said, here is my issue: I have created a form that tracks when employees are observed under certain safety principles. To try and keep it as simple as possible for data entry I have two fields. A display field that shows the current record (left side) and a data entry field that manipulates the record (Right Side, all fields have "add" at the end). If I want to add that they were observed on a principle, lets say its "Passing", then I select the drop down at "Pass Add" and select the "1" in the drop down menu. This then triggers a macro to update the record. The code for this is pretty simple and works great To make this happen however, I had to populate all the fields in the corresponding table with a "0". I found then I had to have a way to add employees to the record set on the fly so I created a quick data entry form that will add a new name to the record set. What I realized was that the 0's on the new employees weren't entered and thus the macro would not work on them. I changed the default value to "0" on the fields but it still doesn't work. The only way it works is if an actual 0 is entered for all blank fields. Why is this?Table formulas
I'm currently using the following formulas to pull data from A to B based on a condition, then from B to C based on a condition, then finally from C to D based on a condition: A to B ==FILTER(INDEX(Applicants2,SEQUENCE(ROWS(Applicants2)),{1,13,12,11}),Applicants2[Cleared Backround]="Yes") B to C ==FILTER(INDEX('Hired 2022'!A3:F67,SEQUENCE(ROWS('Hired 2022'!A3:F67)),{1,4,3,2}),'Hired 2022'!F3:F67="Yes") C to D ==FILTER(INDEX(Training,SEQUENCE(ROWS(Training)),{2,4,33}),Training[Authorized on Battery Changer]="Yes") You can see that the 1st and 3rd formulas are pulling from tables while the 2nd does not. The 3rd formula is pulling from a duplicate worksheet where the data in formula 2 populates to, except the duplicate worksheet I have kept as a table. I did this so I could easily add more formulas based off the table references instead of having to constantly click and drag. My question is how can I alter my formula so that it spills all the required data AND I keep my data as a table? Is this even possible?Not sure what the best function is to use
I'm currently attempting to make cells populate if a few conditions are true. Below is a snapshot from the table on what I'm attempting. The information below is from a table that forms the policy index for that specific set of Clauses. So this one is "Section 1" and is on its own tab. The full list of all documents are their own tab. The goal is to find in the full list of documents the specific Document Number and return the information for Date Reviewed, Review Frequency, Review Date, and Author. This will help form a snapshot on the index which is placed in the binder when everything is due for that specific section. It will also keep the index updated since the main list of documents is where updates always occur. What would be really amazing is if all this could also be tied to the actual policy word document, but I'll save that for another question! Policy Document Number BRC Number Full Doc Version # Date Reviewed Review Frequency Review Due Author Product Safety & Quality Culture 1111 1 1111.01 1 =
