VBA Help

[mas1978]

Can anyone help me
I am new-bee in VBA just started using it
I am using MICROSOFT ACCESS 2003 to develop an application for credit Waiver Log Processing-for postpaid customers
And I am really having problems
I will try to explain the problem as much as possible
the credit application form-which has all the information of the customer
name address ID/Passport information mobile number telephone landline numbernumber of connections
Examples
Now there is a customer who files up a credit application form and has ten connections

so the table would look something like this
Credit-Application-no representing credit application number
User-no representing the number of connection

Credit-Application-NoUser-noCA-0011CA-0012CA-0013CA-0014CA-0015CA-0016CA-0017CA-0018CA-0019CA-00110CA-0021CA-0022CA-0023CA-0024CA-0025CA-0026CA-0027CA-0028CA-0029CA-00210

now the help part

as you see the table above which I made in excel not in access
CA-001 has 10 connections
CA-002 has 10 connections

when CA-001 reaches the last user-no which is ten(as shown above)
The user-no in CA-002 restarts numbering again
how will I develop this using VBA

please help

[stanl]

IMHO the surest way to tackle your problem is to develop a structure through some relational thinking...

1. You have customers
2. They have n number of connections.

One line of thought would be to develop 2 tables, 1 with customer information and either a UNIQUE customer ID number of a [yechh!!] autonumber field. Then a separate table related by that UNIQUE id called Connections which displays that information.

However, assuming the data is already in some sort of Excel format, then you would need a VBA 'parsing' routine.

Otherwise, I am sure others will chime in with better [or better extrapolated] suggestions.

.02 Stan