View Full Version : Is this possible ?


Fransdekock
06-30-2006, 08:11 AM
Can u create tables from forms! Letting user select what they need and then entering the data into it ?

Please let me know

Thx for any help

RV
06-30-2006, 08:55 AM
Definitely not a good plan.
Beeter to provide users with the ability to generate their own queries.
Although I wouldn't advise using Access ;)

If you persist, have a look at the Table Defs collection.
Also you'll need in depth knowledge of VBA.
And you'll need to find ways to ensure referential integrity.

RV

Pat Hartman
06-30-2006, 10:35 AM
If your users need to create tables on the fly, you need to rethink your application's design.