Create a dynamic access report 10 in 1

hi in this lesson we'll learn how to create a dynamic river so in this database we have only one keyboard which is the article by default this rebirth display pulled the staff member we have 741 with this total amount of sorry but using the search for I can modify this report so if I select a specific building the report is updated to display only the staff member from this building I can select dating and the status so how many start working as a full-time in the main building so as a full-time Mabel thing we have 100 a month you can select as many parameters as you can so if you don't create this dynamic search for you will need 10 reports to get the result for a building pending at Department building and department and status and so on so let's start from scratch I'm going to open a new database so now I have a plant-eater days the first step I'm going to import data from an excel sheet so from standard data from a five sir I point to the self file telestroke contains code update on ID is not the placate so he is not appliquéd I'm going to use the ideas the primary key I will name the table as stop so now I have a table with 714 staff member with gold glitter I need to do the search using pending Department status stay what apparently so we will keep building department and state no but we will create a platform but as I started robot a combo box in the bank for the following design I would end with the applicative data so if I try to add a combo box here pull the status I have only four states is called time part-time contract and ordinary but because I get it from the table it is dublicate so I need to create a unique value list for the painting department state so I'm going to create a quail design using the table turning and from the property sheet for screen I will make unique values yes so now I can have a list of the pending so let's take this one as building so now we have a unique list of a building and it lists the department we have food see Department I need list for the state about the United States now I can create my form design drop the three combo box one from the building query so now I have three drop-down list was unique nari for selecting unique Nellie for Department anybody from the state let's create a good design so now I add a title for each drop down list I change the colors so now I need to add two buttons but let's say this form for now so this is the search horn was made whole name is the main form as I scroll now I will click the report the report is normally bought from the table with all the data but I come to this ideal renamed building department status sell real estate I need to defy the reboard our signals are reporters okay yes this okay so this Weibo 24 to display all the stuff member but I need to add a summary year so I know how many staff member we have my salary and so on so I can add text box I need to count the ID another text box I need to some Saturday so no it's okay a line list enable know so no one can select the content look now we need to add a code so the report content will be filtered according to this we will add two bottles here but before I rise a code I have to rename the combo box to a meaningful name so this combo box is building or let's say that this one is depth for Department this one is state so the key search is really simply cool from event context let's we'll take the build content and make it to code code which need nothing and do the same with the depth and with the state now we can test this code okay now I need to add report CUDA this is the most important cool this is the main story I will go to the good window now I need to create full valiums three variables to take the value from the pet department and state and the fourth variable to create the filtered step I will go step by step so the first step to check has the user select a building so if we don't build which is a combo box dot that it is not to code to code that means users select a value in this case I need my variable which is v-belt to take whatever information is the build is in the build combos but if you do it this way you will induce a mistake into the factor with the strange value was a text value so you have to add one code and before and after the vet okay to understand this let message box what isn't the field depth so let me select me my variable is me this is not right this will make my code not working because I need one code before and one code after the text to add it to the filter so my variable is equal to two coupon code to code and and the coupon code in this case if I select building my variable will be one code mean one and so so if they just left a building I take the value I add one chord before and after I don't need a box anymore and my filter is equal to del think building here is the thickest from the table you go to the table the field name is building so I use the field name so building is equal to the v-belt value so if I just select a building I take the value I add one code before and after I start creating my filters with the same concept if me dot Department dot value Y so I can ignore the value you can type only F middle Department and floors the same it's not everything it means the users later value in this case I need the V depth variable to equal one code to code to code and me dot that dot reading tend to float on cotton now I have to check if there is a strict Abednego No so if filters the variable is not playing in the user select a building then filter is equal filter is equal the building he select and and here is for the statement because I want to tell the Terry board to display the value from this building and from this tent first now the filter is the filter which can be played for helping end the name of the field in the table is the button equal and the depth which is my variable and the code okay just to understand I'm going to enable the message box for the building I will message box the filters no need too much responsibility and their message box the filter on FS rector building so my photo statement is building equal me that's it no buzzer action but it was victor building and the department so I start del T is equal main then I add and then I add building equal main and the bottom equal DC if I select all the department I have only the Department further step now I will do the same with the stage so now I'm sure I have a good shelter step I need to apply this filter stepping to the report so to command open report that both name is stuff I am going to open it in the report view so I can add buttons certainly madam need a filter name where condition is my filter bracket let's try so name this is only from main 200 stop member mean from Arizona by 20 stop member from Arizona all the people from Oklahoma whole 740 that's by

Channel: askfarouk

Views: 5,380

Rating: 4.9130435 out of 5

Keywords:

Id: VQwOxK56Jg0

Length: 13min 49sec (829 seconds)

Published: Fri Jun 26 2020