Recent content by benzhu

Hohn, Pat - thank both of you. Summary - for my first question,: Tbl_A: Key / Element / etc Tbl_B: Key / Element ID / Date / Price for my second problem: Split into two tables, all static attribute remains in original table, and create second table like this: Tbl_c: key / Project_ID / Date /...

John: The following is my evolving problem. I have a normalized tables and relation setup, but as project moves on, find my set of table value changes over time: tbl_mine_project ... project_name (primary key as auto number) current_mineral_reserve ... other project atributes like grade...

What you means: The way I want to do is strictly programming domain - database theory does not deal with it, or out of scope?

John: Thanks for the reply. You provided a good 'standard' access solution. I am also interested if there is programming structure like following, how to make that fit into database world: Table_Element: Key Element_name etc Private key (pointing, access, querry to its own daily price...

I have a need to create these two tables: Scheme 1: Table A contains fields: Key / Element name / atomic weight / etc... Table B contains fields: key / Date (daily) / Gold price / Fe price / other commodity price of the day - all material i try to track.. Basically, Table B is the daily...

Thanks Pat - your suggestion is very helpful. Right now, I created redundant field to hold the redundant data to associated user input field. The actual data is calculated in control's after event - I probably change the update into form's before update event. As you mentioned for unbounded...

what really want to do is: Store the absolute value in table - the data has wide range, from 0.95 to 1e-15. Normal user experience is like this: 32%, 5 ppm, 10 ppb. Access can only display like: 0.32, 0.000005, 0.00000001 - it will be mess if I have to ask user input data like this. So what I...

here is data field: metal grade(absolute) unit(%, ppm and so on) unit symbo record 1 Au 0.0000012 0.0000001 g/T record 2 Fe 0.32 0.01 % Form...

the property -> Data -> there are two properties: Limit to List (Yes), and AllowValue List Edit( No )

Is it possible to bound form controls with record manually in visual basic? The access bound limited some functionality I need. For example, display modified data field, after change, write back in another calculated number.

As you suggested, the database store the grade and the unit in two seperated field. Now when display the rate, and the unit is displayed following the grade data like: o.10 %, or 0.000000021 ppm in second case, it will be hard for user to figure out how many 0s leading the number. So...

Here is the situation: A data field holding the concentrate values, which range from 20% (0.2) to few ppb (1e-12) - very wide range. I try to have user enter data in corresonding range: for example: in unit of %, or ppm, g/Ton... But like the database always store the consistent data without...