Update/Create Table From a Form

[c18rch]

Hi

I am trying to create/populate a table from a form based on data entered in that form.

ie. Data is entered into the form either by direct input or from data stored in table X, this data is then used to create/populate a new table with an unknown number of data points (this depends on what is entered in the form). The new table is then displayed within the form.

I am fairly new to access, is this possible? This is what I am trying to do:

Someone using the form will entere a start distance and an end distance and then the distance increments. The form will then calculate the data associated with each distance.
eg
Start 10
End 20
Increment 2

Data Produced:

10 a
12 b
14 c
16 d
18 e
20 f

Where a-f is the calculated data.

Cheers.

 

[ajetrumpet]

this data is then used to create/populate a new table with an unknown number of data points (this depends on what is entered in the form).

If the number of data points is unknown, how would you know how many fields to include in the table?

is this possible?

Depends on what data is going to be in the table. Are you going to want all calculated data in the table, or just the 3 fields (start, end, increment)?

Data Produced:

10 a
12 b
14 c
16 d
18 e
20 f

It would help if you had, say a maximum range that the lower bound number and upper bound number could ever span. That way you would know how many fields in the new table total you would need, maximum (if indeed you are wanting to store the calculations in the new table in the first place. Is this what you are doing?).

 

[c18rch]

Ideally I would not like to create a new table but to just display the calculated data in the form but I don't think this is possible. However I would like to display the calculations in tabular form.

A maximum and minimum range would be possible but this would be between 1 and 3500. If I created a table with this limit and someone chose a range of 100 to 500 say, wouldn't it display the the values for which no calculation was performed, ie; show unwanted data?

This is also the problem with doing it directly on the form. Wouldn't I need to produce 3500 display fields?

 

[ajetrumpet]

Ideally I would not like to create a new table but to just display the calculated data in the form but I don't think this is possible. However I would like to display the calculations in tabular form.

Might be possible if you can get the data into a temp. table first.

A maximum and minimum range would be possible but this would be between 1 and 3500. If I created a table with this limit and someone chose a range of 100 to 500 say, wouldn't it display the the values for which no calculation was performed, ie; show unwanted data?

Not really, as there are plenty of conditional statement possibilities to prevent this.

Here is what comes to mind when I think about doing something like this...

* Create a TableDef to hold the calculated data.
* Use a Loop to populate the recordset based on a mathematical expression (written with user-entered criteria - the variables)
* Once the recordset is populated with the user-entered criteria, pop open a report (or a form, if that's possible) that displays the results any way you want it.

How does that sound?