Access form not showing and can't delete access form

B

Bowermml

I have 2 related problems. I have an Access database I am helping someone
with.

First, Access is not giving me a delete option when I right click in the
project area. When I create a blank database and create a form, I can right
click and see a delete option. But not in this database

Second, I can't see all of the forms in my project area. In the database
documenter and other areas, I see at least one form that does not show up in
my project area. How do I get all of them to show up so I can edit them?

This all sounds like a rights/permissions problem, but I open it as an
admin. What am I missing?
 
M

Maurice

Try going to the VBA editor. If you see the form there on the left click on
it once and then click on the design button in the menubar. Now go back to
the db view and see if it shows up in design now.
 
C

Chris O'C via AccessMonster.com

Not sure what you mean by project area. The Project Explorer window? The
database window?

If your right click menu isn't available it's been disabled. Go to the menu,
Tools > startup. Mark the checkbox for Allow default shortcut menus.

You won't normally see forms that have the hidden attribute or system
attribute set. Go to the menu, Tools > options. On the View tab mark the
check boxes for Show hidden objects and Show system objects.

Chris
Microsoft MVP
 
B

Bowermml

no. it isn't in the vba editor. I have ended up importing all of the
objects in this db to a new db and i have access to them now. There must be
some right issue i can't figure out on the original.
 
B

Bowermml

I can right click and take actions. It is simply that the delete action is
missing. I am 99% sure it is a right issue, just not sure what to do.
 
C

Chris O'C via AccessMonster.com

Could be a custom shortcut menu that lacks a delete submenu or the db may be
secured so the admin user can't delete objects. Do you know how to check for
these situations?

Chris
Microsoft MVP
 
J

John Spencer

As far as a form not being visible, it could be that the form has been
marked as hidden by using the Hidden Attribute.

Select Tools: Options: View and check Hidden Objects and then click OK
or Apply. Now check to see if the form is visible.

If you are using Access 2007 things have moved, so you will have to hunt
around.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Top