Wrox Programmer Forums
|
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 May 31st, 2005, 09:08 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Moving vertically on a form

Hi friends,
I know i can have a spreadsheet like movement on an access form,
but if i would like to have a vertical column movement when pressing the tab keyboard key how would i have it? Is there an easy way or i would have to program it by code ?:)
rgds Penta

 
Old May 31st, 2005, 01:31 PM
ru1 ru1 is offline
Authorized User
 
Join Date: Feb 2005
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you set the TAB Control on the form, you can scroll any which way that you want. Are you familer with the Tab Control property?

RU1

 
Old June 1st, 2005, 07:32 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think i have had a bad formulation of the question.I'll try again. I have a
form with a tabulated lay-out(fields side by side)and i'll suppose 30 records
(thirty lines).The default when i press the tab key is to walk the grid from
left to right and from top to bottom. I'm wandering if there is an easy way
to invert the way the tab key works.That is first top to bottom then left to
right. If i'm not wrong the Tab control property sets the sort order of
the fields on a form and i would not know how to have it working the way i've described above.Please correct me if i'm wrong.
rgds P

 
Old June 1st, 2005, 02:36 PM
ru1 ru1 is offline
Authorized User
 
Join Date: Feb 2005
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well. The tab control sets the order that the cursor goes to when the[TAB] key is pressed so if you have a form like the one below:

1_____________ 6___________
2_____________ 7___________
3_____________ 8___________
4_____________ 9___________
5_____________ 10___________

To traverse this you would set your tab order as follows: to go top to bottom and then left to right. You set the tab order in the form as 1 2 3 4 5 6 7 8 9 10. If you wanted to go left to right: 1 6 2 7 3 8 4 9 5 10. I am using the numbers in this example like field names.

Does this solve the problem?

RU1

 
Old June 1st, 2005, 03:28 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks RU1 for ur care,
But the problem is not solved because what i would like to do is moving vertically on a form where 1 and 6 are fields. The other numbers are
not fields but records: 2-7,3-8,4-9,5-10 are records of fields 1-2.
There is a known code that using the arrows u may walk up and down , back and forth,and i was wandering if using the tab i would just invert the tab default
using any other procedure. There are many problems involved and if this would be possible the form would have to have a button to revert the tab movement
from the default to the alternate procedure.
rgds P



 
Old June 2nd, 2005, 07:55 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Problem solved,
Changing from form view to datasheetview the arrow keys will work as expected
and that will satisfy my needs. Programming is the art of doing what is possible at the moment without loosing the perfect target to be achieved tomorrow.
P






Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving the form from a custom made controlbox Apocolypse2005 Beginning VB 6 3 July 11th, 2007 04:21 AM
Event handler for moving a form tericson Access VBA 1 December 11th, 2006 04:16 AM
Moving total from Subform to Main Form Shepwad Access 1 March 10th, 2006 10:57 AM
Vertically Constrain GridView wirerider ASP.NET 2.0 Basics 3 February 6th, 2006 06:53 PM





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