user design IDE

[iccsi]

I would like to have my application to let user design customer forms
just like MS Access form design.

I would like to know that I need create the table to store all
controls and properties on the form and create the forms using data in
the table and store the data after users finish design.


Please advise if I am on the right track,
Your information is great appreciated,

 

[John W. Vinson]

I would like to have my application to let user design customer forms
just like MS Access form design.

I would like to know that I need create the table to store all
controls and properties on the form and create the forms using data in
the table and store the data after users finish design.


Please advise if I am on the right track,
Your information is great appreciated,

Ummmm...

Why not teach the users to design forms using the Access form designer?

Anything you create would require a HUGE effort to replicate the functionality
that already exists. Sure, it could be done; it would probably need to be
modified every time Microsoft puts out a new release; it would be either less
complete than the builtin forms, or harder to use, or a truly enormous amount
of work to be both complete and more user-friendly than Access.

I'd just use a split database; keep the backend with the tables secure; keep a
basic template frontend secure; and give each user a copy of a frontend to use
as they see fit.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Jeff Boyce]

Not sure I'm understanding your goal ...

Are you saying you wish to (re-)create the Access forms design functionality
using Access? If so, why? What about having the users just learn to use
the Access forms design functionality?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Access Developer]

I will add my "Amen" to John's suggestion. I suspect if you had any idea of
the tens, perhaps hundreds of thousands of person-hours expended by truly
expert designers and implementers to produce the Access form-generation
mechanism, you would not even _think_ of re-doing that work... (even if you
had all the resources that Microsoft has, wouldn't it be intimidating to
think that it has taken them nearly twenty years to develop what you are
using today, using teams with multiple members, all of whom are very
accomplished at their job?).

If you do not want to have users creating forms in Access, you might look
into Microsoft's InfoPath as an alternative to allow users to create some of
their own interface.

 

[Mike Painter]

I would like to have my application to let user design customer forms
just like MS Access form design.

I would like to know that I need create the table to store all
controls and properties on the form and create the forms using data in
the table and store the data after users finish design.


Please advise if I am on the right track,
Your information is great appreciated,

I would argue this is not a job for Access and you should move to VB or C to
obtain these results.
As the others have pointed out, this could be done in Access but will
require a massive amount of work.
VB would make a lot of this a bit easier.

Renventing the ball bearing would be easier.

 

[iccsi]

Not sure I'm understanding your goal ...

Are you saying you wish to (re-)create the Access forms design functionality
using Access?  If so, why?  What about having the users just learn touse
the Access forms design functionality?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.








- Show quoted text -

Thanks for the message,
My original thinking is to protect my application and backend data.
There is a possibility user screw the application and data if I give
them the ownership of the application.

Thanks again, I understand it is better to use VB or C to compelete
the task,

Thanks millions,