Define and process 2 dimension array(s) on a form

[hunterjj]

Does anyone have any info on how to define & process 1 or more 2 dimension arrays on a form?

 

[BNPMike]

Access has a 2-dimensional array grid control called a datasheet. You can process data in datasheet controls using SQL and VBA. Presumably there is something else you were thinking about?

 

[hunterjj]

I don't know how to define and/or use a datasheet. Help, with an example, would be appreciated.

 

[BNPMike]

hunterjj

What have you used in Access so far?

 

[hunterjj]

In my main system, I have used:
4 Tables
Recordsets
6 Queries
13 Forms
Multiple Combo Boxes
4 Modules
Lots of Visual Basic statements
Some SQL Statements

 

[BNPMike]

So you obviously know what you're doing.

What I was trying to say is the ordinary access datasheet is in effect a grid control. A relation is in effect a two dimensional array and SQL is in effect an array processing language.

You can add to that general perspective the things that VBA can do with recordsets which it can create from its own arrays.

So the question is have you got a problem that won't fit into the standard datasheet processing structure?

 

[hunterjj]

I have not had any schooling on this. I just picked it up from examples of other code, plus I figured some of it out on my own. As I said earlier, I never heard of datasheet processing, and I don't know how to proceed without some kind of example(s).

 

[BNPMike]

hunterjj

Could you say what it is you want to put in your arrays and how you want to process it? That might bring forth some suggestions.

 

[hunterjj]

I am trying to come up with a program that will perform golf league secretary functions. My form would contain Name, Flight, Holes(1-18), Total, Handicap, and Net. I need this for as many as 24 golfers per page, and virtually unlimited number of glofers.