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.
0  1214  Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: BuddhaBuddy |
last post by:
Platform is DB2/NT 7.2.9
The table was created like this:
CREATE TABLE MYTEST (
MYTESTOID bigint not null primary key,
FK_OTHEROID bigint not null references other,
FK_ANOTHEROID bigint not null references another,
FK_LASTLYOID bigint not null references lastly,
unique (FK_OTHEROID,FK_ANOTHEROID))
|
by: Jan |
last post by:
Have an SQL create/import script. Running this on SQL would make it
create a table with some values. Can Access2003 somehow use such and
SQL script?
I went into SQL query view to try it out, but the amount of data was
too big to paste in according to Access.
Sample data:
--
-- PostgreSQL database dump
|
by: RadhakrishnanR |
last post by:
Hi,
By using VB6.0, I want to export database table data into (i.e based on the selected file type(xls or txt)) excel file or text file with a tab delimited text file.
My User interface has:
• Drop down list box contain list of data base table name.
• A path selection area, allowing the user to specify the filename, path and file type for the
export. This will incorporate standard Windows functionality for allowing the user...
|
by: RadhakrishnanR |
last post by:
Hi,
By using VB6.0, I want to export database table data into text file with a tab delimiter.
My User interface has:
• Drop down list box contain list of data base table name.
• A path selection area, allowing the user to specify the filename, path and file type for the export. This will incorporate standard Windows functionality for allowing the user to specify file type such as tab delimited text. The path will default to the xyz...
|
by: Matik |
last post by:
Hey,
First, sorry if this post appear twice, because, I can not find my post
recently send, trying to post it once again.
I'm out of ideas, so, I thought, will search help here again :(
I'm trying to prepare a view for ext. app. This is in normal cases very
easy, but what if the view structure should be dynamic?!
Here is my point (I will siplify the examples).
| | |
by: debi.robarts |
last post by:
Ok, in my database I have something like this:
Date One
# of Days to Next Date
These calculate a field "Date Two."
Because "Date Two" is an expression (calculated by the form), I can't
set the control source to save to a field in my table. How can I save
that value to my table?
|
by: Richard |
last post by:
Very typical normal data
Table One
------
One.OneID (PK)
One.Name
One.Description
One.TwoID (FK)
One.ThreeID (FK)
....
|
by: robertrozarioa |
last post by:
Hi ,
I am new to ACCESS.please help me out.
I am designing a database.I have 3 tables, and have 3 forms based to collect data.
1. Individual ( fields are Name, Email, Status)
Status is a drop down list having values P,PE,E
|
by: coldfusionstudent |
last post by:
i wish to show/appear and dissappear text box based on a the drop down item selected.
what do i have to add?
thanks
under Comm_DEV
drop down selection.
|
by: wboyd36 |
last post by:
Can someone show me an easy code snippet to help update a table based
on DDE data. Here is the "jist" of what I am trying to do..
1. Get stocks/options symbols from portfolio management systems
(complete)
2. Add these to a table (complete)
3. open DDE channel - Telemet Quoting system (complete)
4. Get prices (I can get prices, but cannot update all 1100 stocks/
options in the table)
5. Update 2 fields (bid and ask) based on the...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
