Jump to content

Welcome to Geeks to Go - Register now for FREE

Need help with your computer or device? Want to learn new tech skills? You're in the right place!
Geeks to Go is a friendly community of tech experts who can solve any problem you have. Just create a free account and post your question. Our volunteers will reply quickly and guide you through the steps. Don't let tech troubles stop you. Join Geeks to Go now and get the support you need!

How it Works Create Account
Photo

Access Menus


  • Please log in to reply

#1
magusbuckley

magusbuckley

    Member

  • Member
  • PipPipPip
  • 626 posts
Hello:

This afternoon, I patted myself on the back for completing an Access Database I'll be using at work. Bruce and I are in the IT department at a local casino and have been looking for a way to track our work. I created this database for just that. We can key in projects or service requests and print them out later. As a final touch, I thought it would be nice to have the database open by showing the main form only. I was wondering if it would allow me to hide all other open windows at startup. I just wanted to see the main form. I right-clicked the main window and selected "Startup" from the pop-up menu. On that page, I chose to view my main form on startup. I also unchecked all boxes related to things viewed at program startup. I saved, closed, and reopened the database. The main form opened as I had hoped it would, but the other window (listing tables, forms, reports, etc.) was open as well. That's not really what I wanted. My only option now is to make more changes to my startup procedures....but wait a minute! I can't get there now! My menus are missing. I can't even edit any of my forms or reports because the options simply aren't there. I realize, of course, that I mistakenly removed the checkboxes from those items for the "Startup" procedures for the program. Now, however, I'm wondering how I can get my menus back. I'm trying to get any kind of access to this database now. I've almost completely locked myself out of the darn thing. How silly.

This database was created with Microsoft Access XP (2002).

Any and all information will be greatly appreciated.

I hope my enclosed photo will demonstrate my problem.

Thanks,

Magus

Attached Thumbnails

  • accesshelp.jpg

  • 0

Advertisements


#2
Twiztnin223

Twiztnin223

    Member

  • Member
  • PipPip
  • 90 posts
:whistling: Hello:)

Ok to get your menus back, right click on the toolbar that says File, Edit, View, Insert, etc. and choose which bars you want back.

As for not showing the main portion of your database. Go to your Toolbar, Click Tools and in that menu click Startup. Uncheck the box that says "Display Database Window".

Hope this helps!

:blink:
  • 0

#3
magusbuckley

magusbuckley

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 626 posts
Thank you for the reply.

Unfortunately, your solution isn't helping any. The toolbar that normaly says File, Edit, View, Insert, etc. only says File, Window, and Help. I don't get the pop-up window any more when I right-click this toolbar. Since this toolbar is missing the "Tools" option, I'm unable to change my startup options to not show the "Display Database Window". I'm sure this feature will work, I only need to figure out how to get my toolbar back. :whistling:

I have since taken the database to work and yes, we are using it. The catch is, I've already seen some things I'd like to edit and/or add but am unable to do so until I get this issue resolved.

The other people in my IT department are just as baffled as I am. It really does seam as though I've locked myself out of my own database. How silly.

If you can think of anything else I might try, please let me know.

Thanks,

Magus
  • 0

#4
peteoh

peteoh

    New Member

  • Member
  • Pip
  • 2 posts
Magus,

This sort of happened me before. What I think you should have done is on the Startup menu to disable all functionality except Allow Full Menus.

Probably a better solution is to create your own Toolbar with an Icon for the Main Form so that any time a user gets lost they can click a button and get back to main menu. For this to work you need to have "Allow Built-in Toolbars" enabled under StartUp and close all toolbars bar your own Main Form one.

To get back live I have had to create a blank Database and Import everything from the original. Luckily it doesn't import StartUp and Options settings so you need to set them manually afterwards. You also need to go to VBA and reset References for any functionality built into forms.

I haven't come across a way to hide the Database window but what you can do is - for all Forms, Tables etc you can rightclick on them and check the Hidden Property. Having done this for all objects in the DB you need to go to Options View and unclick Hidden Objects. This way if someone closes a Form they end up looking at a Blank database Window and the only place to go is your toolbar with the Main Form button.

Hope this works. If it does put $5 on Black 17 and send the winnings to me.

Good Luck

Peteoh
  • 0

#5
Surgenor

Surgenor

    New Member

  • Member
  • Pip
  • 1 posts
I have gone one step further and locked out any ability to edit menus etc by creating a custom toolbar that is uneditable but the only one displayed! 7 hours work wasted. However I also managed what you describe and I found a solution.

1. Open Microsoft Database (blank project)
2. Right click the menu bar and choose customize
3. from the tool menu, drag and drop the "startup" button to beside the standard menus (file, edit etc.)
4. Close the new blank database and open your database.
5. Click the startup button oin the toolbar and you can now reselect allow menus.

Good Luck!
  • 0

#6
magusbuckley

magusbuckley

    Member

  • Topic Starter
  • Member
  • PipPipPip
  • 626 posts
Surgenor:

What you said solved my problem. I really appreciated it. We've been using this database for a week or so now, but I've really needed to make a few changes.

Thanks a million for the tip! :whistling:

Magus
  • 0

#7
Braindrops

Braindrops

    New Member

  • Member
  • Pip
  • 1 posts
Thanks for the solution!
I did the same mistake, but with your help I am back on track again.
Thousand thanks.

From another forum I got a simpler solution - close Access and hold down the Shift key while you clicking on your database, and it will open with full menus.

/B

Edited by Braindrops, 19 June 2006 - 12:22 PM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP