Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old October 21st, 2003, 11:23 PM
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default page footer

hi

i have a form where i have place the main data on the "Detail" portion. i wish to have a command button on my detail page and when i click on it, the action is to open the page footer where it consists some data which means that the data will only display when the button is clicked.

i have try by making the data visible = false first and in the event of on click event of the command button, i wrote :
me.lblData.visible = true,
however it does not work.

how can i do that??

pls advice
nono

  #2 (permalink)  
Old October 22nd, 2003, 09:08 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

try on form load
Me.FormFooter.Visible = False

and on button click
Me.FormFooter.Visible = true

Is this what you are looking for?

Sal
  #3 (permalink)  
Old October 22nd, 2003, 08:19 PM
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi sal,

this is exactly what i wanted. can i ask u one more question?
how can i adjust the form footer. becoz if i have a large amount of data on the form footer then my form size will appear a large blank space on the bottom unless the user click on the command button.

so what i want is that can the form resize itself, which means that when the form load, it will appear in the size where the form footer is hidden (no blank space shown). only after the user click on the command button the form will then resize to the approiate size.

i hope this dont confuse you.

pls advice
:)nono
  #4 (permalink)  
Old October 23rd, 2003, 06:51 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

How about if you put this statement after you make the form footer and label visible?
Code:
   Me.FormFooter.Height = Me.lblData.Height

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
  #5 (permalink)  
Old October 24th, 2003, 10:04 PM
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi Greg Serrano,

i have try the method u told me. it wont solve the redundant space. there will be a blank space at the footer when my form loads.

any ideas?

pls advice
nono

  #6 (permalink)  
Old October 25th, 2003, 05:10 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try setting the
CanShrink property to yes and the
CanGrow to yes

Sal
  #7 (permalink)  
Old October 26th, 2003, 11:12 PM
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi sal,

the previous method u taught me was correct after many tries.... but in the first place i have to change the properties of the form footer in order for the visbility to work. glad that u have help me.

thanks a million!
nono

  #8 (permalink)  
Old October 27th, 2003, 12:27 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

So, I guess it is working now?

:)


Sal
  #9 (permalink)  
Old October 27th, 2003, 09:16 PM
Authorized User
 
Join Date: Oct 2003
Location: , , .
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

yes of course it works!

thanks again
nono:D



Similar Threads
Thread Thread Starter Forum Replies Last Post
Footer Image Based on Current Page gothael ASP.NET 2.0 Basics 10 January 23rd, 2008 05:12 PM
Footer only for last page XSLTUser XSLT 0 December 27th, 2007 04:34 PM
page footer drachx Crystal Reports 0 October 12th, 2005 05:47 AM
is it psossible to customize header footer page or Swapnil VB How-To 0 February 1st, 2005 03:07 AM
suppress Page footer in some pages cankalu Crystal Reports 1 June 4th, 2004 10:15 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.