Hello,
I am starting over in my AFR System. How do I create a Form (to view from the AFRsInput sheet) from the AFRsDB (include all fields) and have a SubForm for parts assigned to the ID number (AFR#) ?
I appreciate any help or guidance,
FF
Hello,
I am starting over in my AFR System. How do I create a Form (to view from the AFRsInput sheet) from the AFRsDB (include all fields) and have a SubForm for parts assigned to the ID number (AFR#) ?
I appreciate any help or guidance,
FF
Okay so far I have a form for the fields in the AFRsDB. How do I make them fill with information?
Hi FredFarmer...
Kudos to you for starting over...
I suggest you start a new file...Don't make use of the existing file...
Copy the important info over...Make use of ranges not Tables...
Your Userform will need to have the same functions as your initial dropdowns on sheets etc etc...
Take it one step at a time and explain in detail what you need to achieve...There are other members who have not followed your posts so have no idea what is going on...
Look at attached...Will give you an idea of CombobBox population and Textbox fills with selection made...
Many other ways that one can do this too...
Also stick with the default names i.e TextBox1, TextBox2...You will see that it is easier to reference with code...
Glad you kept the boxes in same order as Columns in sheet....
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Sintek,
Thanks but did you see my latest file? I started a form layout but not sure how to populate the fields.
Yes I did...But as I mentioned ... your initilal file had drop down selections and input selections which your New userform does not have...The sample was to show you what you need to do to replicate that...
Afterall once all the fields are completed then you will be passing that info to the sheet...
Okay I get it now I think. The fields for drop downs need to be combo boxes not text fields. The fields like Warranty need to be check boxes.
Am I on the right track?
Yes...So Repairmen & Technicians combobox population will be like such...
Also...As you are wanting some kind of protection...Steer clear of any direct sheet contact...You can literally do everything through UserForm Interface...Please Login or Register to view this content.
Have your Buttons (menus) that are currently on a sheet as command buttons on another userform...And then call the different forms from those buttons...
Last edited by sintek; 05-16-2019 at 02:20 PM.
I inserted the module and checked the Repairmen and Technicians. There is nothing in the drop downs.
Not a Module...Paste the code in the UserForm itself...Double click on Form and paste....
And get rid of the Formulas in all the rows and rows and rows...Starting new...Start a new file!!!
Your current file has a lot of baggage....
Press Ctrl & End on each of your sheets and you will see how many unused rows you have...
Last edited by sintek; 05-16-2019 at 02:45 PM.
I added the other combo boxes:
Please Login or Register to view this content.
Okay I put the code in the right place. As far as the formulas I have it down to row 300 so the Search sheet will cover up to that many possibilities.
You don't need formula's....Make use of code to do everything...That way you will calculate per requirement...
In below...Remove red part...
Please Login or Register to view this content.
Okay I will need help with code for the Search sheet later of course. I want to focus on the form and subform for parts. I really appreciate the lessons.
Yes...baby steps...
When you start your next thread...Explain in detail what you want to achieve and always attach a sample file depicting your required results...
For this post...You assumingly want to populate your form then write the info to the sheet...
Get that done and then move to the next thread...
Yes I need to attach these fields to the AFR# which is the ID.
Is there code for the text boxes and check boxes like the combo box code?
You will have to explain in more detail what needs to happen....Your form has comboboxes which are selections and textboxes which are inputs...
This will give you an idea of how to get the completed form to your sheet...
There are other methods as well...
Please Login or Register to view this content.
@sintek
John MacEnroe quote "Man you cannot be serious !!!!
When you run out of fingers you can count on your toes.Also stick with the default names i.e TextBox1, TextBox2...You will see that it is easier to reference with code...
This chap has had the guts to come back from one beating.
Use meaningful titles otherwise everyone will again drown in another pool of mire.
torachan.
In the end it's everyone's own choice but personally I agree with sintek in this one
I'd rather like to populate 30 Labels with Columnheaders using Application.Index and a loop than having to write 30 lines of code using the 'meaningful' names of the Labels.
Also imho the risk of typos increases with the number of 'meaningful' names of objects.
But since this discussion is irrelevant to this thread it might be better directed to The Water Cooler as a seperate thread.
Last edited by bakerman2; 05-16-2019 at 06:13 PM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
@ the Non-Believers...
To each his own...I guess...I just prefer to follow the std 1,2,3...etc of life as it was intended...
And as bakerman2 says...to have to remember all the "meaningful names" one has allocated is a nightmare and opens oneself up to errors...
I personally don't want to have to try and understand why those specific names were used...Not to mention trying to make use of them in code...
Good morning Sintek,
I don't have my latest file with me but you mentioned I should start a new thread with details of how I want it. My vision is to have multi forms AFRsInput, AFRsParts, and one for reports. Does that make any sense and most important can it be done?
Hi Fred...I'm certain it can be achieved...Has this thread been solved...Or is there more you need to do...
I started with having a subform for parts too. I found that it is called multipage forms I think. So maybe I should continue with this one to get the information for the AFR from the AFRsDB sheet and the associated parts from the AFRsParts sheet. I should be back in a few hours on my other computer which has the file with the multipage form that I started.
Thanks
I did not realize your current time being afternoon sorry. It's 5:30 am here.
Time to quit sorry. I realize everyone here is busy and I cannot do this on my own so I will unfortunately throw in the towel.
Sorry I was having one of those days with frustrations and didn't know what to do. I welcome any help please.
Last edited by fredfarmer; 05-21-2019 at 06:39 AM.
I started with having a subform for parts too.For members this means nothing...You should be more clear as to what you want to achieve...Step by step explanations...We are not mind readers...Time to quit sorry. I realize everyone here is busy and I cannot do this on my own so I will unfortunately throw in the towel.
I welcome any help please.
I have been monitoring most of your posts from the start and still have no real idea what needs to be achieved...
Last edited by sintek; 05-21-2019 at 03:39 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks