Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

required field error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jimmy - 29 Jan 2008 16:52 GMT
I had already imported my data into a table and created a form.  I realized
that I didn't require a certain field to be required until after the form was
completed.  Can I go back and change that?  It works when I add a new record,
but I need it to be required for all records.

Any help is greatly appreciated!!!
Olduke - 29 Jan 2008 22:40 GMT
> I had already imported my data into a table and created a form.  I realized
> that I didn't require a certain field to be required until after the form was
> completed.  Can I go back and change that?  It works when I add a new record,
> but I need it to be required for all records.
>
> Any help is greatly appreciated!!!

Open the table in design view.  Highlight the field in question.  Change
required from yes to no.
Jimmy - 30 Jan 2008 13:49 GMT
I already have it as a required field, but i changed it after i had created
the form.  If I add a new record the requirement is prompted, but for old
records it doesn't require that field be populated.

> > I had already imported my data into a table and created a form.  I realized
> > that I didn't require a certain field to be required until after the form was
[quoted text clipped - 5 lines]
> Open the table in design view.  Highlight the field in question.  Change
> required from yes to no.
excel/access-chump - 31 Jan 2008 20:15 GMT
Disclaimer - I do not "know" if this will solve your issue.  And I don't know
for sure that it will be safe. (I'm rather a newbie)
I "think" the issue is that you need to change the settings in on the table
as well as the form.
e.g:
Select "Tables" and choose the table the form is based on and open it.
When the table is open look at it in "Design View"
Select the field that you want to be "required" and in the "Field
Properties" change the "Required" option from "No" to "Yes".
It won't go into effect  until you save the table.
---! WARNING !---
Do not take this next step unless you have backed up your DB. (I had to
input a whole load of data again!)
There will be a message box that reads:
"Data integrity rules have changed; existing data may not be valid for the
new rules.
This process may take a long time. Do you want the existing data to be
tested with the new rules?"

You may get a message telling you that your data needs to be changed.
If not then it certainly will require the field wether data is input on a
form or in a table.

I am not sure if this will solve your problem but it worked for me on more
than one occassion.
Signature


-The Chump - Jason

> I already have it as a required field, but i changed it after i had created
> the form.  If I add a new record the requirement is prompted, but for old
[quoted text clipped - 9 lines]
> > Open the table in design view.  Highlight the field in question.  Change
> > required from yes to no.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.