Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #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

Reply With Quote
  #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
Reply With Quote
  #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
Reply With Quote
  #4 (permalink)  
Old October 23rd, 2003, 06:51 AM
Friend of Wrox
Points: 3,947, Level: 26
Points: 3,947, Level: 26 Points: 3,947, Level: 26 Points: 3,947, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,150
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
Reply With Quote
  #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

Reply With Quote
  #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
Reply With Quote
  #7 (permalink)  
Old October 26th, 2003, 10: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

Reply With Quote
  #8 (permalink)  
Old October 26th, 2003, 11:27 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

So, I guess it is working now?

:)


Sal
Reply With Quote
  #9 (permalink)  
Old October 27th, 2003, 08: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

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 04:12 PM
Footer only for last page XSLTUser XSLT 0 December 27th, 2007 03: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 02:07 AM
suppress Page footer in some pages cankalu Crystal Reports 1 June 4th, 2004 10:15 AM



All times are GMT -4. The time now is 07:36 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.