Go To Field

[LJP]

We have recently upgraded to Access 2007. Can anyone tell me if the 'Go To
Field' property is still available when in datasheeet view. Many of our
tables have 100+ fields so being able to 'Go To' a particular field is very
useful. If 'Go To Field' is no longer available is there something that has
taken it's place?

My fingers are crossed!

 

[Jeff Boyce]

I can't tell from your description whether you are using a spreadsheet, or
trying to make Access work like a spreadsheet.

If the latter, you will find considerable opinion in the Access newsgroups
that both you and Access will have to work overtime to do things "just like
Excel"...

You'll also find a considerable body of opinion that using datasheets to
display data is likely to cause people to think that they are working with a
spreadsheet. Access tables store data, but Access forms have a rich "event"
environment that lets you provide your users a much friendlier view of their
data.

Before you try to recreate what you've apparently been doing in an earlier
version, consider reading up on normalization and relational database
design. A Table (?!"many of our tables"?!) with more than about 30 fields
is rarely well-normalized. Pay now or pay later!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[LJP]

Well gee....I thought it was a relatively simple inquiry. I feel as though
I'm back in school and being scolded by the teacher.

My question pertains to an Access datasheet, thus the reason why I posted to
the Access Database Discussion Group. As an HR consulting firm, we gather
workforce data from various organizations to analyze for required government
reporting. All data is imported into Access where we then prepare for
processing. I can't control the number of fields of data that our clients
send to us. However, after the initial import it does get broken down and
placed into other 'smaller' tables.

If anyone can answer my initial question, it would very much appreciated.

Does the 'Go To Field' control still exist in Access 2007?

Again, thank you.

 

[Steve Schapel]

LJP,

I have never found anything called 'Go To Field' in any version of
Access. I may be wrong, but I don't think it exists, or has ever existed.

There is a GoToControl macro action, and yes that is still available in
Access 2007.

In VBA there is a corresponding DoCmd.GoToControl method - though in VBA
the SetFocus is more commonly used instead.

 

[LJP]

Hi Steve: Access 2000; Right click on a toolbar to customize; Commands tab;
Categories: Records; Commands: Go to Field:

It's there....our team of analysts use it (or we did use it!). But more
importantly, we MISS it!

Thanks for the reply.

 

[Jeff Boyce]

You may not realize how many folks post to the "public.access" newsgroup
concerning Outlook, Excel, Publisher, and any number of other (non-Access)
topics. I'm pretty linear in my approach (just ask my spouse!), so I tend
not to answer until I feel I understand the situation. Sorry if that came
across as scolding ... folks who know me would be surprised to hear me
accused of scolding!

My comments pertained to how to get the best use of the tool. If your
Access tables have "100+" fields, you are probably treating Access as if it
were a spreadsheet. You can do that, but you won't get particularly good or
easy use of Access' features/functions.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve Schapel]

LJP,

Thanks, I was not aware of that. Well now I know what you are talking
about, but sadly unable to offer any help.

 

[Gast]

We have recently upgraded to Access 2007. Can anyone tell me if the 'Go
To
Field' property is still available when in datasheeet view. Many of our
tables have 100+ fields so being able to 'Go To' a particular field is
very
useful. If 'Go To Field' is no longer available is there something that
has
taken it's place?

My fingers are crossed! wer bist duuuuuuuuuuuuuuuuuuuuuuuuuu

 

[Gast]

We have recently upgraded to Access 2007. Can anyone tell me if the 'Go
To
Field' property is still available when in datasheeet view. Many of our
tables have 100+ fields so being able to 'Go To' a particular field is
very
useful. If 'Go To Field' is no longer available is there something that
has
taken it's place?
waw
My fingers are crossed!