Auto create records based on criteria using VBA

[un4given1]

Ok, here's the scenario...

Using Access...

A client will be making a set installment amount into an account each month. From that account certain fees will be debited each month. I would like to create a button that I can push that will automatically create a record for each scheduled installment amount. I have the tables set up, I just need someone to point me in the right direction for some code. Let me know if you need more information.

I would prefer to stay away from Macros if at all possible... I have heard they are a poor programming technique in Access. If necessary I will use macros until I figure out another way.

Thanks!

Here's a screenshot... maybe this will help... don't worry, the information on it is fake, so noone's security is being violated

So, the way this works... the client will make the "Installment Amount" each month for the length of "Program Months" Fees are scheduled as per the "Fee Schedule"

Edited April 10, 2006 by un4given1

[IcemanND]

so you want a button in the Fee Schedule bax that puts the schedule into a table for that customer?

[healydj]

As you've stated the issue, there are three pieces:

1) A client will be making a set installment amount into an account each month. It appears they do this though an interface you've created.

2) From that account certain fees will be debited each month. It's unclear why this is relevant.

3) Automatically create a record for each scheduled installment amount. To achieve this:

a. Use ADO in a module to create a command object whose ActiveConnection property connects to your DB.

b. Attach parameters to the command object's Parameters collection.

c. Assign values to these parameter objects, based on values from your user interface.

d. Execute an INSERT against the relevant table in your DB, populating the relevant columns with values from the Parameters collection.