[AccessD] Inserting a set amount of records into a table

John Clark John.Clark at niagaracounty.com
Thu Feb 10 14:03:35 CST 2005


I have been whipping up a db to track our routers and switchs, and where
they are wired to...eventually, I'd like to print a report that would be
a wire map for a given piece of equipment.

I've got it working pretty well, but I'd like to add one more thing
before unveiling it. I have a form where each record is a separate piece
of equipment, and a subform on this form, that will list all ports and
where they go. Currently I have to enter 24 records for a 24 port switch
and 48 records if it is a 48 port switch. I would like for it to
automatically add 24 or 48 records, depending on the value in the
numPorts field.

I have never done anything like this before, but I am thinking that I
will need some sort of FOR or DO WHILE loop that cycles through and
INSERTS a record until it reaches the value of numPorts. Is this the
gist of it? I really haven't worked with inserting records at all, so if
there is anything I should know here, I'd appreciate it.

Thanks

John W Clark



More information about the AccessD mailing list