Ability for user to create a "custom" form during runtime.
I'm trying to puzzle a way to make this work. I'm not sure it's even possible and if it is, not easily done. But anyways here it is:
The database I've been working on is a type of auditing software. Several forms (audits) are available and the user simply runs through the fields, pretty much just answering yes or no along with some specific data. There are only eight audits at this time and usually it would never be more than 10 at one time and at least two of those audits would change.
The idea is that all of these audits are disabled at the end of their period but the data remains for report creation. The old audits can be reinstated at any time.
What i'm trying to puzzle out is a way that the simple user could create a new audit without having Access knowledge. I'm talking something that would probably be more suited to a Visual Studio project. The ability to add controls (with hard-coding behind the scenes to determine their position in the form), simple comboboxes to determine if the created field is required or not, some logic matters such as if one field is "Yes" then another field is disabled, the creation of a new table for that audit to hold it's data, the creation of a query to edit the data, and the creation of a report to show all of that data in a user friendly way.
Is what I'm asking, beyond the scope of Access or just not worth the trouble, and simply creating new audits and the VBA programming behind it, SQL statements, rowsources, etc.?