Access Forms

[Azeez_Andaman]

Hi friends



Is there any way to create a form in memory which can be deleted subsequently without saving. i have planned to create a MDE. can i create a form through VBA coding in it. All the reader of this message are masters in access except me. so please help me and suggest a way to create a form in access MDE file.

thank - u in advance

[pbaldy]

I doubt you can in an MDE. Why would you need to? This type of question is often a sign of a non-normalized database.

[Azeez_Andaman]

hi PB
i have a MDB file in which i create a form for input and it is working satisfactorily. In MDB file user change the code at their will without my knowledge and the master copy which i am maintaining remains unchanged. if it is converted to MDE then i can prevent changing my code by the user. but in the MDE file the action generate error because the creation of forms in MDE is not possible. to tackle the situation i have tried to create the form in another database from the existing MDE it is possible but require elaborate coding to collect the information in the way what i am wanted. if any alternative way is available for creation of form in MDE 'say in memory' without touching the MDE then it would be i think will be the easiest way rather creating form in another MDB file. what you say. am i right...... If i am right, help me and suggest some alternative way to create the form in a MDE file.

OK .... thanks

[pbaldy]

But why must a form be created on the fly? I have no problem with the MDE; that's what I always give users. I've never had to create forms in code. I create it during the database design phase and then distribute it to users.

[Azeez_Andaman]

Hi PB - first thanks for responding so quickly

some information has to be supplied by the user. the list of questions are too large say about 65 or so but a user concern with 5-10 of them. if i put all the question in a form it will look very odd moreover more than one screen may require to cover all the questions which i do not like. to maintain the queue a form called masterform containing a list of all question with some other basic information has been created. user has to select the required question pertaining to him from the list and details of these questions are further collected at a later stage in the form created on fly on the basis of selections made in the masterform and displayed for the user to fill it. this is the reason for creating a from on fly otherwise a form can be created easily at design time. About 20 forms are already there in the MDB all are created at design time except the one which is based on certain data supplied by the users.

OK ... thanks a lot again

[pbaldy]

My gut feeling is that the questions could be presented in a subform or continuous form view, rather than designing a form on the fly. The user would select their questions and they would be flagged somehow (don't know your structure). Then they could be presented to the user. Maybe if you posted the db or a representative sample one of us here will have a better way to handle what you're trying to do.

[Azeez_Andaman]

OK PB
for the time being the problem may be treated as partly settled. i will submit a sample later.
however, can i change the color of an access command button on mouse hover or on click etc.

[pbaldy]

You can change the color of the font, but I don't think you can change the color of the button itself. A workaround I've seen used is to make the button transparent and change the back color of a label that sits behind it.

[Azeez_Andaman]

thank u very much pb

[pbaldy]

No problem.