I have an command button, when once selected brings up a inputbox to enter a date is it possible to :
1 - add an Calender to the Inputbox to be able enale the user to select a date instaed of typing it in. I am able to add a date picker calender to a date text field, however i do not know or if it is possible to do this with a input box
2- Once the inputbox appears a message is displayed "Do you wish to fill a cylinder for works order number:-0003102647000001
However i need to split the two numbers 003102647 and 000001. It should say "Do you wish to fill a cylinder for Works Order Number 003102647 and For Line Number 000001". How would i amend the following code to do just that, the coding i am using is
My Code:
InputBox("Do You Wish To Fill A Cylinder For Works Order Number:-" & [Works Order Number] & [Line Number], "Please Enter/Scan Cylinder Serial Number")
3- Also as the inputbox is asking for a cylinder number, the user has to therefore type an appropriate cylinder number to be filled, at the moment the individual can type in any cylinder number, but i would like the cylinder number entered to be validated against the cylinder master table, which is a list of all the cylinders avialable, how is this possible, would it be a select statment.
1 - add an Calender to the Inputbox to be able enale the user to select a date instaed of typing it in. I am able to add a date picker calender to a date text field, however i do not know or if it is possible to do this with a input box
2- Once the inputbox appears a message is displayed "Do you wish to fill a cylinder for works order number:-0003102647000001
However i need to split the two numbers 003102647 and 000001. It should say "Do you wish to fill a cylinder for Works Order Number 003102647 and For Line Number 000001". How would i amend the following code to do just that, the coding i am using is
My Code:
InputBox("Do You Wish To Fill A Cylinder For Works Order Number:-" & [Works Order Number] & [Line Number], "Please Enter/Scan Cylinder Serial Number")
3- Also as the inputbox is asking for a cylinder number, the user has to therefore type an appropriate cylinder number to be filled, at the moment the individual can type in any cylinder number, but i would like the cylinder number entered to be validated against the cylinder master table, which is a list of all the cylinders avialable, how is this possible, would it be a select statment.
Last edited:
