Home
Creators
Search Recent Random
Posts
Search DMs Popular Hash Lookup Tags Random
Importer
Import FAQ
Register Favorites Keys Review DMs Logout
Community
Telegram ThePornDude
Home Creators Posts Import Register Favorites Logout

Drag & Drop Form Builder Update [Gold & Silver] (Patreon)

Published:
2022-11-21 12:15:00
Edited:
2022-11-21 23:30:00
Imported:
2026-06

Downloads

Content

Hello Members!

In this week’s Feature, Fix, or Focus, we take last week’s Drag & Drop Form Builder training.

Here are the updates I made for this training:

· Document Attachments & Preview requested by Larry Duffie

· Edit Drop Down List added by Randy Austin

Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.

Files

Comments

Larry Duffie

Thanks Randy. With tinkering with this I can see this program having a part 2 and even a part 3. Great stuff here.

Excel For Freelancers

Thanks so much, Larry. Absolutely, there is so much potential in this style of application development. We are just getting started..

Larry Duffie

I did figure out why it would not allow me to drag a field. I am using excel 365 on windows 11. Any spreadsheet not created by you now you have to right click on the file and go to properties and under General at the bottom is a checkbox to unblock macros. Under older versions and windows 10 seems like you did that when asked when you open the file. I saw another member having same issue as me.

Larry Duffie

Have not been to the website in a while. Do all from Patreon. Thanks

Silvana Marques

I would love to see that Attachment Part 3 using the feature you have in the Drag & Drop show the file instead of a Thumb Picture you have in Part 2.

Larry Duffie

Anyone else have issue when you clear the form and try and Add back fields? I cannot add Filter

Excel For Freelancers

Hi and thanks Silvana, thanks very much. I will certainly make that part of a future training. This one has the best of both worlds because you have the thumbnail here and a double click on the thumbnail will open the document. I hope this helps and thanks so much.

Excel For Freelancers

HI Larry, thanks for your comment. I found a few issues on the clear form macro which was not updated to clear the document details. I did not find any issue with the Filter after that. Please download the updated version within this post in which I have just updated. Thanks so much

Pedro Martinez

Hi, I'm a new member, download the file, and same as Larry, I encountered a few bugs: 1. Once I clear the form, create a DB, and add fields the Search populates only the Search by and Type, not the results, furthermore, when I click on the "Type" field to select from the dropdown I get the following Run-time error'13': Type mismatch. 2. Document Field, I can name the label, and select the file but won't upload it Run-time error '1001': Cannot insert an object ( a few times the error number was 1004) 3. With a Cleared form & data / (added new database), I don't get an edit button for the dropdown list, I was able to see the edit button on the original Excel before I cleared the form. Note: I downloaded the form several times. Thank you

Excel For Freelancers

Hi Pedro, great to have you here and thanks. I have tried to duplicate your error on the latest version but I am unable to recreate it. Try using search by 'Type' and display the Names. Also check the DB to make sure each item gets a record ID. When you get the run-time error, what is the cause of the issue on what line of code? Edit button only appears on Drop Down type fields and no other typs, so you would have to add another drop down type field to see the edit button I will also update the code to remove the Edit button on any Filter By or Search By drop down lists. this should only appear within the form, and not on Search By or Filter By (those type of drop down lists can not be edited) Within the CheckForValidation macro I have added If ActiveCell.Validation.Formula1 = "=Fields" Then Exit Sub This will make sure that the edit icon does not appear in the Search By or Filter By drop down lists I have now updated the file right here in Patreon I hope this helps and thanks so much.

Larry Duffie

What version did you do this on Randy and what version are you running Pedro?

Excel For Freelancers

I am using the latest version of Excel for this however it should work on any version of Excel

Pedro Martinez

I really appreciate your help. Everything worked out perfectly except for one bug that I encounter before and is still giving me problems. When I add a document field, it loads great, everything is fine, and the search by and filter list works fine, the moment I decide to remove the document field, pressing "X", leaves behind the "X" and folder icon (only visible when I press the cell where it was located prior to deleting), and the search by and filter list stops working for numbers only i.e. instead of returning a 39 the search by returns nothing and the Filter list returns a date 2/2/1901 the Document Field error is: For DBCol = DelDBCol + 1 To LastDBCol FieldStrng = Left(.Range(Sheets(DBName).Cells(1, DBCol).Value).Name.Name, 9) 'Field String .Range(Sheets(DBName).Cells(1, DBCol).Value).Name = FieldStrng & DBCol - 1 Under the Sub RemoveField(). Thank you

Pedro Martinez

Hi Larry, sorry I did not see your question. I'm running: Microsoft® Excel® for Microsoft 365 MSO (Version 2210 Build 16.0.15726.20188) 64-bit

Excel For Freelancers

HI Pedro, make sure you download the updated file, When i remove the document fields in my test, everything is cleared. I hope this helps and thanks so much.

Pedro Martinez

Interesting, I downloaded that file about 4 hours ago. I think it would be a great idea to have an indicator on the updated file i.e. a date/time stamp, otherwise, I would anyone knows which one is the most recent.

Tony Murgatroyd

Hi Randy, is it possible to have a customisable free text field? Maybe with the ability to specify double width, word wrap and a scroll bar? Thanks.

Excel For Freelancers

Hi Tony thanks so much. Scrolling comes only with objects on or off userforms, however this a cell-based form. It would be possible to do larger cells however once you merge cells it becomes quite complex. With that said, any cell can increase its row or column width and also have a word wrap. Thanks for the great suggestion