Removing field from Access
I'm trying to remove all instances of a field from a Access database. If I add a new field to the table 'Assets' and try to save it prompts me saying "Could not find field 'Retired Date'". I then select I do not want to save the table and it will add the new field but something isn't right.
Secondly when I select the reports, 'Asset Details', 'Assets by Location', or 'Assets by Owner' I am prompted to enter 'Retired Date' when instead I would like the report to run based on selection from a drop down dialog box...
Thanks for any help you can provide.
db.zip
Secondly when I select the reports, 'Asset Details', 'Assets by Location', or 'Assets by Owner' I am prompted to enter 'Retired Date' when instead I would like the report to run based on selection from a drop down dialog box...
Thanks for any help you can provide.
db.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you try downloading?
ASKER
Okay I didn't realize it was a trial. Okay so it found one:
Where would I find the:
Tables!Assets.ValidationRu
? so I can remove the value: [Retired Date]>=[Acquired Date]
Where would I find the:
Tables!Assets.ValidationRu
? so I can remove the value: [Retired Date]>=[Acquired Date]
open table Assets in design view
select the field one by one to see which field is using that validation
in the lower part of the table window in the General tab
select the field one by one to see which field is using that validation
in the lower part of the table window in the General tab
ASKER
The only one I see is a validation rule requiring the date to be greater then a specific date...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Probably right. I'll just try to hammer away at it, thanks.
ASKER