Microsoft Access Database for In-Process Run Charts

C

Cullet

#1
This may be a little off topic here, but I am developing a Microsoft Access database to collect weight data from an in-process scale to create run charts. I am having issues with VBA in getting the serial port communication to recieve data over the RS232 line. Does anyone have an Access database or Excel spreadsheet that already perfoms this function that they can post on here? I would prefer to see how the code works rather than go into details about how new and lost I am when it comes to Visual Basic. Thanks in advance if anyone can be of help.

Regards,
Cullet
 
Elsmar Forum Sponsor

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#2
Welcome to The Cove! :bigwave:

I would have expected more people to use Excel for this. Is there a reason you chose Access over Excel?
 

Marc

Fully vaccinated are you?
Staff member
Admin
#3
This sounds like a communications question/help topic. I'm sorry I can't help, but if I read you right you want something that will interface with a scale via the RS232 line ports.

You want:

Scale data output ---> <via RS232 line> ---> Computer -> Data entry in a database or excel.
 
C

Cullet

#4
That is exactly what I am looking to do. I already have a program that I purchased from the scale manufacturer that imports the data into excel. However, I created an Access Database that is more operator friendly and would like to be able to do the same thing (import data) into Access. I have looked on Visual Basic forums for help but thought that if someone on here already had a program that did this and was willing to post a copy, it would save me a lot of time and frustration. If not, that's ok, I just thought I would give it a shot.

Regards,
Cullet
 

CycleMike

Registered Visitor
#5
This may be a little off topic here, but I am developing a Microsoft Access database to collect weight data from an in-process scale to create run charts. I am having issues with VBA in getting the serial port communication to recieve data over the RS232 line. Does anyone have an Access database or Excel spreadsheet that already perfoms this function that they can post on here? I would prefer to see how the code works rather than go into details about how new and lost I am when it comes to Visual Basic. Thanks in advance if anyone can be of help.

Regards,
Cullet
What do you have for code so far?
 
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
J Microsoft Access Integrated Database Question - PPAP Module Software Quality Assurance 13
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
Q FMEA and Risk assessment in Microsoft Access FMEA and Control Plans 6
G Microsoft Office 365 Business plan questions Business Continuity & Resiliency Planning (BCRP) 10
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
Q 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, NADCAP and Aerospace related 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

Similar threads

Top Bottom