Delete Form MVP/ Access Eng

  • Thread starter Thread starter 1aae
  • Start date Start date
1

1aae

Thank you
I have a form I want to let user delete this form with out access to my VBA
code so I have secured my application with VBA Password. User can’t delete
the form and this message appear
===========
Microsoft Access
This Visual Basic for Application Project has been protected with a
password. You must supply the password in the Visual Basic Editor before you
can perform this operation
===========
I want give user ability to delete the form but without accessing to VBA
Code or Window this very important
Any help
 
Assuming that there's VBA code associated with the form, I don't believe
what you want to do is possible. On the other hand, it strikes me as an
extremely unusual requirement. It's very rare that you let your users have
the ability to change objects in the application. Why not have a flag stored
in the database to indicate whether or not to use the form, and put logic in
your form's Load event to check whether or not it should be used?
 
I have change my Idea to delete object (Forms)
I will use macro CopyObject to copy tables to (Upgraded database) and I
don't want know to delete forms
Thank you
 
It's a much better idea to split the tables with data and relationships into
a "back-end" database, linked from the "front-end" database (queries, forms,
reports, macros, modules). That way you can work on a development copy of
the "front-end" and just replace the old front-end when it is ready, without
jumping through hoops to copy / replace objects, as you are doing.

Larry Linson
Microsoft Access MVP
 
Back
Top