Dynamic Forms in Access '97 1

[cassie99]

Hello.

I am looking for code examples to dynamically create a form in access each time a table is updated by a user. Records may be added or removed from the table. Does anyone have experience with this? Thanks in advance.

Cassie

 

[WildHare]

Can you explain a little more why you want to dynamically create a form and in what circs you want to do this? And do you mean adding/deleting records, or adding/deleting fields?

Jim There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

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

 

[cassie99]

Each form contains a listing of skills (a check-off list) for a particular job role. Since the job role is not finalized, current skills may be removed from the form or new skills may be added (adding and deleting records). I would like to minimize the work that the admin. asst. needs to do each time skill requirements change. Thanks.

Cassie

 

[WildHare]

I think you may want to turn your view of the database a bit 'sideways' - rather than add a skill as a discrete field (which is what I think you're describing), use a skills table with records in it for every skill, and then use a query to build the recordset needed for a particular job. Then your form can map to the recordset.

IOW, what I think you have now is something like this:

Skills Needed:
----------------
SkillA : YesNo
SkillB : YesNo
SkillC : YesNo
etc etc etc

And what you want to end up with is this instead:

SkillsNeeded
----------------
SkillA
SkillB
SkillF
SkillG
SkillM

Do you follow what I'm saying, or is this totally offbase?

If you set things up my way, you can add and delete skills to the skills table, without having to redesign forms each time.















There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

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

 

[cassie99]

Actually, what you are describing seems to be what I am looking for. Do you have (or can you point me to) an example of this type of code. Thanks.

Cassie

 

[Quintios]

Excellent response Mr. Hare... You get a star.
Onwards,

Q-

 

[WildHare]

Cassie, I'm in the midst of about 12 things right now, just checking in here while I gnaw on some lunch, if I get time I'll try to put together a demonstration of what I mean...check here later tonight...

Quintios - thx for the star..I wish they were redeembable for cash...

Jim There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

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