I have a Microsoft Access Desktop application with a MSSQL back end.
The purpose of the application is to gather calibration data and to create a certificate (Word Document)
Previously the operator used the MS Access front end to enter the data but now the data is being generated from the machine into a CSV file and I now need a process that will open the CSV file and import the values.
The solution MUST be a desktop application using Microsoft Access with the SQL back end and VBA as the language inside the access application.
There are 6 types of machine so each type will produce a CSV file and the structure is fixed (it always comes out in the same order). Each type has around 30 values in each record. Each type has it's own SQL table so there is a table for type 1 and a separate table for Type 2.
The calibration file name will tell you the type and there is also a field in the record that will tell you the type of calibration.
The process is
the program will take a file from a predefined directory
The name of the csv file will determine the type of calibration
The relevant SQL table for that type is opened
The CSV data values are mapped into the SQL table and a new calibration ID is generated that identifies that new calibration
The new calibration ID from SQL is added to the CSV record to identify that that record has been processed
The csv file is closed and moved out of the folder for storage in a "completed" folder
at the end of the process the operation must be notified of all the new calibration ID for that run. This can be by email or any appropriate method as the operator has to check the calibrations and print the certificate.
This process must be able to run in batch mode so the for example a calibration run is done at 9am and 2pm each day and the new certificate numbers sent to the operator
There must also be a way to run it manually
There are also some common errors and I can provide the list and if an error occurs the operation must be notified and the process move on but it is important that the operator gets a message so they can manually correct the errors
Any questions please ask
I don't see this as a complicated piece of work so i don't need project managers or designers I just need a VBA / Microsoft Access coder
this is a private system that has customer data on it so i am not giving access for everyone. I will give access to one or maybe two contractors who can show they have a lot of VBA experience
Thank you and please ask any questions
Bu iş için 32 freelancer ortalamada $189 teklif veriyor
We have successfully finished over 520 projects in last 18 years. ID : 16787552 Greetings, We are interested to work on this project, please find my comments inline with yours, 1. Microsoft Access VBA MS SQL pr Daha Fazla
Hello, I have the good knowledge of Microsoft Access VBA MS SQL project . I have more than 5 years of experience in Database Programming, Microsoft Access, Microsoft SQL Server, SQL, Visual Basic. We have worked on Daha Fazla
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser Daha Fazla
It will be manual import by clicking. Please share the MS-Access file and CSV sample for review. Thank you.
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current " CSV file Daha Fazla
Hi I am interested in the project. I am an experienced MS Access application developer. I have developed many applications and have done many change requests here on freelancer. If interested in hiring me then ple Daha Fazla
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Daha Fazla
I am able to create online database so that multiple users can access into db and keep track. Now it will open the CSV file and import the values in DB. I have 7 years’ experience designing and developing Access databa Daha Fazla
Hello Omac , I have read your project description and understood your requirement. I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am ve Daha Fazla
I have over 24 years experience creating database applications in both MS Access and MS SQL. I also have over 20 years experience with ETL development for both. I know I can create the solution you require. Pleas Daha Fazla
Greetings, I'll be happy to assist you with this project. I have +15 years of Access/VBA /SQL experience and can will create a module in VBA along with a GUI form for the manual import process. Furthermore, this ca Daha Fazla
Hi. I can complete the project in 2 days. Can I use C# program to do the project? It will be a windows program.
Hi, I am a professional MS Access and SQL database developer with 5 years of corporate experience. I have gone through with all your points. I can assure you that I will meet your expectations easily. I am ready to Daha Fazla
Hi, I am experienced on Microsoft Access , Excel and VBA. I can start your job immediately also. Please contact me to discuss the project in details. Thanks
Hi, I can finish the required project in Access I have done many projects usin it plz send me more details