User To Edit Table/Forms

  • Thread starter Thread starter Kevin C. via AccessMonster.com
  • Start date Start date
K

Kevin C. via AccessMonster.com

I need to develop a form that will allow the User to edit table records. It
would be ideal if they could browse/edit the data in the tables, and be able
to design the forms.

The basis of this is that they want a working "rough draft" and later be able
to make re-design and changes as we see fit.

Any suggestions on the best way to create a form to allow them to edit the
tables and make simple design changes??

Thanks,
Kevin
 
Three answers in increasing order of how much I like them:

1) Write code that allows users to enter new field names and specify field
types etc. You could then add them onto tables by playing with tabledef and
field DAO objects (or by using SQL statements like ALTER TABLE) to actually
make those modifications to tables.

Writing a UI to allow users to recreating forms on the fly would be harder.
You'd need to be switching forms to design view, then using things like the
CreateControl command to modify controls and layout.

Trouble with that option is that you've basically just rewritten Access as
an Access mdb.

2) Send the staff on an Access training course so they can learn to do it
for themselves.

Trouble with that is that they'll probably mess things up and start adding
Contact1, Contact2, Contact3.... etc until you have to kill them.

3) Do step 2 and sit back until they realise they don't know what they're
doing. Then go down the sensible route of people having to ask you to do it
when they want an additional field.

(See commandment 1 here: http://www.mvps.org/access/tencommandments.htm In
my view that should actually be the first five rules at least. It's that
important. Deciding on table structures on the fly is a VERY bad idea and
will again lead you into having to kill the users.)
 
Back
Top