Recent content by Niel HS

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...

Hello Mote, Nice to know about you, i've some need your help. My Access Form has Pivot Chart but i've no idea how to lock and protect it from being editing or delete by user. Thanks and appreciated if you could help me on this. Thanks-Niel

I'm create pivot chart based on query, but i've no idea to protect the pivot chart view preventing user to delete the chart text like title or data value. Thanks - Niel

Somebody please need help if know how to protect and locked pivot chart view in access. Thanks, Niel

I just create Tab Group in Main Form which easy for me to insert many Tab Page i want as subform. You just have to drag and drop your form which you need as subform inside the Tab Page in your Main Form when in Design mode. Thanks, Niel

Pls help on how to lock Pivot Chart Form. Thanks, Niel

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

I've just try the code ==> That's Perfect Code...its block all the non-alpha characters in the first digit. Thanks so much to you stopher. You're the helper, GooD JoB !!

Wow...just have a time right now...and i have try the code which given by missinglinq that's worked :) ...awesome..thanks guys.

Yeah...Input Mask is only work for the Fixed Format Value. But the value which need to input are vary, the important thing is the value must start with character alpha the can be follow with any other characters. I'm glad if someone can help with some code to handle this situation. Thanks !!

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...

Anyone can help on this post...

Hello Guys, Anyone can help on this, i'm glad to wait for the good solution. Thanks, Niel

Thanks John, but I’ve no idea how to use it under Function code..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...

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...