Urgent! -Disabled Property Sheet

[Justns11]

Hi all, I'm having a serious problem with my database. I put some code into the even properties for a form to try to disable the record navigation menu at the bottom of a subtable within the form, and now I cannot view the property sheet in any of the forms/tables/queries in my database. Can anyone help me with this? I've deleted the code which was something like

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

but my property sheet is still not visible, even if i click the icon on the toolbar. Any help please... I can't move on with my database without changing this back.

 

[DCrake]

Create a blank database and import everthing into the empty mdb.

 

[gemma-the-husky]

you could try

in a module, just put the same code, with true instead of false, run it

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = true
Next i


to REMOVE the navigation buttons, in the subforms property sheet, just select naviagtion buttons = NO - ie in the design of the subform, not anything to do with your mainform

 

[Justns11]

I just did this (it took a few minutes because it's a big db) and nothing was fixed. Any other suggestions?

I tried the suggestion by gemma also and this did not work. (I went to VB clicked insert module and put that code in there...I tried this immediately after I noticed the error also and it did nothing)

Also...everything else on the toolbar works, including relationships and object dependencies which are right next to property sheet.

 

[gemma-the-husky]

what did you do

Dc's idea?, or mine? or both?

 

[Justns11]

In case someone else has this problem.

I found this solution on another board. Thanks to imagirlgeek at comp.databases.ms-access:

First, log on as a new Windows user to the computer to see if you have the same problem. If you can open Property Sheets as the new user, export the following registy key in regedit:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Settings\CommandBar­s

Then, log on as the original user, and double click the exported REG file to import it.

 

[irish634]

you could try

in a module, just put the same code, with true instead of false, run it

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = true
Next i


to REMOVE the navigation buttons, in the subforms property sheet, just select naviagtion buttons = NO - ie in the design of the subform, not anything to do with your mainform

Another option is to create a new form, create a command button, then put the above code in the on click event. Then click the button on the form.

Can you get into the db using the bypass key? If your original code is in your startup form, it'll disable them every time you open the db.

 

[Justns11]

I fixed my original problem, but the solution gemma suggested for eliminating the navigation bar at the bottom of my table cannot be done.

Let me explain what the form I'm working on currently has on it. I've got a combo box which filters the results in a table which has been imported into the form (by clicking the subform/subreport button on the toolbar and selecting the source object in the property sheet to Table.ProductOperation) Now when I click on that table I do not have the option of changing the navigation button. If it was a subform or subreport it would give me this option thougth (from experience w/ them).
Any other suggestions for how to eliminate that stupid bar at the bottom of the subtable?

 

[gemma-the-husky]

i think a lot of us dont use these automatic features, and instead specfically develop forms for all the functionality we want - so i'm not sure exactly what you are seeing - possibly a datasheet view, which behaves a little differently to a form or continuous form

 

[Justns11]

Yeah, working with access isn't something I normally do (obviously). I'll attach a screen shot to help explain what I'm trying to accomplish. Thanks for the help by the way.

All I'd like is for the bar at the bottom of the subtables(at the right and bottom of my screenshot) to disappear. It seems like this should be a simple task, but I can't figure it out.

 

[RCheesley]

I have a similar but possibly different issue - for some reason my property sheet appears blank! At the top of the sheet it says "Selection Type: Combo box" as per the attachment.

No idea why, I haven't done any VBA and these are just really basic forms - never seen it before!

I closed the form and it still happened, but once I closed the database down and re-opened it, the property sheet started working again! How bizzare!

Ruth

 

[ghudson]

Hi all, I'm having a serious problem with my database. I put some code into the even properties for a form to try to disable the record navigation menu at the bottom of a subtable within the form, and now I cannot view the property sheet in any of the forms/tables/queries in my database. Can anyone help me with this? I've deleted the code which was something like

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

but my property sheet is still not visible, even if i click the icon on the toolbar. Any help please... I can't move on with my database without changing this back.

Did you find that code @ http://www.access-programmers.co.uk/forums/showthread.php?t=97578

If so, there is a warning "Ensure that you have a way to unhide the menu bars and tool bars before you hide them!" posted at the top of that thread, and for a very good reason. ;-)

 

[pkstormy]

Show Navigation Buttons or Bars

To remove the navigation buttons at the bottom of a form, you can simply use code as such:

Forms!MyFormName.NavigationButtons.visible = false

If it's a subform

Forms!MyFormName!MySubformName.NavigationButtons.visible = false

Note that you can pretty much set any of the form's property via the same kind of code (ie. Forms!MyFormName.AllowEdits= false, Forms!MyFormName.AllowAdditions = false, etc...etc...)

 

[pkstormy]

Menus disappear in design view

Also for future reference,

If some of the upper menus in MSAccess 'disappear' for design view, you can just right-click in the top grey area (in form design) and check the appropriate menu bar to show (ie. Form Design, Formatting, Toolbar, etc...)

I would never go into the registry to fix settings like this.