Take database, copy & edit, have reports reflect changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've tried so many ways to alter a file (template) I downloaded from MS, but
I cannot get the data to reflect my changes.

I downloaded a home inventory database. I added Beneficiaries under TABLES.
This data is never a FIELD option when I'm in FORMS or REPORTS. How do I
get it to show under FIELD?

I've tried two different things with the database. In TABLES, first I tried
altering the databases there, but the reports wouldn't show my reflections.
It kept grabbing the data that used to be on the row instead of what I
changed it to. The second thing I tried was copying and pasting the tables.
I renamed them and tried to have the forms reflect the new tables. This
worked for some, but not all.

Help. What 's the best way to do this?
 
Most likely your FORMS and REPORTS are built on a QUERY, not your table.
Update the underlying QUERY to include the new field and then it will be
available in your FORMS and REPORTS.

Look at your form's Properties and see what the data source is.
 
I've tried so many ways to alter a file (template) I downloaded from MS, but
I cannot get the data to reflect my changes.

I downloaded a home inventory database. I added Beneficiaries under TABLES.
This data is never a FIELD option when I'm in FORMS or REPORTS. How do I
get it to show under FIELD?

I've tried two different things with the database. In TABLES, first I tried
altering the databases there, but the reports wouldn't show my reflections.
It kept grabbing the data that used to be on the row instead of what I
changed it to. The second thing I tried was copying and pasting the tables.
I renamed them and tried to have the forms reflect the new tables. This
worked for some, but not all.

Help. What 's the best way to do this?
Click to expand...

Open the Form or Report that's giving you the problem; view its
Properties. The first property on the Data tab is the Recordsource -
this will be a query selecting *some* fields (not the newly added
ones!) from the table.

Click the ... icon by the property, and a Query Design window will
open. There, you can add your new field to the list by just
doubleclicking it, or dragging it from the table icon to the query
grid.

Close the design window, accept Access' offer to update the SQL, and
your field should now be available.

John W. Vinson[MVP]
 
SEAN RICHARD MALLET,

18 Chalk Road,

Walpole st-Peter,

Wisbeech,

Camps,

Pe14 7pn.
 
Back
Top