473,326 Members | 2,095 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Hide method in A97?

MLH
I copied the code example below from A97 HELP. However,
I get an error when I try to use something like frmMainMenu.Hide
and am uncertain as to why. Ideas?

The following example assumes two UserForms in a program. In
UserForm1's Initialize event, UserForm2 is loaded and shown. When the
user clicks UserForm2, it is hidden and UserForm1 appears. When
UserForm1 is clicked, UserForm2 is shown again.

' This is the Initialize event procedure for UserForm1
Private Sub UserForm_Initialize()
Load UserForm2
UserForm2.Show
End Sub
' This is the Click event of UserForm2
Private Sub UserForm_Click()
UserForm2.Hide
End Sub

' This is the click event for UserForm1
Private Sub UserForm_Click()
UserForm2.Show
End Sub
Apr 4 '06 #1
4 1771
"MLH" <CR**@NorthState.net> wrote in message
news:ls********************************@4ax.com...
I copied the code example below from A97 HELP. However,
I get an error when I try to use something like frmMainMenu.Hide
and am uncertain as to why. Ideas?

The following example assumes two UserForms in a program. In
UserForm1's Initialize event, UserForm2 is loaded and shown. When the
user clicks UserForm2, it is hidden and UserForm1 appears. When
UserForm1 is clicked, UserForm2 is shown again.

' This is the Initialize event procedure for UserForm1
Private Sub UserForm_Initialize()
Load UserForm2
UserForm2.Show
End Sub
' This is the Click event of UserForm2
Private Sub UserForm_Click()
UserForm2.Hide
End Sub

' This is the click event for UserForm1
Private Sub UserForm_Click()
UserForm2.Show
End Sub


Are you sure? That doesn't look like Access VBA, but rather classic VB code.
There are topics in VBA Help that do not apply to Access. Normally in Access
VBA you would use the Visible property rather than Show and Hide.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Apr 4 '06 #2
Rick Brandt wrote:
"MLH" <CR**@NorthState.net> wrote in message
news:ls********************************@4ax.com...
I copied the code example below from A97 HELP. However,
I get an error when I try to use something like frmMainMenu.Hide
and am uncertain as to why. Ideas?

The following example assumes two UserForms in a program. In
UserForm1's Initialize event, UserForm2 is loaded and shown. When the
user clicks UserForm2, it is hidden and UserForm1 appears. When
UserForm1 is clicked, UserForm2 is shown again.

' This is the Initialize event procedure for UserForm1
Private Sub UserForm_Initialize()
Load UserForm2
UserForm2.Show
End Sub
' This is the Click event of UserForm2
Private Sub UserForm_Click()
UserForm2.Hide
End Sub

' This is the click event for UserForm1
Private Sub UserForm_Click()
UserForm2.Show
End Sub

Are you sure? That doesn't look like Access VBA, but rather classic VB code.
There are topics in VBA Help that do not apply to Access. Normally in Access
VBA you would use the Visible property rather than Show and Hide.

We don't use UserForms.

In A97, use Visible to hide/unhide.
Apr 5 '06 #3
salad wrote:
Rick Brandt wrote:
"MLH" <CR**@NorthState.net> wrote in message
news:ls********************************@4ax.com...
I copied the code example below from A97 HELP. However,
I get an error when I try to use something like frmMainMenu.Hide
and am uncertain as to why. Ideas?

The following example assumes two UserForms in a program. In
UserForm1's Initialize event, UserForm2 is loaded and shown. When the
user clicks UserForm2, it is hidden and UserForm1 appears. When
UserForm1 is clicked, UserForm2 is shown again.

' This is the Initialize event procedure for UserForm1
Private Sub UserForm_Initialize()
Load UserForm2
UserForm2.Show
End Sub
' This is the Click event of UserForm2
Private Sub UserForm_Click()
UserForm2.Hide
End Sub

' This is the click event for UserForm1
Private Sub UserForm_Click()
UserForm2.Show
End Sub


Are you sure? That doesn't look like Access VBA, but rather classic
VB code. There are topics in VBA Help that do not apply to Access.
Normally in Access VBA you would use the Visible property rather than
Show and Hide.

We don't use UserForms.

In A97, use Visible to hide/unhide.


The above sentences were addressed to MLH, not Rick.
Apr 5 '06 #4
MLH
Ended up using the Visible property. I just wondered about this when
I saw it. After trying it and finding I couldn't make it work, I just
had to ask about it. Now I see. Thx.

Are you sure? That doesn't look like Access VBA, but rather classic VB code.
There are topics in VBA Help that do not apply to Access. Normally in Access
VBA you would use the Visible property rather than Show and Hide.


Apr 5 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: TMB333 | last post by:
I've researched as much as I can on the issue, but I've not found any clearly defined statement that acknowledges that the Hide method for a TabPage object just doesn't do what it's supposed to do....
9
by: Robb Gilmore | last post by:
Hello, This is probably an easy one, but I have not been able to figure it out so far. I have a tab control on a windows forms app. Depending on some business logic, I need to hide/show some...
10
by: David | last post by:
Hi everyone, Hoping there are some .js/browser experts out there that can help with this weird problem. I have made a swap div routine and applied the events to menu buttons with a closer...
6
by: Alex Sedow | last post by:
Example 1 interface I { string ToString(); } public class C : I { public void f() {
3
by: Tom Jones | last post by:
I do not understand what is meant when someone states that a given method is "hidden" verses overriden. Would someone please provide a short example of both cases and why you might want to...
0
by: Efkas | last post by:
I have a full custom application with some widged extending Controls like Label and PictureBox. I build a menu with these widgets. When I click on one of them, it calls a function to display...
13
by: Matt | last post by:
Does anyone know how to hide the ASPX extension of web pages in ASP.Net 2.0? Thanks, Matt
3
by: deciacco | last post by:
I'm trying to write a label printing SDI app with a small preview on the main form itself. Every time I run the InvalidatePreview event on the preview control to redraw the preview I get the...
6
by: Doogie | last post by:
Hi I have an img control I am trying to hide upon certain types of commands in my code behind. When to hide it is directly tied to a asp:dropdownlist control. So depending on what the user...
0
Debadatta Mishra
by: Debadatta Mishra | last post by:
Introduction In this article I will provide you an approach to manipulate an image file. This article gives you an insight into some tricks in java so that you can conceal sensitive information...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.