By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,952 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Unhide Module From Code

P: n/a
I have a module in one of my Access DB that is hidden. I'd like to keep
it hidden but I'd like to use AutoKeys to run code to unhide it. I know
how to use AutoKeys, I just don't know how to set the attribute of a
hidden module to unhidden via code. Is it possible to do this?
Jan 13 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
yes. take a look at the following, as

Public Sub isToggleModule()

Dim bln As Boolean
bln = Not Application.GetHiddenAttribute(acModule, "Module2")

Application.SetHiddenAttribute acModule, "Module2", bln

End Sub

read up on the SetHiddenAttribute method (and the GetHiddenAttribute method,
while you're at it) in Access VBA Help, so you'll understand how it works.

hth
<Swans>; "What Swans?" <fz@barkingpumpkin.ooowrote in message
news:MP************************@newsgroups.comcast .net...
I have a module in one of my Access DB that is hidden. I'd like to keep
it hidden but I'd like to use AutoKeys to run code to unhide it. I know
how to use AutoKeys, I just don't know how to set the attribute of a
hidden module to unhidden via code. Is it possible to do this?

Jan 13 '07 #2

P: n/a
In article <gY*********************@bgtnsc05-news.ops.worldnet.att.net>,
no****@address.com says...
yes. take a look at the following, as

Public Sub isToggleModule()

Dim bln As Boolean
bln = Not Application.GetHiddenAttribute(acModule, "Module2")

Application.SetHiddenAttribute acModule, "Module2", bln

End Sub

read up on the SetHiddenAttribute method (and the GetHiddenAttribute method,
while you're at it) in Access VBA Help, so you'll understand how it works.

hth
<Swans>; "What Swans?" <fz@barkingpumpkin.ooowrote in message
news:MP************************@newsgroups.comcast .net...
I have a module in one of my Access DB that is hidden. I'd like to keep
it hidden but I'd like to use AutoKeys to run code to unhide it. I know
how to use AutoKeys, I just don't know how to set the attribute of a
hidden module to unhidden via code. Is it possible to do this?



Thanks...
Jan 13 '07 #3

P: n/a
you're welcome :)
<Swans>; "What Swans?" <fz@barkingpumpkin.ooowrote in message
news:MP************************@newsgroups.comcast .net...
In article <gY*********************@bgtnsc05-news.ops.worldnet.att.net>,
no****@address.com says...
yes. take a look at the following, as

Public Sub isToggleModule()

Dim bln As Boolean
bln = Not Application.GetHiddenAttribute(acModule, "Module2")

Application.SetHiddenAttribute acModule, "Module2", bln

End Sub

read up on the SetHiddenAttribute method (and the GetHiddenAttribute
method,
while you're at it) in Access VBA Help, so you'll understand how it
works.

hth
<Swans>; "What Swans?" <fz@barkingpumpkin.ooowrote in message
news:MP************************@newsgroups.comcast .net...
I have a module in one of my Access DB that is hidden. I'd like to
keep
it hidden but I'd like to use AutoKeys to run code to unhide it. I
know
how to use AutoKeys, I just don't know how to set the attribute of a
hidden module to unhidden via code. Is it possible to do this?


Thanks...

Jan 14 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.