471,049 Members | 1,545 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Data entry

Hi,
I trying to make a message box appear if field of <quantity> exceeds the <required quantity> field, I would also need that the quantity entered is allowed.
intention is to show that user has exceeded the required quantity...but still allows him to do so.

Using Access and VBA to do this, but the below will not accept number higher than the boxes remaining.
Private Sub Quantity_Change()
If [Quantity] > [Boxes_remaining] Then
Cancel = True
MsgBox "Quantity greater than remaining boxes", vbInformation

End If

End Sub
Jul 9 '21 #1
1 3811
priti9525
1 Bit
1.Data entry is the inputting of data or information into a computer using input devices, such as a keyboard, scanner, disk, and voice.
To get a data entry job and perform well, you need to be proficient at typing and type at least 50 to 80 words per minute. Some data entry positions may require a typing speed of over 80 words per minute. Being proficient at typing means you can type with minimal grammar and punctuation errors.
Data entry is a job where an employee inputs data into a computer from forms or other non-electronic forms of data. Today, many online data entry jobs available require the employee to enter the data into an online database.
Jul 15 '21 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by | last post: by
reply views Thread by tamilan71 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.