Discover the Ultimate Billing System Example for Facilities

Billing system example for Facilities

hello friends hope you are all well friends in our last video to create a pathological center billing system I the I had designed this user form for the entry table for the entry of the items we have seen this just I have made little modification here just I want to run this you can see eight eight numbers of items has been added to this database you can see the database in the backend of these user form here if I want to add a new item see here the last item is the test code is 8 so I am adding another item new here it you can see it here it is 9 it has become 9 and say sodium say rupees 200 and if I add this test code is 9 and if I add this it and it will be added add you can see the test code here in the list box that is 9 but when I clicked on Add button the test code is displaying 8 so friends if I click on refresh button it will display the current test code so thus friends we have added in our last video we have added the items and now friends I I can I have made little modification to get rid of these that is whenever I add item it will also it will add here in these list box as well as in this controls that was 9 also we sin also be seen here in the test code or relate and related items will be displayed so for these friends I have made little modification in this form initialized section you can go there just I first I used this code these lines three lines of codes to display the records of this address so that the current record can be displayed but friends it is not it is not displaying the items when I click on Add button the current item is not displayed in the controls though it is being though though the current items are being displayed in the list box but to get rid of this problem I am just I am just did it I I am just deactivating these skew lines of code and activating these lines of code you can see just I have added this life support here instead of the instead of these lines of code I have added here these slides of boots you can see I have added III I have added the I have assigned the controls the value of sheet 1 and the second column for a second row first column this is the second and test name this is the second row second column and test price this is the second row third column and if I run this friends you can see if I delete this just delete it again I will enter it so new now I am sodium again writing sodium 200 and here you can see friends the current attempts is being displayed in the list box as well as in the controls so this little little modification I have made in this initialized section of this user form so I can delete this section now this was this is the little modification friends I have made subsequently to run this program smoothly and again friends here I have you can see the add button here I have these lines of codes for verifying the same records if the say if the current if they if the if they occur if the test code is matches then the program will be exit while adding and then it will be added with these lines of code has been used here friends in the delay in the delete section you can see here delete the code is similar just I have before deletion if answer is will be yes then I have added just these lines of code sheet 1.8 event because I want to delete items from the sheet 1 so little modifications has been done subsequently for running this software smoothly so I am I want to display the codes once again friends just add this is the this for addition you can see and when updation here this is the updation it is same in the ply as in the past my step 1 video step 1 of this program of this project and this is the code for new edition that is that will be increasing by 1 you saw when I click on new button the test code hat has been added with 1/8 has became line has become line here in the delete section I have used this life support and finally in the fresh button I have used these lines of codes to difference that user form one now frailes I want to move to my next part that is second part that is user from to here in this section I want to show you how a billing is being prepared so let's run this first friends see when I run this our pointer is displaying in the referred doctor here you can see the doctor reference control is being has been has been focused so first when I run this the cursor will blink here and here I have taken these fields ID number dead-dead will be automatic the current date and fr ID refer doctor the doctor's name and patient name address and here you can see six this is the male female and age of the patient contact number and test item you can see here these are the test item taken from this sheet one and the price if text item matches the price will be displayed automatically and our test code will be displayed here so friends just again I run this just take a LT case entry so doctor tick doctor named as s Rao patient say Robin address say Kolkata and sex male age 45 contact at one two three four five six seven eight nine ten and test named sodium you can see the test code is being displayed here beside the test name and price also being displayed here and if I idly add this see what happens ad here you can see the test the items has been added here in the list box here you can see the item code here and item name and amount and this is the transaction ID one and if I want to print this or if I want to add another items such as in this in this ID number you can see the ID number has become first name then age and then contact number all has been converted here name age 45 and the contact number and if I want to add if I want to add another test a test to this ID so just I click on the x-ray another ID and you can see the amount has become 300 and add and then if I click the a this ID see the cumulative figure is 500 you can see in the bottom at the bottom and if I want to print this just click on this print button here this printing will be done serial number and two items has been added one is sodium del X ray and total and you can see Bill number patient name sakes address bill date age contact anti-fur doctor's name so does printing will be done bill printing will be done we can we could have used the headings of these sheet of this page but for the practice I just created reports report only so those friends how it is been prepared I want to show you and analyze the codes so just rephrase this first I have rephrase this whenever i refresh this you can see this second deceit that is sheet three I have taken all the items in the street three report and has been deleted so friends just I want to now I want to show you how I designed this so at first you saw these friends here I run this you saw the cursor is blinked here just I am deleting this for this moment I want to delete delete so you can see whenever wherever I run this for the first time the refered doctor control textbox is being set focused and how it is done and here you can see our items has been added in this combo box here in this section you can see the items has been added so this how it is being added these has been you know friends this has been added at the initialized section of this user from so let's go to the initialized section to add items in the combo box you can see the names the combo 6 and here the name is combo test so first you can see here you can see the friends the controls these are labels and common battles just I want to go to the initial last section and here you can see in this take in this level the total amount cumulative amount so before that I want to go to I want to see you show you that coats of initialized section to add items in the in these combo boxes as well as to set focus when I run these so program to set focus the cursor or to set focus this control referred doctor when I run this for the first time so just double click here you can see the initialized section here you can see that to set focus here the text doctor here you can see the name of these textbox control is text doctor takes dear and this control we set focus here for the set focus I have used this code whenever I run this this control will be set focused that means cursor will blink here in this controls and to add items you can see you know this phrase how to add item in the combo box I have just added two items for sex that is male and female so compose X dot I ready to add item mil and composites Tata Adam Freeman we can see here the Co line of code and to add item in combo test here to test name these items will be added from the sheet one because you can see here the see I have in my previous video I have added items in the test sheet that is the sheet one and price also so here you can see the I have total I have counted the total number of rows in sheet 1 and then for X is equal to 2 to 0 that means here the T row and 2 from the second line you can see the second line here it will the records is I started from the second line so I have taken to 2 to 0 and then combo test order add item this lines of code you know this phrase how to write this code how to add items in your combo box in such a way I have done this in my previous video several times so combo walk combo test dot list combo test at least count minus 1 list index is equal to 0 that means the first column of the combo box will be added the items taken from the sheet 1 so you're taking from the taking from the second row second column of the sheet 1 here the second room is X is equal to X the value is 2 that means the row number is 2 so does the items has been added in our test code so to display the current date here you can see another thing is has been written to display the current date here in this section TxDOT value here this is the text date here this is the text date you can see to display the current date home when I run this just I have written this line of code and to display atoms in list box in descending order here I have you I I want to add items to this list box from this sheet that is she to here in this sheet from this sheet I want to take items from thee I want to add items to this list box so just you can you know this I have added items in for column and I and corner so I have written the list box one column count is equal to 4 and list box one column with 200 100 100 100 that means the 4th column the column width X has been assigned here and then I couldn't counted the total number of rows and for displaying the records in descending order I used this line of code for X is equal to count to 3 step minus 1 here this line of code will activate it and it will display the records in descending order in the list box and again then I have added item in the list box here in this line of codes you can see here in this line of code I have added the text ID and in this line of code I added the combo test and in this line of code I have added the price and transaction ID here friends you can see that I have added items from the from the second sheet and you can see the row has become started from 3 that way here is the value is 3 because you can see in the here first row second row is 0 that means transition ID will be 1 2 3 4 0 plus 1 so I have blocked this row with 0 and our record will be started from here I have taken three here you can see here you can see it will start from 3 up to 3 and a and you can see the text code and you can see the text ID will get value from the third column first third row first column this is the X visual 2 3 and and the test name will take the value from the from the from the third column upon the third row ninth column this is the third row level column and this is the third row 12 column of the sheet - so does friends whenever I add item that I will be automatically displayed in the list box whenever I run this program I so that's friends and so these things has been written in the initialized section of this user form here this is the initialized section and in the addition section friends you can see no another thing friends here when I click on these here when I click on this you can see the corresponding test code and the price is being displayed so how it is done you can double click here just change event you can see here this line of code will perform this action and you can see I have counted the total number of rows from the sheet 1 and here for X is got I took a for loop and for X is equal to 2 to Tito and if this matches if these seat 1 dot sales X comma 2 that means X comma 2 sheet one go to the seat 1 that is the name and if the name matches then the corresponding test price will be displayed here if this matches then lvl t code dot caption L will decode wins here you can see in the second here this is the level and here lvl lvl test code that is tea board will take the value from this from from the from the sheet one if this matches and lvl price the corresponding price will be displayed in the here it will it will be displayed you take the value this level L will price you can see just go just this is the lvl price and it will take the value from this second from the third column of the sheet one you can see you can see here this is a first column second column and third column there's a test price so if I have written these lines of code so the third column value of the third column second second row is a lvl price is the price so the air it will take the value this level will take the value if this matches so now I close this if and follow here with next X so those friends I am going to second form so those first when I click on these if matches with the seat one then the corresponding test code and price are being displayed so friends here in the addition section friends you can see add this is the addition section we know how to add items in any sheet here I want to add atoms in sheet 2 here you can see I have taken a variable string variable ID and here the here is the dough here here if the contact if they the text contact value is equal to null then exit sub you can you can check this blank value so I I have checked one by a blank value here you can check many fields blank value so this is not so much important here it will be done subsequently so to generate Auto number you can see the auto ID here you can see the ID has been a variable sting variable and it will hold the value of these patient name and concat sign patient age and contract sign and patient contact all this will be added to this ID has been assigned to this ID and take study I have trimmed it so that there is no any blank space between these so I trim this ID and then I added this in a simple manner I have total counter I have I have counted up to the blank row of the immediate blank row of the sheet 2 and then I start I have started to add items in the blank rows like this you know these friends how to add items and here you can see in the last line of code here you can see this is the transaction ID and the transaction ID will be the we will be added we're one with previous row that means here you can see if I go to the sheet 2 here this is 0 and the first transition at it will be 1 0 plus 1 then it will be 1 plus 1 plus 1 that is 2 it will be 2 here this will be 2 and like this so just to do this friends I have I have written this line of code in the 12 column it will take the value from the previous row that means the that means the river the previous a blank row that means the row where the data is existed here you can see data is existed in the sheet 2 here this is this row the first data is existed here that is 0 and it will be added 1 it will be added with 1 and we'll go on so here I have rephrase this so those friends I have written this I already lined up code for addition and for you can say for updation here you can see friends click when I click this here when I click any item just take another item deferred dr. is brown so a patient named ravine address say Kolkata sex say female age 35 contacts say anything and test name say MRI add an another test I can add just click here see when I click here the respective records respective for data is being displayed in the controls so how you can see in the backend the sheet here you can see and a highlighter street is being has been taken as the column of the list box control so here how it is being displayed in the controls whenever I click on these items just going back so just double click here you can see to display the things in the controls here display that transaction ID and ID of the selected records here this drives up code for X is equal to 0 to list box 1 at least count and here I don't need this here you can see the transaction ID dot caption will hold the value of the top of the third of the other card column of the list index see here you can see this is the lvl tid lvl tid here this has this is a level and whenever the matches you can see just run this fast if I click here you can see that transaction ID 1 is being displayed here beside this it will be helpful friends when I delayed these items when I required to delete any items or or when I require to modify any items this way this will be the transition ID will be required for matching so friends does I have written this code the lvl tid you will hold the value of the third column this the third column will hold the value this caption will hold the value of the third column of deep bleed box here you can see the theorems port kilometer one zero one two three this is the fourth column one two three four four three wins here you can see 3 3 means fourth zero least index means one column two second column one second column two third and three fourth fourth column actually and then friends display all data of the selected records to the controls I have it in this line report if but first I have counted the total number of rows in sheet 2 and then started from third row to the count 2 that means this and if this is matches if this is matches means if transition are these matches with the 12th column you can see the 12 column 1 1 2 3 4 5 6 7 8 9 10 11 and 12 if this ID matches tension area matches then the controls then these controls will take the value from this sheet and from this column row number and column now romba will start from 3 I is equal to 3 that means this value these controls will take the value from these sheet and from the respective column that is 3rd column this is the fourth column is the fifth column like this so does friends whenever I clicked it will show the it will show the data into the controls and here friends you can see I have just closed this end if with end if and next I and here I want to take the cumulative amount and so I declared a variable as long that is amount has become long and I have used this ellipse function to get the cumulative total of the items and it will be required if any patient wants to wants more testing more than one testing and the cumulative amount will be displayed in the but at the bottom in this level that is lvl Q dot caption so friends you can see here this at the bottom here lvl Q so if I run this and if I want to test I want to add more tests to this transition ID to this name so I can click this and x-ray so if I click and now it has the cumulative is 1500 you can see at the bottom and that if I add this item that is 300 it should be 1800 so add it it has been added and click this item here you can see it has been 1800 you can see friends all times the current record is being displayed at the top of the list box for this line of code in the initialized section you can go there for this line of code for this line of code for this line of code lines of code and I use the step function and to display the current record always at the top of the list box so thus friends if I click you can see it has been 100 and a 1800 so the spell you can add these items and to update friends just click select any item I were if I want to add items update this you stood up x-ray I want to take em I want to take TSH so if I update this see the transition are the second will be updated only the second transition will be updated update so here you can see and you can see it has been 1750 it has not ready to update this you know I know friends you can update this in my last videos I so you have to update so thus to update this I counted the total number of rows in sheet 2 well then I started from the third row of the sheet 2 and again I use this if statement condition that if these tid always transition ID will be action for always this transition are you can see this ID will be masked will be taken into account okay it is it is masked with the database of sheet to so if this matches if generation a transition are these matches then specific tiny recorder your data will be updated so to update this I use this line up port that means the first column of the sheet one will take the value of the text ID and so on like this like this like this these days this and this and that's all the respective all the respective all the respective peals of the sheet will take the value from these controls here where from this controls here to update this so then I close this if and next and rephrase this so thus you can see how to update this and delete to delete these friends just go to delete again the transition IDs being has been taken in interaction and total counted that number of rows in sheet 2 here you can see and they started from the third column and again this line of code if transition ID matches the specific record will be deleted then XI two dot activate I want to activate sheet to because I want to delete records from the sheet 2 it matches digestion ID matches and then the respective row will be selected and then I have used of I used a message box you should believe it or not sure delta v-b-e s plus VV question mark that well that means it will ask you if you are sure to delay this and if it is yes VV yes if answer is yes then selection delete it will be deleted and if and if and this n type 40 BC and this and if for this if and next and if fresco so those friends I have good lady right the codes in the deleted comment button and to print these here finally in the print so here in the print is I have just as I earned the value of this cell addressed the start of the value from these controls here you can see in the sheet here see three here these Section B 1 and B 1 B 2 D 2 D 3 D 3 and this is before and before you can see the field named Bill number patient name sex address bill debt age contact and doctor referred refer doctor's name here these are the fixed and that just so so I took the value from the controls of the here you can see this control signal ID refer doctor patient you can see the data in the controls here just these data will will has been assigned to these cells so in the print section I just I just signed the cells to this value of the controls here and then to add items in the second part that is in the that is from the seventh column that is from the seventh row to add items I have just created I counted the total number of rows again of the sheet 2 and then started from the third column and if this matches again if here in this section I want to match the ID what is ID you saw this these are ID if this ID you can see the ID here you can see the ID name if this matches then that is Inuk unique and then the all test under this idea of this patient will be taken in the test for in in this section that is all the test in the tail under the test column all the amount of the test and the amount column our serial number one two three how many tests so here in this section this ID must be masked so here you can see I wrote this if the transaction ID here the text ID this is Dexter D that means the that means that it is the idea of the patient text ID you can see here you can see the name just click here you can see the ID the ID of the patient if it is matches so if it is matches with these first columns it wall you can see the first color of the sheet one there is seat - actually there is the IDS if this matches with this c2 c2 first color sheet - first column of C - then I have counted the total number of rows in the sheet three because I want to display the report or the bill in the sheet three so I counted the total number of rows of the chute three and she three dot cells P Road here the T row the the last record and last record last row and this is the last row plus 1 that means the blank row is will hold the value of one here I have used one for the for displaying one in every row for the first time then I will change it to say a serial number so in the so it will take it will take into action just little letter I will tell you so this is the main things this is the second column will hold the value from the ninth column of the sheet to and this is the third column of the sheet three and it will hold the value from the 11th column that is the price and this is the test you can write is a test name test name tears name and test price and this is the serial number so like this so I have just closed this with next I so does our if these matches the following functions will be executed following line of course will be executed and then a print running serial and total with right alignment here that tote here I have total again counted the total number of rows and 4/7 - yo you can see here in third column the this is the seventh you can see it will start from the seventh row and so it just started from the seventh row - Iiro and shiiine ourselves t you are T here the T being seventh first column will hold the value of t1 that way steaming 7 and minus 6 is equal to 7 minus 6.1 and now friends this one will be converted to serial number one two three four like this NXT so this is what the running serial and that alignment and here I want to add total here you know the word total in the second column here in the second column here in this section when I total add this in the at the bottom I want total total the word total and here the total value here in this amount section so this is the second column so I have say in the second column I use this code total will be displayed and the second column will be horizontally aligned right aligned so that the total will be displayed in the right section you can see here in the right aligned section the amount will appear in the aligned right so this is the alignment and third you can see the third third column that is the sum that will the total of the all tests and it has been the tote sum up column see you can see here the C column the here is the C column and the amount will be added here all items will be added so print and and then I took a borderline so so that it can be bought out so I again started I counted the total number of rows and what I will be given from the sixth column sixth row of the sheet three here the body will be started from here from the sixth row yeah this will be started from the sixth row here for this so I took sixth row and to be do that means the total number of rows and then you can see I I started the I I bother the every row Excel continuous is equal to excel continuous Excel continuous that means the CBO first column will be board that dot borders dot lines tell this is the syntax is equal to excel continuous similarly this is the this is the second column and this is the third column and next to be refresh unload is our form 2 and sheet 3 and here for the refresh and here for the refresh of this is a form I use this function so those friends painting is done so this is the printing is done friends and you can see the lines of codes here in the prints prints section I have used and to refresh this is a form here you can see I I just I want to delete these items first just run this first here if I run this print to delete the previous bill I up to these sixth column I just up to the seventh column actually after I want to drag this actually just going back to the street 3 here I need to delete this section to get to make it ready for next bill so I will need to read this for this new bill so for these friends to rephrase this here I have to counted the number of rows up to the blank rows of the sheet 3 here are sido and for senior is equal to 0 to 7 step minus 1 up to 7th car road it will be deleted and this you can see up to this section it will be deleted from the bottom from the bottom attributed rated 1 2 3 up to this section up to these 7th so 0 to 7 step minus 1 and sheet treat our cells C comma 1 entire row dot select I wanted to select the entire rows and selection dot delete next C so I deleted the previous billing bill to make it ready for the new bill so then i refresh this is a form here - friends I have created this is our form and you can see you print seed like this and if I want to just to do / - to make to print any bill just before that we would need to refresh first you can see the total number of rows has been dreaded and select any will just print you can see closed and if added I want to add more than one and I another item for this sugar in this in this ID number so say sugar you can see 1750 and another 100 so we are fasting at it so you can see the solar fasting has been added and it has become 1850 so to print this I just want need to delete this first so refresh this refresh and then select and paint see what this bill is being generated so now we can print this you can print this here so thus friends I have created this user form and the second part and this is the final part of the billing system front line front of his billing system of a pathological send just you can practice these friends and if you have any question please comments me and I will try my level best to answer your question and you can I can show you friends the holes in these common buttons here again you can see these all the codes here you can see these codes there is no respective common battles all the courses when everything has been analyzed and if you have any question please comment main friends al friends again if if this this is little helpful to you please subscribe this channel friends and it will be a great boost for me Thank You friends thank you very much for giving this Thank You friends once again