Problems with Access Database

jasmin10

Hi folks,

I have designed a customer contact form in Access but have a couple of problems that I haven't come across.

When using the form I want to be able to tab form each form field in order but at the moment it when pressing tab it jumps from say a field at the top to one in the middle and then back up again and all over the shop. Is there a way how I can tell it go from this field to this field.

The other problem I have is in the database view (the one with the columns for the form. It seems to have mixed up the order of the columns and I want to put them back in order but it won't let me 'move' the columns only insert and delete. The reason I want them in order is for ease of use and to make it easier to import from Excel.

Tell you want if there's an angel out there that can help me sort these to problems I'll buy you a virtual beer.

Thanks for any help.

Sam

PaulK_3

In Access, open the form in Design View and choose Tab Order from the View Menu.

Don't know if it works though as haven't got access open at the mo.

jamalfatty

For the first question, you will need to set the TabIndex, can be done in VBA using this method (http://www.techonthenet.com/access/modules/reorder_tabs.php) or can probably be done using properties panel but dont have access open at moment so cant check.

As to the second problem, you can select the whole field/column in datasheet/design view, and then just drag it into the position you want. If for some reason it wont let you do this, design a new query using this table and drop the fields into query in order you want them to display.

Chippy_Minton

For the tabbing problem, set the Tax Index property for each field: 1 for the first field, 2 for the second etc.

For the other, click the column heading (the whole column blacks out), then click again and drag and drop to where you want it and save.

jasmin10

Thank you all so much. As soon as I had arranged the tab it put the columns in the database in the correct order.

It is very much better although the tabs are in the right order once it has gotten down to the bottom of the first page it goes back up to the first page and dosen't continue through to the second. Any ideas?? The fields are listed in order in the tab view. If I can get this bit sorted it will all be done although I can live with it.

Thank you all so much. (Any ideas on the second part)

Chippy_Minton

You could use the KeyDown event on the last control of the first page to check for the tab key and set the focus to the first control on the next page. E.g. (untested):

Private Sub txtLastField_KeyDown(KeyCode As Integer, Shift As Integer)
    If KeyCode = vbKeyTab Then
        KeyCode = 0
        Me.myForm.Pages(1).SetFocus
    End If
End Sub

jasmin10

Thank you all so much for your help. I sorted out the last problem with the page buttom . There was a break between it so I just deleted it.