Geting large amounts of data from database

[Tom123456]

Hello my problem is that i have a database with two tables and I want to read the information into textfields in a form. The tables is of the following form: 10 rows with four columns and I have 10 x 4 textfields named col1, col2... How do I get the information into the textfield in an easy way? (I don´t want to make a query for each cell), can I use some sort of array and ask querys at each column? How? please help.

- Tom

 

[WildHare]

Hello my problem is that i have a database with two tables

That's not your only problem. You appear to have tackled this situation as if Access was a spreadsheet, e.g.

The tables is of the following form: 10 rows with four columns and I have 10 x 4 textfields named col1, col2...

This is either the wrong design for this situation, or you need to move all this data into Excel instead.

However, before we get into all that, you might also be missing an important point.

You can build a query with all of your fields (all 40 of 'em) and then place those fields on a form. The form will display the actual table values for each field.

I'm not sure, but it LOOKS like you're not clear on the connection between table fields and controls on a form. This is in addition to your other possible mis-steps in design. We can help, but you might need to give us more information on the functions and process of this data.



Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[Tom123456]

I have a probelm with continous form that makes me to use this solution, the table looks like this:

Nr Product Info
1 phone 3G
...
10 cable TP


I want the product with the Nr=1 to show in the textfield product1, product with Nr=2 in textfield product2...

Each time a enter new data the table is deleted so the table ALWAYS contains 10 rows.

I don´t want to query the database for each textfield, can i use an array to put it in, like SELECT Product FROM Table WHERE... and THEN put it in the textfields.

This solution is not a good one but i solve another problem with this solution.

Hope this clearify things.




- Tom

 

[Tom123456]

someone ?

- Tom