468,741 Members | 1,588 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,741 developers. It's quick & easy.

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
2 Weeks Ago #1
1 3109
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.
1 Week Ago #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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.