• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

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
0
adamshields
Asked:
adamshields
  • 4
  • 3
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
try using the Find and replace

http://www.rickworld.com/download.html
0
 
adamshieldsAuthor Commented:
That is not a free solution.
0
 
Rey Obrero (Capricorn1)Commented:
did you try downloading?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
adamshieldsAuthor Commented:
Okay I didn't realize it was a trial. Okay so it found one:

Where would I find the:

Tables!Assets.ValidationRule

? so I can remove the value: [Retired Date]>=[Acquired Date]
0
 
Rey Obrero (Capricorn1)Commented:
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
0
 
adamshieldsAuthor Commented:
The only one I see is a validation rule requiring the date to be greater then a specific date...
0
 
Jeffrey CoachmanMIS LiasonCommented:
adamshields,

As far as I can tell you will have to either re-create this table form scratch, download a fresh new copy of this template, or try the 2003 version and convert it to the 2007 version if need be.
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?pid=CT101426031033

This is the reason why most developers *do not* use templates.
;-)

The Assets table is loaded with "Look-Up" fields.
These can be bad enough in-and-of themselves (http://www.mvps.org/access/lookupfields.htm), but to make matters worse, they are all hard-coded.

Many times a template is loaded with features you do not need, other times you spend more time adding in things that you need, that the template does not have.

A Contacts database can easily be made by yourself, with the help of the experts here.
;-)

JeffCoachman
0
 
adamshieldsAuthor Commented:
Probably right. I'll just try to hammer away at it, thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now