VBA for Form Validation

F

freidaf

Registered User.
Local time
Today, 09:26
Joined
Aug 13, 2012
Messages
44
Hello,
I have a form which includes fields for a Machine Name (cboMachID), Activity ID (cboActID) and Total Items Processed (TtlItems).
I need to write a vba statement for the forms before update event that checks the following:
If Activity ID = “P” and Machine ID is not equal to (“F-123-D” or “F-45-D” or “ABC-D” or “EFGH-D”) and TotalItems = 0
Then display a message that you must enter TotalItems.
Thank you for your help.
 
This should get you started:

http://www.baldyweb.com/BeforeUpdate.htm

You'll have to repeat the machineID field and use AND

Machine ID <> “F-123-D” AND Machine ID <> “F-45-D”

Unless VBA supports IN(), which I can't recall offhand.
 
Thank you I appreciate your help. So something like this:

If cboActID = "P And cboMachID <>F-123-D And cboMachID <>F-45-D And cboMachID <>ABC-D And TtlItems = 0 Then
MsgBox "You must enter total items"
 
Yes, with quotes around the text values. Personally I like to disambiguate by referring to controls with "Me", but it should work as is. In other words:

Me.cboActID
 
If Activity ID = “P” and Machine ID is not equal to (“F-123-D” or “F-45-D” or “ABC-D” or “EFGH-D”) and TotalItems = 0
Click to expand...
I would suggest a schema change. Rather than having to hard code a list of IDs that will likely change, why not add a new column to the table that identifies the "special" IDs. That way it won't matter if you have to add more. You're just checking another column for True or "whatever".
 
Thank you Pat, that's an excellent suggestion because these Machine names are likely to change. Some will be added and others will be deleted over time.

It's nice to know more than one way of solving my problem. Your help is very much appreciated!
 
You must log in or register to reply here.

Similar threads

R
Closing all MDI child forms when Ctrl-F4 not available
Replies
6
Views
535
Pat Hartman
P
T
One form across multiple locations for medium enterprise size
Replies
4
Views
573
Pat Hartman
P
J
Solved Code Catalog for Access / VBA - Making Code Sharing Easy
2 3
Replies
50
Views
1,601
Pat Hartman
P
O
Need Help With Code VBA For FIFO
Replies
18
Views
759
CJ_London
C
C
Getting a write conflict
Replies
6
Views
270
ChrisLeicester
C

Users who are viewing this thread

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