Microsoft Access Integrated Database Question - PPAP Module

jkittle

Involved - Posts
#1
Is there any access people out that can help me? I'm trying to create an integrated database and I'm doing the PPAP module now.

I want to take all the information on the data entry form and create a report that I can print based on the "ID" number and have the same check boxes on the report and the ones selected for that record.

When I create the report none the check box fields transfer over as check boxes. I have tried to create the option list on the report but can't get them to tie back to the record.

Example: The form field “Reason For Submission” is an option group with 10 options that are stored in the table as a number. I want my report to show all 10 of the option heck boxes and show which one is checked based on what was checked in the entry form.

Any help would be greatly appreciated.
 
Elsmar Forum Sponsor
Q

qualitychic

#2
Re: Microsoft Access Question

Would it be possible for you to e-mail the files so I can understand it better? I'm more of a visual person......
 

Sunday

Involved In Discussions
#3
It seems that you are mixing data types. An option group saves the value of the chosen option in a numeric field. A check box is a logical value (boolean or true/false, yes / no). If you want to save which option was selected, create separate fields in your table which are Yes/NO types. Your form can then include VB code to set various logical values based on the state of particular fields (after update events).

A good Access reference book may also help you up the learning curve. Get your company to pony up the $$$...
 

Sunday

Involved In Discussions
#4
The other way to accomplish this may be by using a combo box getting its record source from a separate table of your 10 choices.
 

jkittle

Involved - Posts
#5
Actually the option groups are stored as numeric values. You can use a single check box as a "yes or No" value but when you create option groups you have to store them as number values. These are stored in one field in the table and you link the value back to the description of the option.

Anyway I know you can create reports that have check boxes or option groups that come up with the value checked as it was on the entry form. I'm just not sure how to do it.

The whole point is to create the report so when it's printed out it will look like the AIAG part submission warrant. I attached a strpped down DB version for review.
 

Attachments

Manix

Get Involved!!!
Trusted Information Resource
#6
Hi,

I have done this by creating an unbound option group to replicate what you have on your forms. Do this in the design view of your report. All you do then is change the control source of this combo to the field from the table you want to display the info. I have added this to your report for the material reporting option group and it seems to work, see the attached.

Hope that helps. Any problems, let me know.
 

Attachments

Last edited:

jkittle

Involved - Posts
#7
Manix,

When you up loaded your changes it saved the file as a ".rar" file.

I'm not sure what this file extension is but I can not open it with Access.
 

Manix

Get Involved!!!
Trusted Information Resource
#8
Apologies, I am in the habit of using WINRAR for all the compression I do! It is better than WINZIP and still allows you to open and create ZIP files. I recommend WINRAR to everyone, you tend to get a better compression ratio.

A Zip file is not attached above. Hope it does help!
 
Thread starter Similar threads Forum Replies Date
I How to build a Microsoft Access MDB Database for Document Control Document Control Systems, Procedures, Forms and Templates 6
T Microsoft Access Database to create a Simple Calibration Certificate General Measurement Device and Calibration Topics 6
P Creating a Traceability Database with Microsoft Access Document Control Systems, Procedures, Forms and Templates 7
C Microsoft Access Database for In-Process Run Charts Quality Assurance and Compliance Software Tools and Solutions 4
J Help with Microsoft Access ODBC Database Query Criteria Misc. Quality Assurance and Business Systems Related Topics 35
A Microsoft Access APQP type database for Process Flow, FMEA, Control Plan, etc. Quality Assurance and Compliance Software Tools and Solutions 44
J Microsoft Smart Art Turtle Diagram Process Maps, Process Mapping and Turtle Diagrams 9
M Informational Microsoft Built a Bot to Match Patients to Clinical Trials Medical Device and FDA Regulations and Standards News 0
J Microsoft Teams to manage Internal Audit System? Internal Auditing 3
D Microsoft Excel database to Stand-alone software Calibration and Metrology Software and Hardware 3
QSM_Rick Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
A Free software similar to Microsoft Project - Any suggestion? APQP and PPAP 5
Marc ASQ Linkedin Group - Microsoft Sharepoint discussion - June 2017 Quality Assurance and Compliance Software Tools and Solutions 0
Marc Microsoft to rip up P2P Skype, killing native Mac, Linux native apps World News 0
Marc Microsoft just bought LinkedIn For $196/Share World News 9
M Active X and latest update from Microsoft - Dec 2014 After Work and Weekend Discussion Topics 4
N Microsoft Word - How to make high-light go away after text is put in Excel .xls Spreadsheet Templates and Tools 5
B How to validate Microsoft Excel Spreadsheet Calculations for the Cpk value Capability, Accuracy and Stability - Processes, Machines, etc. 9
O Chi Square Normality Test using Microsoft Excel Excel .xls Spreadsheet Templates and Tools 2
insect warfare IRS pays Microsoft for Windows XP support After Work and Weekend Discussion Topics 2
Marc Microsoft to push out XP patch on March Patch Tuesday - 2014 After Work and Weekend Discussion Topics 19
V Alternative to Microsoft Office - Open Office vs. Google Docs After Work and Weekend Discussion Topics 26
Jim Wynne Have you tried Microsoft Windows 8? After Work and Weekend Discussion Topics 25
AnaMariaVR2 Guide to Microsoft Excel for Calculations, Statistics, and Plotting Data Excel .xls Spreadsheet Templates and Tools 11
M Microsoft Excel - Trouble with Auto-Entry of Dates Excel .xls Spreadsheet Templates and Tools 13
H 4.2.3 Document Control using Microsoft Sharepoint - Visibility of Draft Documents ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
L 21 CFR Part 11 Requirements - Microsoft Excel Add-on Functions 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 6
Q Looking for Microsoft Dynamics AX Training Videos for Inspection Journals Manufacturing and Related Processes 1
J Conditional Formatting for Microsoft Excel Excel .xls Spreadsheet Templates and Tools 2
Colin Changing the Colour of a Date in Microsoft Excel Excel .xls Spreadsheet Templates and Tools 4
X Microsoft Excel 2003 Formula Restrictions Excel .xls Spreadsheet Templates and Tools 9
michellemmm Pagination in Microsoft Word Documents Document Control Systems, Procedures, Forms and Templates 21
H AS9101D Microsoft Word Format: Worth It? AS9100, IAQG 9100, Nadcap and related Aerospace Standards and Requirements 2
Marc Microsoft Losing Big To Apple On Campus After Work and Weekend Discussion Topics 18
P Magic with Microsoft (things that could not be explained) Funny Stuff - Jokes and Humour 8
Marc Apple Dethrones Microsoft As World's Biggest Tech Company After Work and Weekend Discussion Topics 6
E Signature of Records - Microsoft Word forms Records and Data - Quality, Legal and Other Evidence 7
Claes Gefvenberg Microsoft Windows users: Which windows version are you using? March - April 2010 After Work and Weekend Discussion Topics 37
S Microsoft OneNote - Is anyone using Microsoft OneNote Quality Assurance and Compliance Software Tools and Solutions 13
D Microsoft Word problems Document Control Systems, Procedures, Forms and Templates 11
M Microsoft Sharepoint as Document Control Software - FDA Validation Requirements Document Control Systems, Procedures, Forms and Templates 15
Marc The Hidden Cost of Using Microsoft Software After Work and Weekend Discussion Topics 14
Stijloor Microsoft's Ballmer: Windows 7 is nearly final After Work and Weekend Discussion Topics 13
Coury Ferguson Bill Gates to step down from Microsoft After Work and Weekend Discussion Topics 8
A Fullscope with Microsoft AX ERP System Manufacturing and Related Processes 1
B UK standards body taken to court over OOXML (Microsoft's Open office XML) Other ISO and International Standards and European Regulations 6
GStough Microsoft InfoPath - Anyone Ever Used This? Document Control Systems, Procedures, Forms and Templates 7
Stijloor Microsoft Offers to Buy Yahoo for $44.6 Billion World News 3
L Pareto question Microsoft Excel Excel .xls Spreadsheet Templates and Tools 6
Jim Wynne Vista Deathwatch - Is the new Microsoft OS down for the count? World News 30
Similar threads


















































Top Bottom