Fully Automated Data Entry Form in Excel - Part 4 (with Validation and Print Features)

[@thedatalabs]

Please watch the Complete Tutorials (Part 1, 2, 3,4 and 5) of creating Fully Automated Data Entry Form in Excel. Part 1 (UI Design, Transfer and Reset) - kzbin.info/www/bejne/hmaWhWmlrcyIjKM Part 2 (Edit and Delete) - kzbin.info/www/bejne/gWLHZX2mqrGep6c Part 3 (Search and Filter) - kzbin.info/www/bejne/eJWofp1qg7OLd6c Part 4 (Validate and Print) -kzbin.info/www/bejne/ZpOpgH6mlrh8eMk Part 5 (Full Screen, Zoom and Dynamic Drop-down) - kzbin.info/www/bejne/nGi6ZHuIgbaMd9U

[@thedatalabs]

Currently, we are subtracting 1 from the row function as our data started from row 2. Please use the same formula and duduct 9 instead of 1. Thanks!

[@sujeetvichare5825]

Please show the ३rd part search feature code. I cannot see the ३rd screen properly

[@eagaton26]

Hello sir. What did you do in order to make the serial number dynamic? I barely see it on your video?

[@NiteMareRose]

was wondering how would i set up the print button to instead print the database but only records with a serial number e.g if other rows have formulas in then and i dont want them printed but just for records that have a serial number in them. how would i do that?

[@bransonkody3416]

instablaster

[@mikeramirez1695]

Your videos on this series have been phenomenal. Thank you.

[@thedatalabs]

Thanks for your feedback!

[@Ionel5924]

I really like your EntryForm lessons; I have become a fan of yours and thank you for your explanations!

[@carinademeester2497]

I watcht all the video's in this tutorial ( creating Fully Automated Data Entry Form in Excel ) and learned a lot . Thank You very much for this . Greetings From Belgium

[@soudaleephanthamixai293]

Your video series brought me a new life. It's my first time to learn about VBA. Thanks a lot ! From Laos

[@thedatalabs]

Thanks for your feedback! Please subscribe our channel.

[@iskofishing3846]

Thanks alot dude for this tutorials, looking forward for your other tuts, newbie here😁

[@TessHere]

just what I needed. thanks

[@charrizdomingo986]

Thank you I learned a lot from this series. Although I am having issues with my validating duplicate entries.

[@ashokanselliah9571]

Thank you very for this video series which is hugely helpful. Look forward more from you.

[@thiru0705]

Really nice and well-guiding tutorial. Mr Colin's lucid explanation helped a lot in understanding the subject matter.Thanks.

[@manzoorelahi89]

Hi bro all your video is too much helpful...thanks for sharing

[@thedatalabs]

Thanks for your feedback!

[@esperanza1951ful]

Gracias por tu genialidad.Saludos desde Argentina

[@AbhishekMishra-cr1tz]

Very useful video for me Thanks sir

[@amyroamyro8344]

you are the best!! mi pana.

[@honnurswamy6292]

Very useful this video for me....thanking you sir

[@hoangtung8080]

Very good, Thank you a lot

[@rotimioladunni7761]

I can't thank you enough. This is excellent. Why am I just seeing this. Please do you have structured training on Excel and VBA? I will appreciate your response as soon as possible

[@DavidBaird-p4z]

Hi Dilip, thanks you so much for sharing your wealth of knowledge. I'm wondering whether you might know why my PDF files don't appear in the folder until I publish another file to pdf

[@randyarmy03]

THANK YOU!!

[@leigionyt115]

Thank you for your valuable help but i want to ask you something. When i save the data how do i auto sort the list in listbox whenever i delete or add new entry based on column value.

[@arlenemayteodorodelcastill2690]

Hello! Thanks for this. BTW, Shall you make a tutorial on how to import txt file to macros database? Thank you very much in advanced! God Bless you!!!

[@primasshakya3650]

Hi thanks for the tutorials it was very helpful. One problem i encountered while validating is when i edit the record duplicated employee ID shows up. is there a way to turn off validation for employee ID if the records are edited?

[@saidaalebagonte3870]

Sir Dilip, just a verification regarding printing, can it print the whole record?

[@trueno7]

I am very grateful for your tutorials! Great work. How can I validate entries that are "blank" and outside of the dynamic drop-down list?

[@thedatalabs]

Thanks for your feedback! Please watch part 5 as well. I have covered the dynamic drop-down.

[@trueno7]

@@thedatalabs Sorry if I was not clear about my Validate Entries problem. I have reviewed all 5 tutorials several times. The validate entries function only works when an entry is blank (" "). The function does not work if the user manually enters a random character, such as X. How can I adjust the function code to continue working on blank entries (" ") and also validate entries that are not listed in the dynamic drop-down?

[@thedatalabs]

I got your question now. Please select the combobox and go to properties window. Change the 'MatchRequired' from False to True. This will result in an error message, if an invalid item is entered, and user try to leave the combo box. Apart from this solution, you can find the selected value in given range through VBA code and if nothing is found then prompt a message to user same as we are doing for others in validation. Hope, I answer your question. Thanks!

[@gokjohnny9581]

Hello, many thanks for sharing the tutorials to us. I have gone through your tutorials and use your teaching to construct my Data Entry Form. But I counter an error which is "Subscript out of range". I have no idea how to fix this error. This error happens when I insert the command "ThisWorkbook.Sheets("SearchData").AutoFilterMode=False" in Call Add_SearchColumn. I hope you can give me some advice

[@albyi1984]

What about the send button, where you want to send the form to specific person?

[@nunoalmeida4803]

Hello congratulations again for your Video it teach me a lot. Just one minor error in Function validateEntries() Set sh = ThisWorkbook.Sheets("Print") you have to change to: Set sh = ThisWorkbook.Sheets("Database") Thank you :) regards from Portugal

[@bkrljanac]

Correct is: Set sh = ThisWorkbook.Sheets("Database")

[@troy8618]

Thank you 😊😊

[@pravinkamble4431]

Hi, Can you help me to copy the data from the search frame? I can only select the single ROW and cant even copy it. Thanks in Advance.

[@normfikes547]

Thanks, see problem with saving getting Compile error "sub or function not defined" highlights ValidateEntries?

[@janmichaelabian343]

goodpm, sir, how can i add photo on this? i also watched your other video on how to add photo on the files but i dont know how to reflect the photo on the print sheet.

[@satthiababu3460]

Mind to teach me how get vlookup value to userform from closed workbook

[@channelseven3997]

Hi Thanks for this I used and addopt it to my business but the update is wrong now it updated to the first line .....I dont seem to see the problem ...can you help please

[@johng5295]

Thanks in a million. Great content. Awesome imagination. ❤️I subscribe❤️. Grade: A++💥

[@limitone9564]

Dilip, could you provide the code if I want to Print all employees that was hired on similar date and group them together by department, such as sales, operations, HR, etc. but it has to be in 1 print out sheet. thanks! I created my Userform and it works but just wanted the print out to be different. Thanks so much. I just need one sample syntax and I'll copy it for each dept. This can be on Part 6...

[@sanjeevchowdhry]

How can we force the user to enter names in initial capitals and also ensure ID does not take any character

[@hotlynx]

Hi, this is very nice, but if i want a calendar button with time so that the user can enter standard date and time, how to do it?

[@litzfigura8560]

Sir do you have data entry for using lending institution with 5% interest.

[@tonitoni9368]

Hello I have a question Would like to include submitted by and submitted on in the print ... is it possible?

[@hadinsha]

Great . Brother, how to prevent double entering a file.. once entired I'd can't be entered next time.. how to do that

[@premkumarofficialchannel4880]

Dim a As Long Dim lastrow As Long Dim i As Long Dim accno As String a = Application.WorksheetFunction.CountIf(NEFTDATA.Range("N:N"), frmformneft.cmbboxsenderac.Text) If a >= 1 Then accno = Trim(frmformneft.cmbboxsenderac.Text) lastrow = Worksheets("NEFTDATA").Cells(Rows.count, 14).End(xlUp).Row For i = 2 To lastrow If Worksheets("NEFTDATA").Cells(i, 14).Value = accno Then Worksheets("NEFTDATA").Cells(i, 15).Value = "'" & frmformneft.txtchq.Text End If Next 'MsgBox lastrow MsgBox "Cheque number Updated " Else Call chqnumberandacsave (function to add new data) End If

[@StiiNO2u]

please how do share vba userform with ohters remotely

[@jramilasan212]

Hi there Sir, Can we just show it in PRINT PREVIEW instead of printing directly. Thank you in advance.

[@johannnah4692]

hi, good day... can i ask a question.. How can i filter multiple columns?

[@johnmbugua7842]

Great content. Can you do one on multipages and multitabs?

[@tapan4253]

hello i need your help sir, how to make auto save data entry according to different customer sheet. how to do it?

[@thedatalabs]

Please watch this tutorial. Thanks! kzbin.info/www/bejne/m5nVeKmXp7ykn7s

[@kennychang2033]

Hi Thx for the tutorial. Super helpful can u help me to debug the following print VB script? It seems like there is an error to it.... sh.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & Application.PathSeperator & frmForm.txtName.Value & ".pdf"

[@RzeZniK2000]

Hello. Thanks you for the tutorial, and it worked fine until step 3. But for validation, i cant seem to get it to work, and you didn't show whether it worked or not at the end of the video either

[@ipupen1815]

Your tutorials are great! But the validate function particularly to validate duplicate records doesn't seem to work? Would greatly appreciate your help & guidance. Thank you in advance!

[@thedatalabs]

Thanks for your feedback! Please share the code here which is not working.

[@thebrotherstv3]

@@thedatalabs Thank you for this amazing videos. I have learn a lot from your video series. I Believe your validation duplication either doesn't work or I'm doing sometime wrong. example: I have enter a part # iin a textbox call txtPart and i want to check for duplication. After enter the part number into the database, i can still enter the same part # back into the database. If you can verify on your end and share with us the resule, that'll be great. Once again thanks for the AWESOME videos. code: Function ValidateEntries() As Boolean ValidateEntries = True Dim iPnumber As Variant Dim sh As Worksheet Set sh = ThisWorkbook.Sheets("Print") iPnumber = frmForm.txtPart.Value If Trim(.txtPart.Value) = "" Then MsgBox "Please Enter Part Number", vbOKOnly + vbInformation, "Part #" ValidateEntries = False .txtPart.BackColor = vbRed .txtPart.SetFocus Exit Function End If ' Validating Duplicate Entries If Not sh.Range("B:B").Find(what:=iPnumber, lookat:=xlWhole) Is Nothing Then MsgBox "Duplicate Part Number Found", vbOKOnly + vbInformation, "Part #" ValidateEntries = False .txtPart.BackColor = vbRed .txtPart.SetFocus Exit Function End If Private Sub cmdSave_Click() If ValidateEntries() = True Then Call Submit Call Reset End If Dim msgValue As VbMsgBoxResult msgValue = MsgBox("Are you sure you want to SAVE the data?", vbYesNo + vbInformation, "Confirmation") If msgValue = vbNo Then Exit Sub

[@JudgeKief]

Change "Print" to "Database" Set sh = ThisWorkbook.Sheets("Database")

[@karuppusamyn515]

I expected this one. 👍👍👍

[@PapaTVamb]

sir, when i search any entry. how it will be show in enter detail frame? and after that if i want edit , or print, then it will be edit print and save and when i press print it will be automatic save and print after edit.

[@faizprice5435]

Hi can you select the data row without display in the display box

[@thedatalabs]

Yes, we can but need to modify code accordingly.

[@baliongerewiong2194]

Hi, Bro thankyou for the video it help set some light on me, by the way do you mind setting up a tuitorial on how to run text across the userform as soon as the userform activates or initializes thanks

[@princeboadi7904]

thanks for the amazing videos. My concern is that when i use the "print feature" to export to pdf, it's the userform that gets exported and not the "print" worksheet created. what might be the cause? thanks you

[@ramisignals2720]

Super We need multi user form with multi sheets in one file For exmple user form 1 is the data for sheet number , userform2 is the data for sheet 2 We need to do 15 sheets and 15 user form in one file Search + save + printing + Reset+edit + delete buttuon for each user form and each sheet Itry this but i got conflict in modules please make some videos it will be help full Thanks

[@tnaisbit]

Excellent videos. I have created a userform to input details into a register of operatives when they attend site. The only issue that I have is one of my textboxes contain a duration in HH:MM. When the edit button is pressed it is displayed as a decimal eg. 5.55555555555556E-02 I suspect that the use of the following expression linked to the Command Edit button: Me.txtTravelTimeIn.Value = Me.lstRegister.List(Me.lstRegister.ListIndex, 11) needs to be amended Any tips?

[@woolim8791]

Hi, I really like your lessons. I have gone thru all the Parts series. I have one problem. I getting a duplication error while I edit an entry data. I even downloaded your original file, and run a test. Your file also shows duplication entries for the "Edit" function. do you have a solution for that? Data_Entry( "ID 123") -> SAVE -> EDIT -> Hold the same "ID 123" -> SAVE -> Validation for Duplication Entry found -> So I can't update an entry.

[@ankkitgarg55]

Hi, if I have to make a dynamic tab for numbers like 1-10 and if anyone is selecting 1 number then that dynamic tab will only show remaining 9 numbers. How can I put that in VBA form?

[@hilmansyahiran1228]

Hello sir... How do you print the listbox( that displays the filtered data)

[@hilmansyahiran1228]

Btw I got a mimatch error for the Print_Form part... It shows that I have mismatch error for my “ set sh = ThisWorkbook.Sheets(“Print”) but my sheet is already named as Print... could you help me with this error?

[@agony4446]

hi the validation in duplicate data is not working for me

[@ghariebkhalifa2340]

hi thank you so much for this video its really learning a lot i just having a problem with the line code for pushing out the PDF every thing is correct and still debugging can you tell me another way to do it thanks

[@BertDesplenter]

can this data entry form also be built for multiple users? ps: this series has already helped me so much! thanks!

[@thedatalabs]

Yes, but after making changes in coding. I have already uploaded a tutorial on Multi-user data entry form. Please watch. Thanks!

[@priya.8170]

@@thedatalabs which video sir that is pls tell me Multi user data entry form

[@fitzwarin9862]

Hi these have been great tutorials and have help me to learn excel. Is it possible to make it start up without showing excel behind the user form. I have also adapted it slightly to be an asset register for machinery. It would be very useful to be able to add details of faults but this would need multiple entries to the same ID and then print off a report for that particular asset. Is this something you could advise me on. Thanks

[@thedatalabs]

Thanks for your appreciation! User form can be opened in Full screen mode at the time of opening. Using the same code, you can create your form. Will upload the 5th part of Tutorial covering Full screen and dynamic drop-down. Thanks!

[@kamranmirzakhel5362]

@@thedatalabs Thank you Dilip Bhai I have learned alot and it really helped me. Could you please mention the date for part 5

[@abhishekdas8503]

HOW did u change the row heights from the odd nums to even in the start because it was way too fast

[@thedatalabs]

Just select the rows you want to change the height and right click on selected rows headers then click on row height and input the height there. Thanks!

[@abhishekdas8503]

@@thedatalabs Thanks

[@honnurswamy6292]

Can you add more titles in this form I mean aadhar no, pan no, date of joining, extra...

[@jamilasif7858]

Hi. Really superb tutorial. How can we make combo box flexible? I want to enter department name manually also as well as using the drop down option.

[@thedatalabs]

Thanks for your feedback! I have covered this feature in Part 5. Please watch. Thanks!

[@zeetz89]

Salute..... Everything working fine except the duplicate entries... It still records duplicate entries. I have tried your sample file and it's doing the same. Thanks

[@thedatalabs]

Thanks for highlighting! I will check it again and upload it after fixing the issue, if any. Thanks!

[@zeetz89]

@@thedatalabs sure sir

[@zeetz89]

Sir..Have you got any solution to the duplicate entries?

[@JudgeKief]

@@zeetz89 Change "Print" to "Database" Set sh = ThisWorkbook.Sheets("Database")

[@chadernestflores4685]

@@JudgeKief but then sir the edit function will not work because it will also detects that it is a duplicate entry when you save it.

[@effedoppiavu]

Really appreciate these videos and everything worked fine, however.. I have multiple cells in column B with three different values only. I've already done a custom sort macro to add into the userform, however, when I used an IF and SUBTOTAL formula for SER (Column A) relative to B's contents (to keep the order 1,2,3,4..etc regardless of sort method), Upon entering new info, the userform wants to add another entry under the end of the range where i've put the formula (which doesn't have any info in apart from the formulas in col A. which means when I sort, the SER number next to that entry doesn't employ the formula when I sort that row to where it should be. Could you help?

[@chessyman]

Great work! I like it very much. There ist still some error (also in the new xlsm on your website): After deleting a recordset, if then you edit or add a recordset, the serial.No. won't be unique. It's duplicated with another recordset, because a row is missing.

[@JudgeKief]

Change "Print" to "Database" Set sh = ThisWorkbook.Sheets("Database")

[@layzee98]

Hello, i have a problem with your App. Run-time error '1004': Retrieving the Match property of class WorksheetFunction is not possible. This is in: Module1 > iColumn = Application.WorksheetFunction.Match(sColumn, shDatabase.Range("A1:I1"), 0) I have changed nothing in your functions.

[@thedatalabs]

Please share the file. I wi check and get back to you. You can find the email id in description box. Thanks!

[@layzee98]

@@thedatalabs I sent an email. I am waiting for a response. Regards

[@salihch3135]

@@layzee98 did the issue got solved for you .? I am here with same issue .

[@NR-mh9zj]

Same issue, once u get solution, pls notify in comments.

[@troy8618]

Please can I link two sheets in the same workbook together so that entries from one sheet gets automatically updated in the other?

[@troy8618]

Please it feasible? Like one selected/entered data gets picked by another sheet automatically based on certain keywords in the same workbook ?

[@EduTechGyan]

Duplicate entry command is not working bro...please check it

[@mehuliroy893]

Hello Dilip. Your tutorials are really helpful, I am designing a similar data entry form for an Inventory Management System. So I have a question and a doubt. Suppose for a particular item, the quantity available in the inventory is 50, so whenever I will enter the quantity as 51, it should give me an error message like " Quantity you entered exceeds the limit". How can I check and validate this condition using code? Can you please help me out with this?

[@idelfkih]

Thank you very much for this great tutorial, can you please add code for multi criteria search and if possible change the textbox with listview in order to change the back color of specific row based on cell value

[@thedatalabs]

Thanks for your feedback! How many colomn do you want to consider in Multi-criteria filters?

[@idelfkih]

@@thedatalabs hello, I would like to search with 5 columns, and if possible how to change the textbox with listview to be able to change the row back color or text color based on a cell value. thank you

[@aquafina1974]

I have tried this form but it is accepting the duplicate ID also ...... it should give the error "Duplicate ID found but it is not showing"

[@19hael95]

When I delete data the S. No is not updating. I have 3 data 1, 2 & 3 and I deleted 2 and the number 3 should be the new number 2 right? But in your case it's not like that. What will you do about it?

[@satthiababu3460]

Same also.

[@ZepicSoundPH]

Thanks a lot 😊👍. Very useful 😉. One request, every time you input data, the order is descending. So that the last data entry shows first. And we will not always scroll down. How to do, the codes for this? Thank you.

[@VTrus]

Great tutorial! How can i open PDF file from the form, after i pressed the print button?

[@thedatalabs]

Thanks for your feedback! Please use Shell "program file path file path you want to open".

[@sagarpachpute8612]

@@thedatalabs can u provide code for ths

[@princeboadi7904]

@@thedatalabs Hi, Dilip anytime i use the print command to export to pdf, the userform gets exported to pdf instead of the the "print" worksheet what might be the cause? thank you

[@mohammedzafar8011]

Can Save and Print function be given to a single command button? If yes how.

[@thedatalabs]

Just call both the function on ckick event of a button

[@mohammedzafar8011]

@@thedatalabs Thank you.

[@alexvillagarcia7634]

Hello Mr. Dilip and Data Labs, My user form by referencing your coding are now being used by my colleagues. Hopefully you can share to us how to start coding using multipage in vba. My sincerest thanks in sharing your expertise. More power!!!

[@thedatalabs]

Thanks for your feedback! You can take help from this tutorial. I have used Multi-page control in complaint management project. kzbin.info/www/bejne/oYarhYKknL57apY

[@alexvillagarcia7634]

@@thedatalabs 🙏🙏🙏

[@basramalik2485]

What would be the code if we want to save PDF file at another place rather then excel file location

[@anshulgupta3735]

Hi! Thanks for amazing tutorial. I wanted to know how can I restrict user input in textbox such that it should be one of the data from a column of a worksheet sheet, or else it show invalid entry. Please help. Thanks in advance

[@alhassanmusah7242]

Please Sir Can you Update the employee ID So that it won't allow duplicate entering duplicate ID.. That will be very helpful if you could update so... Thank You

[@alhassanmusah7242]

Oh sorry sir I have realized that we have already validate duplicates

[@alhassanmusah7242]

Thanks a lot

[@shibilsnoopy3973]

Bro there is still one debug. If select search by and backspace click after enter search box names or number and click search. There is shown debug. So we can use if searchby blank search botton visible false please set code like this

[@محمدفضلاوي-ه4ز]

tanks for you

[@ruchikachona7026]

Thank you for these tutorials. They are amazing and helpful, I am new to VBA. I just have one problem and why is my code adding the first record after the headers and the second record after 7 rows, my table starts from AM9 and goes till AS9. Could someone help? May I send my code @TheDataLabs? When I debug my module, I get an error after the Validation saying: End With without With. I checked and my "With frmForm" statement is there.

[@thedatalabs]

Thanks for your feedback! It seems there is logical error in the code written for identifying the next blank row. Please post your code here. I wi go through and fix the issue. Thanks!

[@diya2909]

Dear sir as I requested you earlier that I am using your target sheet form..that data is transferring into respected defined sheets but in all sheets column no. O and q....I want to check the duplicate entries before transferring the data to the target sheets....one message come that respective sheets with cell address contains the duplicate entries...plz provide the code

[@diya2909]

One message should be come before transferring the data that respective target sheets contains duplicate data... Target sheet means I am using drop-down menu sheet1 ...sheets..sheets and so on

[@asadaleem6167]

Sir g, is there any video for a novice like me as far as coding is concerned??? Don't know abc of it. Thanks

[@thedatalabs]

I will try to start VBA from basic. That will take time. Please subscribe our KZbin channel and click on bell icon so that you can get notifications for that. Thanks!

[@shivannahr780]

Sir please invoice form how to creat next video

[@venugopal-pn9zt]

While printing the pdf file it is not creating the pdf file, (in the part 4 of the tutorial- Automated data entry form in excel, downloaded from your site ) and in the project created by me also. Can anyone help in finding a solution to the problem ? Thanks in advance. Error message is : sh.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & Application.PathSeparator & frmForm.txtName.Value & ".pdf"

[@premkumarofficialchannel4880]

use code Sub PrintToPDF() Dim fname As String Dim fpath As String fpath = "C:\Data\" 'fname = Format(Now(), "dd_mm_yyyy_hh_mm_ss") fname = InputBox("Enter Name of File to Create in format '' ", "Create File", "PDF" & Format(Date, "DDMMYYYY") & "01") ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FILENAME:=fpath & fname, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:=True End Sub

[@volkerdeck947]

Hi Dilip, first I wanna say thank you for your great tutorials. I learned a lot. Keep going. One question? Is it possible, to save the deleted rows in a separate worksheet, so that I have a history which rows have been deleted in the past. Thanks in advance

[@thedatalabs]

Thanks for your feedback! Yes, we can create a log for that. Even, this is the best practice which every software developer performs while deleting the data from database. We should also adopt this best practice while doing development. Thanks!

[@volkerdeck947]

@@thedatalabs Thank you very much Dilip. I understand that this is best practice, but when you have multiple user and you handle important data like employee details, it make sense that you see a history from deleted data.

[@rampels4948]

Agree with that.

[@zulfiqarsajan2084]

On Validate Print Details i am getting an error Compile Error End with Without With Pls Assist

[@moretttt]

The duplicate validation doesn't work. It works If I change the sh to Database instead of Print but it would give an error when editing an existing row.

[@JudgeKief]

Change "Print" to "Database" Set sh = ThisWorkbook.Sheets("Database")

[@superbok2]

The Data validation is not working, duplicate emp ID can still be entered and saved. Could you help in fixing this? thanks!

[@thedatalabs]

Would request you to download the file from link given in description box and match the code. If issue still persists then let me know. Will definitely provide support. Thanks!

[@superbok2]

@@thedatalabs The excel file from your link has an unspecified error so please check.

[@princeboadi7904]

set sh = thisworkbook.sheets("Database") it was erroneously captured as "print" so change that to "Database" and it will work perfectly.

[@kpccostales21]

Hellow Sir, can it be possible to put also a password or i mean an admin login password for the file....and a limited copy sharing of the file... i mean if the file reach 5 times copy or shared to others, it is possible that they can no longer open the file...thank you in advance....

[@phcybersoulcollect6878]

can someone help me, how to make if i click edit and save, save it another row..

[@samueldoe2544]

Frmform.show error.please help

[@sachin0200]

hello sir, i tried this code as example but error occuring--"unable to get the match property of the worksheetfunction class number ---run time error 1004" like this.. what i have to do kindly give any suggestion ?

[@thedatalabs]

The error is coming because there is a name mismatch between ComboBox and headers used in Database Sheet. Both list item of ComboBox and Header Name in database should have same spelling. Sequence can be different. Thanks!

[@sachin0200]

@@thedatalabs THANK YOU SIR, I CHANGED AS PER YOUR ADVICE, BUT STEAD OF RECORDS SHOWING IT DISPLAY NO RECORD FOUND, WHAT SHOULD I DO ? kindly solve

[@thedatalabs]

Please check the criteria used to filter the table. Thanks!

[@sachin0200]

@@thedatalabs ITS WORKING THANKS A LOT SIR,

[@sachin0200]

kindly guide the error sir, "could not set the rowsource property, runtime error 380"

[@sagarpachpute8612]

Some issue with Edit, it says duplicate ID If we edit and try to save the change

[@thedatalabs]

Please remove the duplicate validation while editing the record. Thanks!

[@sagarpachpute8612]

How to remove duplicate validation for Edit only as it calls save button and it validatesEntries so doesn't work

[@yarramkartheekreddy9163]

@@thedatalabs Hello Sir, even I'm facing the same issue as Sagar mentioned. Is there any solution for this specific problem?

[@chadernestflores4685]

Hi @@thedatalabs is there another way without removing duplicate validation coz it really helps a lot. I think it would be less hassle also. Thank you

[@emmanbacolong4806]

i have trouble in printing. an error occurs upon printing saying that documents not save. I already edit the print_form but nothing happens. need help please. THAn you sir

[@thedatalabs]

Please share the file. I will check and get back to you. You can find the email id in description box. Thanks!

[@sanjeevchowdhry]

Duplicate entries are being added and I dont know why. I have reconstructed the complete tutorial

[@sazibahmed4563]

Sir, not working print , run time error ('5') please help me. Take care.

[@sarahargrave4591]

did you get this figured out? I too have the same issue.