Tables

[RDiva]

Is there a function in Access which would allow field names in a table to be
created based on user input?

 

[John Spencer]

Nothing built in. It would require writing some vba code to do this.

AND it makes little sense to allow users to create/modify table structure.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[NG]

Hi RDIVA,

you can create such a function yourself in VBA using ADOX.

 

[RDiva]

I know very little VBA and am not familiar with ADOX.

 

[John W. Vinson]

Is there a function in Access which would allow field names in a table to be
created based on user input?

I agree with John (well, I usually do, it's a sensible thing to do!); this
sounds like a Really Really Bad Idea. Tables should be carefully designed to
be properly normalized; throwing them open to arbitrary addition of new fields
would very quickly give an unwieldy, unnormalized design.

What real-life problem are you trying to solve by doing this???

 

[RDiva]

John,

I have several teams which meet different times throughout the year. They
are required to track the attendance of each team member for each meeting
scheduled. There is no set day/time the meetings are scheduled and I was
trying to devise a simple form for each team leader to keep track of their
teams attendance without having to enter the dates multiple times and then
select each member each time for every date. My thought was if the team
leader was prompted for a date, this could become a new column and then they
could click which team members was present for that date (using Yes/No).
This may not be the best design but I couldn't come up with anything else
that worked.

 

[Douglas J. Steele]

You need three tables: one that has one row for each member (call it
Members), one that has one row for each meeting (call it Meetings), and one
that resolves the many-to-many relationship between those two tables (call
it MeetingsMembers)

Every time there's a meeting, you'd add a row to the Meetings table and then
insert rows into MeetingsMembers for each member who attend the meeting.