Recent content by gimo2003

Minty, I have found a way to separate the main form from those TabCtls which are being locked upon calling the Lock Bound Controls of Allen Brown's code. I just put Tabctls into another form and put the cmdLock on that form to serve as the lock/unlock for tabctls. I put also a separate...

gemma-the-husky, I have already fix the problem on MouseWheel by removing the code in my program because of version conflict from access97 to access2000 .dll file is missing when the mousewheel code is called to run. Thanks for checking.

Minty, All mentioned problematic field names are declared in the table: Incident Report. Thanks for the visit.

gemma-the-husky, I've tried typing Option Explicit at the top of the code. This is the error I received upon compiling: Type mismatch: pointing to (hLib) of below code. I have already deleted from my code the MouseWheelOff to stop receiving previous error: missing .dll file. Public Function...

Minty, These repetitive calling codes here are caused by trial and error that I experimented to apply. I removed some codes here because the chat room limits character to post, so I just put here the codes that have errors. Field names are stored in one table and I tested it all by filling the...

mjdemaris, As you requested, here is the code of my program I am developing. If you will notice, I have changed the problematic field names mentioned above previous message into : [SEQUENCE OF EVENTS], [STATUS NORMALIZED], [STATUS BEING NORMALIZED], [STATUS UNDER SHUTDOWN], [OTHERS 2], [NAME...

mjdemaris, Hi I am back again, sorry late reply to you. In google, I have this program of Allen Browne about locking bound controls, it did the trick of locking the forms upon the opening of form, only the problem was it also included locking my subform in TabCtl. Still looking to fix this...

mjdemaris, Hi I am back again, sorry late reply to you. In google, I have this program of Allen Browne about locking bound controls, it did the trick of locking the forms upon the opening of form, only the problem was it also included locking my subform in TabCtl. Still looking to fix this...

Minty, I am still figuring out the problem, but still I could not lock these field names in the form: [SE] [SN] [SBN] [SUS] [OTH] [NM] [DP] These field names were already registered in the table, forms, queries, and in the report. Thanks for the visit.

mjdemaris, Thanks for your suggestions. Only these field names: [SE] [SN] [SBN] [SUS] [OTH] [NM] [DP] which I added along with other field names are not being locked upon the open form, they are already registered in the table, forms, queries and reports. I don't know why only these field...

Minty: Where do I actually put the code that you suggested? Is it in the property sheet of the form or on the property sheet of the problematic field names: [SE] [SN] [SBN] [SUS] [OTH] [NM] [DP] that I would like to put a lock every time I opened the form. Where do I exactly put this code...

To: mjdemaris, Before I was receiving error: missing .dll file, so what I did to eliminate this error message was to get rid of the code where the MouseWheel is located and it did the trick, every time I opened the program, the error message is gone. Thanks for your kind visit.:)

Hi Minty, Thanks for your visit. I tried to tag controls but still unable to lock those fields mentioned.:)

To: Gemma-the-husky, Hi Gemma-the-husky, I tried to put a breakpoint on the following disputed field names: [SE], [SN], [SBN], [SUS], [OTH], [NM], and [DP] and this is what I've got after F8: Compile error: type mismatch highlighting the code (hlib) from FreeLibrary(hLib): Public Function...

Thank you bob fitz for your quick reply. I will check where the error lies.