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
| FAQ | Members List | 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 Search this Thread Display Modes
  #1 (permalink)  
Old May 31st, 2005, 09:08 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
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

Reply With Quote
  #2 (permalink)  
Old May 31st, 2005, 01:31 PM
ru1 ru1 is offline
Authorized User
 
Join Date: Feb 2005
Location: Detroit, MI, USA.
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

Reply With Quote
  #3 (permalink)  
Old June 1st, 2005, 07:32 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
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

Reply With Quote
  #4 (permalink)  
Old June 1st, 2005, 02:36 PM
ru1 ru1 is offline
Authorized User
 
Join Date: Feb 2005
Location: Detroit, MI, USA.
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

Reply With Quote
  #5 (permalink)  
Old June 1st, 2005, 03:28 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
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



Reply With Quote
  #6 (permalink)  
Old June 2nd, 2005, 07:55 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
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

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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
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



All times are GMT -4. The time now is 05:47 PM.


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