The company I work for currently uses a number of excel workbooks for asset tracking, job reports, ect. This system is very clumsy and requires a bunch of redundant data entry. I started a pet project of converting all of our excel based paperwork to an access database to hopefully streamline work flow. I have access to an old .mde that I used years ago that does some of what I want. Particularly the trig functions I'll be going through below. I know what I am wanting to do is possible in Access, but because of the nature of the file I cannot break it down and reverse engineer it to suit my needs.
Right now, we are using an excel spreadsheet to make calculations based on new values vs the most current previous values.
Example:
BOLD = User input
Depth Length
450 -
526 76
584 58
665 81
The above example is much more basic than the result I am wanting, but the idea is there. What I'm trying to do is have a form that takes user inputs then writes them to a table (DEPTH, INCLINATION, AZIMUTH). Those values will then be used by VBA to calculate telemetry data to be stored in a table, then used again to update telemetry data and make reports.
So, lets say the job started at 450' an Inc of 2.3 deg and an Azm of 320.4 deg. We then got new data at 526' where Inc is now 4.8 and Azm is now 332.1. I need to be able to enter those numbers into their fields, click a calculate button and send those values to their table then run a VBA program to calculate new values tied to the new input data.
It is all hard to explain but if anyone wants me to send the excel file to give you better understanding of what I'm looking for, please just ask. Also, if you would like the .mde file to see a working example let me know but it was built on Access 97.
Thanks in advance for the help.