SBS - The best value in QMS software

Corrective Action Request (CAR) Form Examples and Discussion

E

Eaglekeeper

#71
Corrective Action Database

Hi! I'm new to the forums and was wondering if I could also get a copy of this database. If it's no longer available, can someone point me in the right direction??
 
Elsmar Forum Sponsor
R

ritamuse

#72
databases

joe and geroge


if you are still sharing the database can you please send me a copy

thanks

e-mail removed
 
Last edited by a moderator:
K

keithm696 - 2008

#73
Hi George,
I'd love to get a copy of your db.
Thanks,
Keith
e-mail removed
 
Last edited by a moderator:
K

keithm696 - 2008

#74
Hi Dawn,
May I get a copy of your forms. I've developed my own but would like to compare others.
Thanks,
Keith
e-mail removed
 
Last edited by a moderator:
G

Greg B

#77
mshell said:
This was exported from an access database. The fields are interactive and the CARs can be issued via e-mail. I had to save it as a pdf but you should be able to get the just of how it works.
Michelle,

We have a similar design but at the moment the CARs are separate 'Word' Documents on the intranet document system. People call them up fill, them in and then print them out. The form is then sent from person to person to complete. This has a number of problems such as: Who curently has the form? What is the current status of the form? The data has to be placed in the Database and this occurs several times thru the forms life as it is passed from person to person. It is a very labourious task and can result in long delays tracking info and it leads to a lot of doubling up for data entry (to the form and then the DB). I am looking into the 'Database pages' but have yet to work out exactly how to use them.

My basic design thus far (for CARs) is a Table and a linked query. A data entry form is built from the Query and a Report is designed around both. My biggest problem is that when I want to print individual reports (each CAR) I have to select 'Print - Page from Page to) otherwise every single CAR is printed. Do you have a Macro to print only the page being viewed?

I'm sorry if this is a bit of a mess. I have attached a Screen Shot of my reports in 'Print Preview' mode.

Greg B
 

Attachments

M

mshell

#78
Greg,

Do the following:

insert a command button on the form (in design view)
right click on the buton
select properties
choose the event tab
place your cursor in the on click box
click the button that has ... (visual basic will open)
paste the following text in the visual basic window

Private Sub print_Click()
On Error GoTo Err_print_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.PrintOut acSelection

Exit_print_Click:
Exit Sub

Err_print_Click:
MsgBox Err.Description
Resume Exit_print_Click

End Sub


This should give you what you want. If you have any problems, let me know and I will try to help you.
 
G

Greg B

#79
Thanks you

Michelle, :thanks:

You are an absolute champion. I don't know if this works yet but the fact that you offered to help is help itself. I'll get back to you late on how it went. I am currently working on some flow charts for Rachel.
PS. Hope the birthday went well.

Greg B :applause:
 
G

Greg B

#80
Michelle,

I tried the code and it came up as an error. I have attached some screen shots of the issues that arose and have included screen shots from my Forms Window and Reports Windows.

The 'Error' shows that ALL of my forms are included in the VB Code after I click on the button. Can you help??? :( :cfingers:

Greg B
 

Attachments

Thread starter Similar threads Forum Replies Date
E CAR (Corrective Action Request) Due Dates ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 17
R How many Corrective Action Request can be Issued by DCMA for a single issue? Nonconformance and Corrective Action 2
J When to Initiate a CAR (Corrective Action Request) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
S SCAR (Supplier Corrective Action Request) Timeliness & Issuance Supplier Quality Assurance and other Supplier Issues 3
N How Can I Respond to this SCAR (Supplier Corrective Action Request)? Nonconformance and Corrective Action 15
Q Inspector CA (Corrective Action) request Nonconformance and Corrective Action 12
Q Supplier Audit Corrective Action Request Responses Supplier Quality Assurance and other Supplier Issues 4
Mikishots How to handle CAR (Corrective Action Request) Scope vs. Timely Response Nonconformance and Corrective Action 9
Kronos147 Customer Request for Corrective Action - Responsibility AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
hogheavenfarm Can a company refuse a Corrective Action Request from a Customer? Nonconformance and Corrective Action 22
M Audit Interview as Evidence to issue a CAR (Corrective Action Request) General Auditing Discussions 13
C SCAR (Supplier Corrective Action Request) as part of NC/CAPA? Nonconformance and Corrective Action 3
N Combining Multiple CARs (Corrective Action Request) into One CAR? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 16
R To SCAR or not to SCAR (Supplier Corrective Action Request) Supplier Quality Assurance and other Supplier Issues 7
L Monitoring a Request for Corrective Action to a Supplier Quality Manager and Management Related Issues 5
S Supplier Corrective Action Request (SCAR) Ignored by Supplier ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
B Issue CAR (Corrective Action Request) When KPI Fails to meet Goal Quality Manager and Management Related Issues 8
B CAR (Corrective Action Request) from Management Review Meeting ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
T CAR (Corrective Action Request) for On Time Delivery Nonconformance and Corrective Action 7
C AS9100 Rev C Clause 8.5.2 - CAR (Corrective Action Request) Format AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 14
Q RCA (Request for Corrective Action) on an Information Transaction Process Problem Solving, Root Cause Fault and Failure Analysis 2
S Supplier Corrective Action Request (SCAR) vs. Corrective Action Request (CAR) Food Safety - ISO 22000, HACCP (21 CFR 120) 15
B Supplier Corrective Action Request (SCAR) - criteria Supplier Quality Assurance and other Supplier Issues 2
D NC (Nonconformance) on an Auditors CAR (Corrective Action Request)? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
A What do you call the person who is assigned a Corrective Action Request? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 13
K Corrective Action Procedure - Request for critics Food Safety - ISO 22000, HACCP (21 CFR 120) 3
P When is an issue a CAPA (Corrective and Preventive Action) request? Nonconformance and Corrective Action 6
L Corrective Action Request Assessment and Prioritisation Criteria - Practical Examples Nonconformance and Corrective Action 14
H Product Non-Conformity and Document Change Request Forms - Corrective Action needed? Nonconformance and Corrective Action 16
F Can we reply to a CAR (Corrective Action Request) without Root Cause? Problem Solving, Root Cause Fault and Failure Analysis 24
V CAR (Corrective Action Request) vs. PAR (Preventive Action Request) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
E Management refuses to answer Corrective Action request Nonconformance and Corrective Action 43
C RCA - Internal Audit Request for Corrective Action ambiguity Internal Auditing 4
Crusader Registrar CAR (Corrective Action Request) Trend Analysis Benchmarking 6
C CAR (corrective action request) report form for automotive application Nonconformance and Corrective Action 5
D Corrective Action REQUEST vs. Corrective Action REPORT Quality Manager and Management Related Issues 18
M Supplier Corrective Action Request-Seeking Example Supplier Quality Assurance and other Supplier Issues 4
K SCAR (Supplier Corrective Action Request) Major and Minor Classification Nonconformance and Corrective Action 4
H Customer Complaint leading to Corrective Action vs. Change Request Customer Complaints 20
M Request for Corrective Action Ignored by Supplier Nonconformance and Corrective Action 22
D What is the scope of a CAR (Corrective Action Request)? Nonconformance and Corrective Action 15
M Issue CAR (corrective action request) TO our Customer? Nonconformance and Corrective Action 20
A CAR (Corrective Action Request) form sans Cause analysis? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
T To CAR or not to CAR (Corrective Action Request) - Sales changing prices ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 17
A How to Write CAR (Corrective Action Request) based on scenario Nonconformance and Corrective Action 3
M Supplier completed CAR (Corrective Action Request) is unacceptable Nonconformance and Corrective Action 16
C Safety issue help - Request a Corrective Action (CA) for Safety Incident? Preventive Action and Continuous Improvement 9
J Internal Audit Corrective Action Request Form General Measurement Device and Calibration Topics 4
C Definition CAR - Corrective Action Request - What is the Definition of Definitions, Acronyms, Abbreviations and Interpretations Listed Alphabetically 2
R Car (Corrective Action Request) Responsibility - Manufacturer Per Avl Or Supplier Supplier Quality Assurance and other Supplier Issues 3

Similar threads

Top Bottom