reports do not update automatically after upgrade to 2007 from 2003

[doug]

I have just upgraded a database from 2003 to 2007. The database is
shared between three users on a network. Previously reports
automatically updated if a change was made to a table via a form. This
no longer occurs - I find that if I close all forms, and tables etc,
or go via report layout view it will update (although I am not sure
this even happens all the time). Any guidance would be appreciated.
Please note I am not a programmer and do not understand programming,
simply the fellow that created the data base about 6 years ago and
somehow it has worked very well over that period.

One other change I have noticed is that previously we could have a
form open and scroll through records quickly by holding the left or
right arrow down at the bottom of the form. This feature of quick
scroll seems to be no longer there.

 

[NetworkTrade]

I will hazard one guess that the report is not updating when the form is
still open due to what is called 'dirty' ...meaning that the table underlying
the form has not yet updated because the form is not yet done....so the
report doesn't get that latest info

it isn't a bug really but there is a behavioral difference sometimes between
versions on this.

if the report always works corrct after the form closes - that is most
probably the issue....and if sometimes the report doesn't always update check
to see whether you tabbed all the way thru a record...possibly closing the
form in an uncomplete state is preventing that record from being entered...

as to scrolling; not entirely clear what you mean; reports have always been
paged - you never could scroll thru them. But mouse wheel could be used in
Forms before and I think that is phased out in 07 as a default since many
times it was not wanted

as you are not a programmer - moving a database from one version to another
can/will have issues....so there is a fix but would be difficult to
layout/explain via this forum I think if you aren't comfortable working under
the hood....

 

[doug]

You are correct in that my tables are not updating when I change one
value or entry in a form. If I tab all the way through the form to
the next record the table does update. If I hit the save button (which
I think was not there in 2003) the table does update.

I make many changes to tables via one particular form each day and in
the past (access 2003) did not need to take either of these the above
approaches. It appears I need to modify either my tables or my form to
instruct the tables to update when a modification is made to the form.
Do I do this on the form field properties?

In relation to 'scrolling through records' I mean that previously I
could hold the mouse on the forward or rear arrow and the form would
quickly go from record to record to speed up the process to allow
these daily modifications.

 

[NetworkTrade]

search 'dirty' in this area or the forms or forms coding area.... you will
see many q/a on this

you can force the table to update by adding a bit of VB to an 'AfterUpdate'
event of a text box... possibly closing the form before making the report
is easier....more than one way to skin the cat and it depends on what works
for you....