Hi! I'm looking for any suggestion. I have a Quality Review Checklist that was under MS Word and planning to create a userform and a database for the information. But I'm having a hard time to configure on how the database looks like and Needs to roll up to one spreadsheet with results, including comments, filter by content manager. Please see attached file.
Thank you in advance!
Hi, I see you created the new thread.
I will take a look but just by reading I am almost certain you should combine this with either Excel or Access.
I would go for Excel because my Access knowledge is insufficient.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Ok thanks I already created the UserForm and I'll attach it later.
Here is the userform.. and I wanted to have 1 database for all the information key-in by clicking the submit button. and If its possible if I filtered it by Content Manager it will show all the information of the checklist. thank you in advance.
Yeah excel will do
I don't see any content. You have the form, you have the data, what's the issue?
I want to create the database for all the information pulled in userform. as you can see from the userform some of the checklist questions are quite big I'm not sure how to create a clean look database.
I suggest you use a worksheet for the questions, in the similar manner I did that for you in the multi userform file.
The questions sheet:
Column A the question identifier: P1Q1
Column B the question text corresponding to this question.
Then in the answers sheet (the database) you have to define columns for the to section of the form and after that the identifier as column header
In the rows below you can fill in the results.
That would be my idea of how I would approach something like that. Hope it helps you get started
Your userform looks nice but I would like to make a suggestion.
You should 'synchonize' the TextBox names with the ComboBoxes, Now Combox10 is related to TextBox11 and that happens with all.
Since you have 11 questions why not all set nicely?
Qusetion 1. TexBox1, ComboBox1
Etc.
Makes it easier to maintain and then you know directly which comment belongs to which question
Thanks sure I will update textbox name and synchronize with other objects.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks