D
Drew
Filter Data Base, explanation of what I am trying to build in Access 2002
What I have written in regards to tables I have completed, where do I go
next? I would like suggestions if what I have looks reasonable. I now would
like to build a form I guess that would allow me (Many) to enter data. I
would also like to lock this form so data can be entered but no one could
mess with the setup.
Tables & Fields, All dates to open on current date but, start Sept 2005. I
have info I would like to update once this is built. A 24 hour day is
midnight to midnight.
I would like when the data entry form is opened up that the date is always
current.
The table name in on the left and what is in the table is tabbed over.
Filters added to LDY (Lay down yard)
Date, Filters added
Filters added to LDY, This will add to Filters in LDY (6 numbers)
50 to 100,000
Filters at LDY
Filters in LDY (6 numbers) When the form is opened you could se the
current total
Removed LDY to Sea Can, This will add to Filters in Sea Can (4
numbers). A Sea Can is a big steel big as you would see on a ship.
NOTE: At this time I am not sure once we receive a new load of filters we
will be only using the lay down yard and do away with the Sea Can.
Filters in Sea Can
Filters in Sea Can (4 numbers) No more than 5,000
Date, current
Removed Sea Can (3 numbers) Usually 800, This will be the running
total filters removed to the field updated from below (Add to A-8, A-10 etc)
Sea Can to Field (3 numbers)
Add to A-8, a number here would give a date and number to “Removed
Sea Can†and update “Filters in Sea Canâ€. It would also show up at Table A-8
“Filters Addedâ€
Add to A-10, Same as A-8 (3 numbers)
Add to A-12, Same as A-8 (3 numbers)
Add to A-17, Same as A-8 (3 numbers)
Add to B-6, Same as A-8 (3 numbers)
A-8, Filters at Site
Date filters added to field
Filters Added, This will update “Filters at siteâ€
Filters at site (3 numbers)
A-8, Filter Skid Change; I have a lot here but I am breaking it up.
Date / Time filters were changed
113, Number of filters needed to change a set of used filters (A-12
filter change is 66)
Skid 1 ON, When skid 1 is ON then Skid 2 is OFF.
Start 1, Injection well totalizer start number (7), used to determine
barrels injected while skid was on line and how long filters are lasting.
Skid 1 OFF, Clicking this would allow,
Manual entry of “Finish 1†and once the ENTER key is
HIT, transfer it to “Start 2â€, Turn Skid 1 OFF & Turn Skid 2 ON.
NOTE: After the first “Start†entry it shouldn’t be needed to be entered
again as it will come from the “Finish†entry. It may be needed to be
adjusted in case of meters problems.
Subtract (113) from “Filters at site†and update “Filters at siteâ€.
NOTE: All totals to reset to zero @ Day end, Week end, Month end & Year end.
I will have to figure out a way to save this information year to year.
All totalizer figures to 7 numbers.
Update “Filters Used (D)†Day, on a bad filter day, filter skids could go
back and forth several times.
Update “Filters Used (W)†Week at well site
Update “Filters Used (M)†Month at well site
Update “Filters Used (Y)†Year at well site
Give “Total Barrels 1†Total barrels injected while Skid 1 was on line.
Update “Total Barrels (D)†Day at well site
Update “Total Barrels (W)†Week at well site
Update “Total Barrels (M)†Month at well site
Update “Total Barrels (Y)†Year at well site
Skid 2 ON, When skid 2 is ON then Skid 1 is OFF.
Start 2, Injection well totalizer start number, used to determine
barrels injected while skid was on line.
Skid 2 OFF, Clicking this would allow, Entry of “Finish 2†and once
the ENTER key is HIT, transfer it to “Start 1â€, Turn Skid 2 OFF & Turn Skid 1
ON.
Up-date rest same as Skid 1.
NOTE: I will build below after A-8 is working. How do I build something that
would allow me to simply add a new site as below? All sites are the same
except A-17.
A-10, same as A-8.
A-12, same as A-8.
A-17, the only difference with A-17 is it has 3 skids of which 2
could be on line at once.
B-6, same as A-8.
Disposal Totals, Day_Month_Year. Information from each disposal well would
update here.
Update “Filters Used (TD)†Day from all disposal wells
Update “Filters Used (TW)†Week from all disposal wells
Update “Filters Used (TM)†Month from all disposal wells
Update “Filters Used (TY)†Year from all disposal wells
Update “Total Barrels (TD)†Day from all disposal wells
Update “Total Barrels (TW)†Week from all disposal wells
Update “Total Barrels (TM)†Month from all disposal wells
Update “Total Barrels (TY)†Year from all disposal wells
Later in a “Reports†I would like to Graph in MS Excel the (D), (W), (M) &
(Y) of each well and the (TD), (TW), (TM) & (TY) of all disposal wells.
Add in comments box for;
Pigging program (when the pigs are sent). pipeline cleaners
Corrosion & Chemical dosing rate..
NOTE: I know the above seems like a lot but it will be very useful in
diagnosing problems in the process.
What I have written in regards to tables I have completed, where do I go
next? I would like suggestions if what I have looks reasonable. I now would
like to build a form I guess that would allow me (Many) to enter data. I
would also like to lock this form so data can be entered but no one could
mess with the setup.
Tables & Fields, All dates to open on current date but, start Sept 2005. I
have info I would like to update once this is built. A 24 hour day is
midnight to midnight.
I would like when the data entry form is opened up that the date is always
current.
The table name in on the left and what is in the table is tabbed over.
Filters added to LDY (Lay down yard)
Date, Filters added
Filters added to LDY, This will add to Filters in LDY (6 numbers)
50 to 100,000
Filters at LDY
Filters in LDY (6 numbers) When the form is opened you could se the
current total
Removed LDY to Sea Can, This will add to Filters in Sea Can (4
numbers). A Sea Can is a big steel big as you would see on a ship.
NOTE: At this time I am not sure once we receive a new load of filters we
will be only using the lay down yard and do away with the Sea Can.
Filters in Sea Can
Filters in Sea Can (4 numbers) No more than 5,000
Date, current
Removed Sea Can (3 numbers) Usually 800, This will be the running
total filters removed to the field updated from below (Add to A-8, A-10 etc)
Sea Can to Field (3 numbers)
Add to A-8, a number here would give a date and number to “Removed
Sea Can†and update “Filters in Sea Canâ€. It would also show up at Table A-8
“Filters Addedâ€
Add to A-10, Same as A-8 (3 numbers)
Add to A-12, Same as A-8 (3 numbers)
Add to A-17, Same as A-8 (3 numbers)
Add to B-6, Same as A-8 (3 numbers)
A-8, Filters at Site
Date filters added to field
Filters Added, This will update “Filters at siteâ€
Filters at site (3 numbers)
A-8, Filter Skid Change; I have a lot here but I am breaking it up.
Date / Time filters were changed
113, Number of filters needed to change a set of used filters (A-12
filter change is 66)
Skid 1 ON, When skid 1 is ON then Skid 2 is OFF.
Start 1, Injection well totalizer start number (7), used to determine
barrels injected while skid was on line and how long filters are lasting.
Skid 1 OFF, Clicking this would allow,
Manual entry of “Finish 1†and once the ENTER key is
HIT, transfer it to “Start 2â€, Turn Skid 1 OFF & Turn Skid 2 ON.
NOTE: After the first “Start†entry it shouldn’t be needed to be entered
again as it will come from the “Finish†entry. It may be needed to be
adjusted in case of meters problems.
Subtract (113) from “Filters at site†and update “Filters at siteâ€.
NOTE: All totals to reset to zero @ Day end, Week end, Month end & Year end.
I will have to figure out a way to save this information year to year.
All totalizer figures to 7 numbers.
Update “Filters Used (D)†Day, on a bad filter day, filter skids could go
back and forth several times.
Update “Filters Used (W)†Week at well site
Update “Filters Used (M)†Month at well site
Update “Filters Used (Y)†Year at well site
Give “Total Barrels 1†Total barrels injected while Skid 1 was on line.
Update “Total Barrels (D)†Day at well site
Update “Total Barrels (W)†Week at well site
Update “Total Barrels (M)†Month at well site
Update “Total Barrels (Y)†Year at well site
Skid 2 ON, When skid 2 is ON then Skid 1 is OFF.
Start 2, Injection well totalizer start number, used to determine
barrels injected while skid was on line.
Skid 2 OFF, Clicking this would allow, Entry of “Finish 2†and once
the ENTER key is HIT, transfer it to “Start 1â€, Turn Skid 2 OFF & Turn Skid 1
ON.
Up-date rest same as Skid 1.
NOTE: I will build below after A-8 is working. How do I build something that
would allow me to simply add a new site as below? All sites are the same
except A-17.
A-10, same as A-8.
A-12, same as A-8.
A-17, the only difference with A-17 is it has 3 skids of which 2
could be on line at once.
B-6, same as A-8.
Disposal Totals, Day_Month_Year. Information from each disposal well would
update here.
Update “Filters Used (TD)†Day from all disposal wells
Update “Filters Used (TW)†Week from all disposal wells
Update “Filters Used (TM)†Month from all disposal wells
Update “Filters Used (TY)†Year from all disposal wells
Update “Total Barrels (TD)†Day from all disposal wells
Update “Total Barrels (TW)†Week from all disposal wells
Update “Total Barrels (TM)†Month from all disposal wells
Update “Total Barrels (TY)†Year from all disposal wells
Later in a “Reports†I would like to Graph in MS Excel the (D), (W), (M) &
(Y) of each well and the (TD), (TW), (TM) & (TY) of all disposal wells.
Add in comments box for;
Pigging program (when the pigs are sent). pipeline cleaners
Corrosion & Chemical dosing rate..
NOTE: I know the above seems like a lot but it will be very useful in
diagnosing problems in the process.