How do I go to a specific field in Access quickly?

[Guest]

In Access 2000 I was able to move quickly between fields in the datasheet
view. I don't seem to be able to do that in Access 2007. Do you have any
suggestions?

 

[Allen Browne]

It should be the same in A2007: use Tab to move forward across the fields,
or Shift+Tab to move back. Use Up/Down to move record, or scroll the mouse
wheel.

 

[Guest]

It should be the same in A2007: use Tab to move forward across the fields,
or Shift+Tab to move back. Use Up/Down to move record, or scroll the mouse
wheel.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

In Access 2000 I was able to move quickly between fields in the datasheet
view. I don't seem to be able to do that in Access 2007. Do you have any
suggestions?

Sorry, but I know that typically you use the tab etc. In Access 2000 there was easier to go to a specific field column more quickly. On the left side there was "drop menu" which listed all the existing field names [i.e. the titles of each field column]. All I had to do was click on a title and I would be brought directly to the field column without having to tab my way across. I was wondering if access 2007 had something similar but "hidden" somewhere. Perhaps it doesn't exist.

 

[Allen Browne]

Ah: I think you are talking about the Object dropdown: on the left end of
the Form Design toolbar in previous versions.

You can add it to the Quick Access Toolbar, through:
Office Button | Access Options | Customize | All Commands | Object

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

It should be the same in A2007: use Tab to move forward across the
fields,
or Shift+Tab to move back. Use Up/Down to move record, or scroll the
mouse
wheel.

In Access 2000 I was able to move quickly between fields in the
datasheet
view. I don't seem to be able to do that in Access 2007. Do you have
any
suggestions?

Sorry, but I know that typically you use the tab etc. In Access 2000
there was easier to go to a specific field column more quickly. On the
left side there was "drop menu" which listed all the existing field names
[i.e. the titles of each field column]. All I had to do was click on a
title and I would be brought directly to the field column without having
to tab my way across. I was wondering if access 2007 had something
similar but "hidden" somewhere. Perhaps it doesn't exist.

 

[Guest]

Ah: I think you are talking about the Object dropdown: on the left end of
the Form Design toolbar in previous versions.

You can add it to the Quick Access Toolbar, through:
Office Button | Access Options | Customize | All Commands | Object

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

It should be the same in A2007: use Tab to move forward across the
fields,
or Shift+Tab to move back. Use Up/Down to move record, or scroll the
mouse
wheel.

In Access 2000 I was able to move quickly between fields in the
datasheet
view. I don't seem to be able to do that in Access 2007. Do you have
any
suggestions?

Sorry, but I know that typically you use the tab etc. In Access 2000
there was easier to go to a specific field column more quickly. On the
left side there was "drop menu" which listed all the existing field names
[i.e. the titles of each field column]. All I had to do was click on a
title and I would be brought directly to the field column without having
to tab my way across. I was wondering if access 2007 had something
similar but "hidden" somewhere. Perhaps it doesn't exist.

Okay, I did what you suggested. I found the command [which says it's part of Object Gallery] and added it to the "Quick Access Toolbar" but now when I click on the command nothing happens. Question: where does "Object Gallery" exist? Supposedly it's not in the ribbon. If so where is it??? Thanks for taking the time to help.

 

[Allen Browne]

Hmm. A quick test suggests that this works in Design View only in Access
2007. I'm not clear if that's the only choice, or the result of some of the
properties I set.

That toolbar item was not really meant to be used that way in design view,
so perhaps A2007 doesn't support it.


--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Okay, I did what you suggested. I found the command [which says it's part
of Object Gallery] and added it to the "Quick Access Toolbar" but now
when I click on the command nothing happens. Question: where does "Object
Gallery" exist? Supposedly it's not in the ribbon. If so where is it???
Thanks for taking the time to help.

Ah: I think you are talking about the Object dropdown: on the left end of
the Form Design toolbar in previous versions.

You can add it to the Quick Access Toolbar, through:
Office Button | Access Options | Customize | All Commands | Object

:

It should be the same in A2007: use Tab to move forward across the
fields,
or Shift+Tab to move back. Use Up/Down to move record, or scroll the
mouse
wheel.

In Access 2000 I was able to move quickly between fields in the
datasheet
view. I don't seem to be able to do that in Access 2007. Do you have
any
suggestions?

Sorry, but I know that typically you use the tab etc. In Access 2000
there was easier to go to a specific field column more quickly. On the
left side there was "drop menu" which listed all the existing field
names
[i.e. the titles of each field column]. All I had to do was click on a
title and I would be brought directly to the field column without
having
to tab my way across. I was wondering if access 2007 had something
similar but "hidden" somewhere. Perhaps it doesn't exist.