updating a form

[Guest]

I just inherited a data base that will make my job so much easier, it fills
out forms and the database works fine, it's just that the forms are out of
date and I can't use it until the forms are updated, somebody please help,
sorry I'm new to using Access

 

[Guest]

When you say "out of date" what do you mean?

 

[Guest]

Smokeyhavoc,

It's hard to advise you based on what you've described. If you mean the
forms themselves, that is, their labels or headers are no longer appropriate,
click on the Form tab from Database view, click on the form, and press the
Design button to load the form in Design view. You can then move and change
labels as needed.

If, on the other hand, you mean the *data displayed on the form* is out of
date, we will need more information on your table structures and forms to
advise you.

Note that a form can either be Bound to a RecordSource, i.e., either a
single table or a query, or be Unbound. If it is Bound, it will normally
have Bound controls--textboxes, combo boxes, checkboxes, etc.--meaning that
if data is entered into the control, the entered value is saved to field to
which it is bound.

Moreover, as Access is a more complex program to master than its Office
suite-mates, I suggest you obtain a good reference book. IMO, after
understanding the basic Access objects--tables, queries, forms, reports, and
modules--the first topic to master is Database Normalization. See the
following links for further information.

ACC: Database Normalization Basics
http://support.microsoft.com/?id=100139
http://support.microsoft.com/?id=209534
http://support.microsoft.com/?id=283878

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genaccess/databasenorm.html

Support WebCast: Database Normalization Basic
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc060600/wcblurb060600.asp

Database Normalization:
http://burks.bton.ac.uk/burks/foldoc/35/28.htm

5 Rules of Database Normalization:
http://www.datamodel.org/NormalizationRules.html

"Understanding Relational Database Design" Document Available in Download
Center:
http://support.microsoft.com/?id=283698
http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"
http://support.microsoft.com/?id=234208

Fundamentals of Relational Database Design:
http://support.microsoft.com/?id=129519

Database Deisgn Principles:
http://msdn.microsoft.com/library/en-us/dndbdes/html/ch04DDP.asp


Hope that helps.
Sprinks

 

[Guest]

Sprinks,

The forms that are out of date have text that's embedded in to the form that
the db prints, it's not user entered. ok basicly the form has several field
that change when you enter data, unfortunatly what I need to modify isn't one
of those editable fields.
I tried going into the form but the design button is darkened, as well as in
most of the other fiews. the only one that the design button is active on is
the table view I think. Sorry, I'm not at work and I can't access this site
from the network there. thanks for the info.

Smokeyhavoc

 

[Guest]

Smokey,

If you cannot edit the form in Database view, it sounds like the database
originator has implemented Security, and that you do not have permissions set
in the workgroup file that permits you to edit forms. Contact your Sys Admin
to set up these permissions.

Hope that helps.
Sprinks