Problems in ACCESS 2007

K

kalman

2 serious problems i encounter . Any help will be wellcomed

11. I had a report based on a table.We decided to cancel 4 fields
from tableand I removed them from report and changed the table qury on
report - I checked the sql - everything looks fine. However when
trying tto exec the report I get " enter parameter value" for all the
fields I discard

2. I build again my db and get "RELATIONSHIP ALREADY EXISTS" even t
they do show up in relation design
 
U

UpRider

Number 1.
Open the report in design view.
On the ribbon select the DESIGN tab
Click 'GROUP and SORT'
In the dialog that displays, delete any lines with the old fieldnames.

Number 2
Need more explanation of the problem

HTH, UpRider
 
K

kalman

Number 1.
Open the report in design view.
On the ribbon select the DESIGN tab
Click 'GROUP and SORT'
In the dialog that displays, delete any lines with the old fieldnames.

Number 2
Need more explanation of the problem

HTH, UpRider








- Show quoted text -
Click to expand...

You were right - I took out the sort fields and everything ok
For 2 : I understand that if you change relationship you should do it
without data and the best will be to discard the envolved fields from
tables then build again with relationship - I had done it and it is
working

Thank you indeed

Kalman
 
Top