Survey Form required fields

GraemeG

Registered User.
Local time
Today, 04:33
Joined
Jan 22, 2011
Messages
212
Hello,

I have survey forms with required fields.
When inputting the survey it never used to allow the user to save, create a new one or continue without inputting all the required fields.

However I have since been changing my forms adding fields in etc, and now this no longer works on some forms.
I have 5 forms. It works on 3 and not on 2.

The fields still have required next to them, but I do not know what I have done.

Any ideas would be much appreciated?

Thanks
 
Not having your file before us, we can really only guess, of course, at your problem. Are you absolutely sure that the records in the errant forms are being saved with some Required fields empty, or is your form simply closing without giving you the usual 'required field empty' warning?

My guess would be that on the errant forms you have used you used DoCmd.Close to close the form. This is the code used by the Command Button Wizard to accomplish this task up through version 2003.

It has long been recommended that the code

If Me.Dirty Then Me.Dirty = False

be inserted before using

DoCmd.Close

to close a form because of a bug that has been recognized in Access for years. When DoCmd.Close is used, Access closes the form regardless of whether or not a PK field or other required field has been left blank or validation rule has been violated! If one of these things occur, Access will simply dump the record, close the form, and not tell the user that the record has been dumped or that the Required field is empty!

If Me.Dirty Then Me.Dirty = False forces Access to attempt to save the record, and if a violation has occurred, will throw up a warning message allowing correction to be made before closing the form.

Linq ;0)>
 
Thanks for reply.
My file is to big to put on here as it contains 10806 records (512mb)
(I am using Office 2007)

I m not sure I get what you mean above.

I didnt use code in the forms other than calcs to work dates out.
I created tables with lots of fields and pre-popluated some (i.e addresses)
The rest of the fields are blank awaiting the surveyor to input them via the forms.

The forms were created by the wizard selecting the correct table etc.

It did work, and still does on some forms but not others, and I cant see a difference.

Because the forms show 10806 records the way I am noticing it doesnt work is by filling in one or two elements and clicking next record, and it allows me on some forms, but on others it pops up and informs what is missing that is required one by one.

Hope this is clearer
 
Thanks for reply.
My file is to big to put on here as it contains 10806 records (512mb)
Is that AFTER you have used the COMPACT AND REPAIR feature under the big round office button > MANAGE. AND then zipped up by right-clicking on the file and selecting SEND TO > COMPRESSED FOLDER? There's a good chance if you did both of those that your file would be much, much smaller and maybe able to post.
 
Ta.
I have deleted records anyhow for Security Reasons.
But I did what you said and it is now only 1.79mb.
Thankyou.

Now attached! Help appreciated.

Attached is an example of a daatabase for data collection onsite.
Once surveys are completed the surveyor syncs (extracts the data to a server folder and then they are uploaded into another main database).
 

Attachments

Users who are viewing this thread

Back
Top Bottom