David-
When I have a form layout that I want to use over and over, I create a form called zfrmTemplate. I add a copy of all the standard controls that I want to use - including command buttons and any common code behind the the controls like Click for the command buttons or Before Update for the controls. Every time I want to build another form using the "template", I open zfrmTemplate in Design View and then save it as the name of the new form I want to build. Note that you can also select each control on the form and choose the "Set Control Defaults" button in the Controls group of the Design tab. If you set the defaults, you can also go to Settings / Object Designers and change the name of the Form Template to zfrmTemplate. Note, however, that this changes the name for ALL of your databases.
You can go to the Downloads section of my website:
Download the Contacts 2007 database, and you'll find an example zfrmTemplate there.
John Viescas, Author
Effective SQL
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
(Paris, France)
On Feb 28, 2017, at 5:59 PM, david.pratt@outlook.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
is it possible to add things like buttons to NORMAL and have them be part of any new form? I have not been able to do this.
What all can be included in NORMAL?
And what is a best practice for efficient working in creating new forms? What I am doing is completely tedious and there must be a better work method involving form templates.
__._,_.___
Posted by: John Viescas <johnv@msn.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar