Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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
 
Old June 6th, 2007, 09:29 AM
Authorized User
 
Join Date: Jul 2006
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default button command for page change

hello all,

i am creating a form and i need to have 3 seperate pages, one for profile, data, and workloads. i tried using a tab control but that does not work as i will need to have a tab within a tab. so i have decided the best way is to use a page break.

is there any way i can create a buttons that will navigate to each page? EG) page 1 click here, page 2 click here and page 3 click here.

thanks for the help

 
Old June 6th, 2007, 09:53 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Are you saying that you have 3 separate forms, or are these data access pages?

Kevin

dartcoach
 
Old June 6th, 2007, 09:59 AM
Authorized User
 
Join Date: Jul 2006
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

sorry, i should have made that clear. it is one form, with page breaks seperating each kind of information the user is inputting. all info is added on to one form, the page breaks and corresponding buttons are for aesthetic purposes as per manager request

 
Old June 6th, 2007, 10:06 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

I've never used page breaks on a form, but I imagine that if you set focus to the first field on whichever page button they click on, that might help.

Kevin

dartcoach
 
Old June 6th, 2007, 11:25 AM
Authorized User
 
Join Date: Jul 2006
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

perfect figured it out.
thanks for the help kevin!


 
Old June 6th, 2007, 11:39 AM
Friend of Wrox
 
Join Date: Jan 2005
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Glad to help.

Kevin

dartcoach





Similar Threads
Thread Thread Starter Forum Replies Last Post
Change the Select Command of a DataAdapter from th Manolis_Perrakis ASP.NET 2.0 Basics 0 October 20th, 2006 10:56 AM
Command Button Question eoghang Excel VBA 2 September 25th, 2006 08:33 PM
Change Cursor Type When Using the Command Object hcweb Classic ASP Basics 2 April 7th, 2004 01:08 PM
command button qry mohiddin52 Access 0 December 22nd, 2003 08:20 AM
Command button not working in ms access page mohiddin52 Access 1 December 14th, 2003 06:52 PM





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