How to make a field mandatory

I get “reqd,” but is the word “message” followed by my actual message or does something go before the message? “4 and more text, and.” text with no spaces until the message suggests that there is, but what comes before “Please enter a sample number,” etc.
Click to expand...
Then as appropriate for each control (no quotes)

reqd,Please enter a sample number

reqd,Did this case originate from ECS?

req,Your momma wears army boots

etc. -
Not reqd,Please enter a sample number, or else
See the big red comma in the message? If you do that, the procedure will split it off.

OR
If you'd like to be able to use commas, then the separator needs to be a different character. I probably should have used the redirect pipe or tilde as nobody would want to put a | or a ~ in a sentence, right?
 
I copied in the code as a before update event on the form, and I put in reqd,Please enter a sample number in the tag property of txtSampleNo and reqd,Did this case originate with ECS? in the tag property of cboECS.

I tested the form with the same records with missing data I used the last time, and, unfortunately, got nothing. Where should I look for the mistake(s)?
 
I tested the form with the same records with missing data I used the last time, and, unfortunately, got nothing.
Click to expand...
I have no idea what that means. I think it would be best if you posted a db copy. Strip out everything that's private if it's not relevant. If you need to include data that is private, consider this code for obscuring it
https://www.accessforums.net/showthread.php?t=77482
 
Thank you very much. I'm attaching the db.

I'll be for a week away starting tomorrow. I'll check in again next Wednesday, 7/24.
 

Attachments

works for me, but I did make a few changes - one of which was to remove the save button embedded macro. You have a mix of code and such macros - better to have one or the other, I'd say. Under certain conditions, it wasn't going to try to save the form, so the form Before Update event would not run. Since you are off-line until Wednesday, I'll play around some more. Code has tons of compile errors.
 
Hi Micron,

I’m anxious to see the changes.

We put the save buttons in to reassure the users that their work was being saved. I can live without the Save buttons, but what would suggest putting in their place.

I’m surprised about the compile errors. It isn’t something I’ve experienced on this project.

Henry
 
Pat,
I'm unclear about how making the fields required in the table or populating them would help. That's where this thread started. I made fields required in the table, but the messages aren't helpful to users. I changed the required property back in the table and pursued making the fields required in the form.
 
I see the principle that it's safest to enforce data integrity at the table level. In this case, the application is only for data entry. We won't be importing data or running update or append queries--we download the data into an application we created in Excel for analysis, which also has data integrity checks.

My greatest concern is data-entry errors. We're using data validation rules for all the text boxes, and all the combo boxes are limited to their respective lists. Going over our data, the problem we discovered most recently was missing entries, which is the problem I'm trying to fix now.
 
Gina,

Thanks for the link.

At first I thought that I couldn't make Micron's code work, but I realized that I had to modify a record for it to kick in. I see how your code would do the same kind of thing: scroll through all of the controls, and for the ones with required, or reqd in the Tag property give an error message. I have a question, though: Where does the second piece of code, the one that begins, "If frmValidateData Then," go? Do I put it as an event for each control that I want to require? If so, which event?

Many thanks,

Henry
 
Gasman,

Thank you for the link.

I see where the code goes, but should the field be required in the table or the form?
 
hilian said:
Gina,

Thanks for the link.

At first I thought that I couldn't make Micron's code work, but I realized that I had to modify a record for it to kick in. I see how your code would do the same kind of thing: scroll through all of the controls, and for the ones with required, or reqd in the Tag property give an error message. I have a question, though: Where does the second piece of code, the one that begins, "If frmValidateData Then," go? Do I put it as an event for each control that I want to require? If so, which event?
Click to expand...

No, not on each control but *around* the code that takes you to a new record and\or closes the Form.
 
I have buttons for Exit, Previous Record, Next Record and Save. Does the code go around the code for each of these buttons? The code contains the line, "DoCmd.RunCommand acCmdSaveRecord." Does that invoke the Save button code? If so, I'm still unclear on where "If frmValidateData Then," etc. goes and how to wrap it around the code that takes you to a new record and\or closes the Form.
 
Okay, so you have a Save button then for sure it has to go there. As to your question, no that save line only ensures the values that have been entered are saved before it checks to make sure they are entered.

Now, as for your other buttons. If they can go to the Previous or Next record without hitting Save then it has to go there also, same for the Exit button I would put it there as well. In my case I have a Form for entering new which only has a Save or Cancel button. The Save will check for required data and the Cancel will remove the record. I do not put an Exit button on the Form as it will close after *doing its job* on Save or Cancel.
 
hilian said:
Gasman,

Thank you for the link.

I see where the code goes, but should the field be required in the table or the form?
Click to expand...

I tested it on the table.

Code: 
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Debug.Print "DataErr = "; DataErr
If Screen.ActiveControl.Name = "Newdate" Then
    MsgBox "Newdate is required"
    Response = acDataErrContinue
End If
Debug.Print Err & " " & Err.Description
End Sub

HTH
 
@Pat Hartman... if that reply was in reference to the code I provided it does not go in the Before_Update event, it would go on the Save button. There are only two ways out of the From I use Save or Cancel, no other way to close the Form.

If not referencing my code then *nevermind*.
 
@Pat,

While I would agree with you 99.9% of the time in the case that caused me to have to do something different I used this snippet of code. I am not disagreeing with you only posted the other way to *skin the cat*.

Let me also say in all the time I have doing this I only had to use that snippet 3 times. That should give you an idea of how often it comes up.
 
You must log in or register to reply here.

Similar threads

W
How to Populate a Control in Code and Make it Behave As Though Populated in the GUI
Replies
10
Views
505
arnelgp
arnelgp
D
Solved Setting a field to null on Dirty
Replies
7
Views
971
dullster
D
N
How to send filtered transactions in the MS Access Combo box with one Click
Replies
15
Views
865
Mark_
M
Q
Solved combo box after update event
Replies
17
Views
1,650
June7
June7
R
How do I save the layout of a subform after modifying it on the main form's on open event?
Replies
12
Views
1,100
RickSanchez
R

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom