Search results
-
N
Value followed by any number
Hello, I need some help to complete my below code. Private Sub SerialNumber_AfterUpdate() If Not (Combo29.Value = "965-1595-000" And SerialNumber.Value = Left("EMK5-", 5)) Then MsgBox "The Serial Number Must Start With Prefix: EMK5- then followed by any number!", vbCritical, "Redmond and... -
N
Protect Pivot Chart view from Edit/Delete
Somebody please need help if know how to protect and locked pivot chart view in access. Thanks, Niel -
N
How to Lock Pivot Chart
Pls help on how to lock Pivot Chart Form. Thanks, Niel -
N
Lock Pivot Chart
Hello All, I've create Pivot Chart, but i've no idea how to locked the Pivot Chart to prevent user edit and deleted. Need help how to lock the pivot chart in Access. Thanks, Niel -
N
TextBox Value start with characters letter/alphabet
My Form has 6 Text Box fields and just 1 of them need to set the correct value format. I just want to set it to make the prefix value to be as alphabet otherwise it will prompt message Invalid. I’ve try to use below code, but it just to allow first character to be as alphabet can’t vary, and... -
N
Form with TextBox = Value strat with characters letter/alphabet
Hello, I've access database with the Form has Text Box field need to validate the value, the users will only allow to input start with prefix characters letter/alphabet then follow by numeric, inversely will not allow. The digit number of characters letter/alphabet may vary as well as the...