A Command Button to Open form in design View

Vista2007

Registered User.
Local time
Today, 11:52
Joined
Feb 26, 2007
Messages
11
Is it possible to click a button and have a specific form open up in design view. If so, can someone tell me how. I am not very good in VBA. Any help would great.

thanks
 
Thank you for pointing me in the right direction. I have another question if anyone could answer it for me.

Is it possible to give a user the ability to automaticly create thier own tables with a primary key, add column names?

Give the ability to add a column to an already created form?

thank you
 
Thank you for pointing me in the right direction. I have another question if anyone could answer it for me.

Is it possible to give a user the ability to automaticly create thier own tables with a primary key, add column names?

Give the ability to add a column to an already created form?

thank you

I think you need to rethink what you need to accomplish and such. The request that you just made is a very bad, I repeat, a very bad idea. You do NOT want the users creating their own tables, etc. Your database will become a horrendous mess, non-normalized (if it isn't already), and just plain a pain in the butt to maintain if this occurs.

Why would you want to actually do that, if I may ask?
 
I agree. do not give people the options to create tables. if tehy need a table. have them run in through u first. or your db admin whomever that may be. this is because like boB said, they will mess up your normalization.
leave the table design to the experts. not the users
 
thank you for the feed back and I agree 100%. As I read more and more on this no Access developer advise this approach. At this point I don't think I will. I will re-think my design. May I ask another question?

I have a table called Apps which just list applications names. Now for each application list in the apps table I have a separate table the list only the columns specific to that application and thier will be some that will be the same on all applications. How would I go about creating relationships between the apps table and the other tables that just list specific items.

thank you
 
Last edited:
Sorry, please look at my previous posting again. I edited the sentences and I how it makes better since.

thanks
 

Users who are viewing this thread

Back
Top Bottom