AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, January 20, 2005

How to hide procedure in library MDE

Visual Basic has a procedure properties dialog, which Access does not have. But following trick helps to make a procedure hidden:
Export access module to text using Application.SaveAsText hidden method, add attribute after procedure declaration as:
Attribute ProcName.VB_MemberFlags = "40"
Where ProcName is a name of procedure. Now import back module using LoadFromText.

2 Comments:

Blogger Yair Rubin said...

Hi Alex.
I tried it on MDB and it didn't work. When opening the module, the procedure doesn't show but it also doesn't compile and the procedure can't be called.

3:46 PM  
Blogger Alex Dybenko said...

Hi Yair,
on what Access version you are trying this?

10:06 AM  

Post a Comment

<< Home