• Quick note - the problem with Youtube videos not embedding on the forum appears to have been fixed, thanks to ZiprHead. If you do still see problems let me know.

Need help with Access 2003

Linda

Former JREF Goddess
Joined
Jul 23, 2001
Messages
788
I'm having a major senior moment and can't remember how to add new fields to a form. I've added them to my table, but for the life of me, can't remember how to add 2007 stuff to my membership database. The Access help system is no help. And the one thing I remember about Access is how unforgiving it is, so I'm afraid to start playing around with it for fear of changing something I don't want to change and not being able to go back. Can anyone explain to me in simple, easy-to-understand language how to do what I need to do? All I want to do is add some fields to put in 2007 membership renewal info (date and amount).
 
I use Access 2000 but it should be about the same.

First I would make a backup copy of your database. With the database closed use Windows Explorer or similar to make a copy of the [database name].mdb file.

I'm assuming you are talking about a form within Access rather than a web form.
Open the database.
Open the form you want to modify.
From the View menu choose Design View.
Open the Field List if it is not already open. You can do this from the View menu or an icon on the Toolbar.
Drag the fields you want from the field list to the form and position as desired.
Save the form, or use File \ Save As... if you want to keep both original and modified versions.
Use Form View from the View menu to switch back to using the form.

Good luck!
 

Back
Top Bottom