Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2007 tab control

Posted on 2010-11-27
14
Medium Priority
?
442 Views
Last Modified: 2012-05-10
My OS win exp prof.  I have a Form and I am trying to move from a field to another field of my choice.  But in the design mode where is the tab control where u can move the controls in what order they fire.  Thanks.
0
Comment
Question by:jegajothy
  • 8
  • 6
14 Comments
 
LVL 22

Expert Comment

by:Flyster
ID: 34222471
Right click your field and select properties. Under the Other Tab you'll find Tab Index. Enter 0 for the first field you want focus on. Make sure tab stop is marked Yes.

Flyster
0
 
LVL 22

Expert Comment

by:Flyster
ID: 34222507
Just to be more specific, enter 0 for the first field you want focus on, 1 for the second, 2 for the third and so on. If you don't want a field to be tabbed on, set tab stop to no.
0
 

Author Comment

by:jegajothy
ID: 34222526
But I am unable to click on the row to drage to the order that I want.  Is it because the 3 fields that i hae are combo boxes.  OR what is the vb code that I could insert on the On Exit command. thanks.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 22

Expert Comment

by:Flyster
ID: 34222576
If you're in design mode, you should be able to right-click on the combo box to get to the properties. If you can get to the On Exit property, you should be able to get to tab index. If not, the VBA on exit command would be "me.NameOfNextField.SetFocus" (without quotes).
0
 

Author Comment

by:jegajothy
ID: 34222698
In reply to Flyster, I tried the me syntax, but it did not work.  I tabbed from the Zip field to go to the city field.  But it did nothin.  I had put the code in the Exit of the City field, which is a combo box.

Here is the code :
Private Sub ZipCode_Exit(Cancel As Integer)
    Me.City.SetFocus
End Sub

thanks.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 34222773
Can you provide a clean copy of your db, or a screen shot of your property field. What version of Access are you using?  Make sure the name of your combo box is "City" and not "Combo X" I'm not too familiar with any version before 2003, but as of 2003 tab index is found in the Other tab of properties.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 34222888
If you're tabbing from the Zip field to the City field, the code should go in the Zip on exit. If you have it in City, when you exit City the code will just set focus back on city.
0
 

Author Comment

by:jegajothy
ID: 34223566
To Flyster, my Access is 2007.  It has been a very long since I have used it and everything seems so different.  If I zip the file and send it could u please take a look.  Also there is another area is the combo box.  I am trying to fix it but have failed.  What I want to do is if data is not in the table, then to add the new data.  I was trying the code but have not got anywhere. thanks.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 34223627
I won't be able to look at it until later tonight. I'm at work and they only have Access 2003. If you were able to get to the event tab to select the on exit event, the "Other" tab is just to the right of that. That's where you will find the Tab Index setting.
0
 
LVL 22

Accepted Solution

by:
Flyster earned 2000 total points
ID: 34224238
I found your db in your other post. I changed the tab order on the main form (FORM MAIN NOV 26 - tblZipcodeCity and County) Let me know if this is what you were looking for.
HBF-Modified-ambit-energy-s-BGE-.accdb
0
 

Author Closing Comment

by:jegajothy
ID: 34225339
Excellent solution. Well done. Thank u
0
 

Author Comment

by:jegajothy
ID: 34225342
To Flyster, How did u do it?  When I right clicked on the first field, but I could not click on the tab order fields. And that was where I was stuck. Thanks.
0
 
LVL 22

Expert Comment

by:Flyster
ID: 34226549
Here's a screen shot of what you should be looking for.
TabIndex.JPG
0
 

Author Comment

by:jegajothy
ID: 34227269
Thank u for the time u took and My apologies for being such a novice.  Never realized that we had to go there as the older versions acted better.
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question