Converted a 2000 Access program to 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tammy - 21 Jan 2005 15:41 GMT

and now the shift enter combinatin does not work to get to tables fromforms

Reply to this Message

Ed Robichaud - 23 Jan 2005 04:20 GMT

Try explaining your question in a little more detail (as well as spell
checking). What are you trying to accomplish and what are the conditions
when it is not working?

Are you working from the database window, from a form in design mode, or
what? I'm not sure what you mean by "not getting to tables". The only
Shift-Enter action that I'm familiar with is the "save record" command of
the Record menu, when a form/report is the /active window. No reason, that
converting from ver 2000 to 2003 should change any of the standard menu
functions.

As you probably know, Access doesn't really need an explicit "save" command,
as records are saved anytime you move off the form or close it.
-Ed

> and now the shift enter combinatin does not work to get to tables
> fromforms

Reply to this Message

Tammy - 24 Jan 2005 14:11 GMT

The access database is converted from a 2000 Access database into 2003 Access
database. It automatically opens up to a form once I input my id and
password that is set up for me. I used to be able to go to the tables by
inputing my id and password and then pressing the shift key simutaiously with
the enter key and walla the form is gone and the tables are present to work
with or the querriers ot just what I call the back side. I did not set this
up. I did not have any problem before when it was in 2000 Access. Thew
toolbars at the top are not present because it was set up so no one other
then myself and a few administrators could modify the database.
Can you help?

> Try explaining your question in a little more detail (as well as spell
> checking). What are you trying to accomplish and what are the conditions
[quoted text clipped - 13 lines]
> > and now the shift enter combinatin does not work to get to tables
> > fromforms

Reply to this Message

Ed Robichaud - 24 Jan 2005 15:17 GMT

Thanks for explaining further. A few options to consider:

1. You can return to running the 2000 version under Access2003; works just
fine and there are few, if any features that you'll miss.

2. I suspect the previous designer (unwisely, since Shift-Enter is a built
in key combination that is already defined for another purpose - Save
Record) put in a macro that displays the database window - the collection of
tables/queries/forms/etc. Access 2003 can be fussy about macro security.
Try lowering the security level and that macro may work again.

3. Holding down the Shift key while opening the database will bypass any
opening code/macro that turns off the menus, hides the database window,
toolbars, etc.

4. Pressing the F11 key will (in almost all circumstances) open the database
window.

5. Be sure that you're running an MDB, not an MDE (which is a "locked down"
version of a database).

6. No one, even you, should be doing data entry at the table level. Have a
well designed data structure (well thought-out tables and relationships) and
depend on well designed forms to ease/control what data is added/edited.

Once you're able to get control back for development, why not have a
front-end just for you (and other selected few) that eliminates all those
pseudo-controls.
-Ed

> The access database is converted from a 2000 Access database into 2003
> Access
[quoted text clipped - 30 lines]
>> > and now the shift enter combinatin does not work to get to tables
>> > fromforms

Reply to this Message