 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / July 2007Autofill A Form?
I would love a little guidance here. I am trying to create a subform that when opened shows all the fields that need to be filled in. The two tables below are linkd to a QDAAssessment table (by QDAID), so I need a new form for each assessment. I have created two tables: ScorecardKPA - This is the list of 66 areas to be scored for each assessment Fields: WBS (Primary); Process; Mapping; Weight (this multiplied with the Score field in "ScorecardScores" give me a final score) ScorecardScores - This will store the scores Fields: ScoreID(Primary) Score; QDAID(link to project table); WBSID linked to ScorecardKPA I need each process to prefill on a form, so I can input a 1 - 6 score. From there it gets more complicated, but getting the darn form to autofill is what I am having trouble with right now. Angie, it's been several hours now without a response. I think your request is a bit confusing. It's difficult for me to see the table relationships. You mention a 'project table', but you don't describe it. The ScorecardKPA table - is that 66 rows or 66 columns? (Important question!!) How are the tables related in terms of one-to-many, many-to-many, etc? When you say you need a new 'form' for each assessment, do you mean new 'record'? In general, you can often create your subforms independently to get them looking like you want (complete with data) before you insert them into the main form. The main form's job is to specify a single QDAID for the subforms to use when displaying their data. UpRider >I would love a little guidance here. > I am trying to create a subform that when opened shows all the fields that [quoted text clipped - 14 lines] > From there it gets more complicated, but getting the darn form to autofill > is what I am having trouble with right now. Thank you! I have re-written my request. I hope it helps. I am trying to create a form that when opened shows all the fields that need to be filled in. It needs to be based on the rows in a table I have named “ScorecardKPA”, The data in “ScorecardKPA” is static and doesn’t change. It is actually the criteria we score each assessment against. I have created a table called “ScorecardScores” to save the actual scores in. Each project has one assessment completed, so I need to create a FORM to input the data and save the scores for each assessment. I have created two tables for the scorecard: ScorecardKPA - This is the list of 66 rows to be scored for each assessment. They consist of the following fields (Columns).: Fields: WBS (Primary); KPAProcess; Mapping; Weight (this multiplied with the Score field in "ScorecardScores" give me a final score) ScorecardScores - This will store the scores Fields: ScoreID(Primary) Score; QDAID(link to project table); WBSID linked to ScorecardKPA Project Table – Has all Assessment information. ScorecardKPA has a One to many relationship with ScorecardScores ScorecardScores has a one to many relationship with the Project Table. I need each process to prefill on a form, so I can input a 1 - 6 score. > Angie, it's been several hours now without a response. I think your request > is a bit confusing. [quoted text clipped - 32 lines] > > From there it gets more complicated, but getting the darn form to autofill > > is what I am having trouble with right now. I have an excel file showing what I am trying to re-create in access, I can send if needed. > I would love a little guidance here. > I am trying to create a subform that when opened shows all the fields that [quoted text clipped - 12 lines] > From there it gets more complicated, but getting the darn form to autofill > is what I am having trouble with right now. Angie, download this 2002-03 format db at http://www.dbtc.org/zipmdb/projectassessment.zip It's 3 tables, 2 forms, 1 query that I hope can get you started for your data input. UpRider >I have an excel file showing what I am trying to re-create in access, I can > send if needed. [quoted text clipped - 19 lines] >> autofill >> is what I am having trouble with right now. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.