Remove Navigation from bottom of tables

[bob500000]

Hi,



I have imported a table into a form and would like to know how to remove the navigation options from the bottom of the table, I know you can do it for the form but can you do it for a table contained in a form.

Cheers

[RuralGuy]

Hmm...Forms display tables in a variety of ways that for the most part are completely under *your* control. I'm not really sure what you are asking.

[bob500000]

Ok to make more sense I have a screenshot of the current form

I would like to remove the navigation options from the table as shown in the form.

[Amicron]

Go into the FORM PROPERTIES (Design View, Property Sheet) and set the NAVIGATION BUTTONS property to NO. While you're at it, if you're trying to prevent users from messing around, you might want to also turn off RECORD SELECTORS, and set some properties like ALLOW DELETIONS to NO.

[bob500000]

Go into the FORM PROPERTIES (Design View, Property Sheet) and set the NAVIGATION BUTTONS property to NO. While you're at it, if you're trying to prevent users from messing around, you might want to also turn off RECORD SELECTORS, and set some properties like ALLOW DELETIONS to NO.

Hi, I have tried this and it only removes the navigation from the form and not the table imported into the form! Any other suggestions would be great!

[focosi]

My understanding is that the reproduced table is actually a subform in datasheet view. If this is the case just select the subform only and apply the same property as before to the subform rather than to the mother form.

[bob500000]

My understanding is that the reproduced table is actually a subform in datasheet view. If this is the case just select the subform only and apply the same property as before to the subform rather than to the mother form.

Yo are correct on that, however if it were only that easy the navigation options do not show up when select the subform, I generally thinking now that it may be a restriction in access or I maybe wrong!

[focosi]

have you tried selecting right-clicking your form (used as subform) from the navigation pane and looking into property sheet ?

[bob500000]

have you tried selecting right-clicking your form (used as subform) from the navigation pane and looking into property sheet ?

Tried that one mate no joy on it! Any other ideas welcome, have a few other threads open and nearly cracked what I was trying do, if anyone's interested when the dv is complete I'll upload it, currently researching a copy function but doesn't seem to be possible I can copy whole a record but I want to change the format that you paste into word or excel, instead of it being a table and you have to individually change the size of the table. Any solutions welcome,

On a final note I also posted on about a dynamic search like google, well that's nearly complete too I have the basics so that will included once the db is ready, but any help on the above issues would be great!

Cheers

[boblarson]

You can't do what you are looking to do on a table. You would need to use a form for this.

With previous versions of Access you could drag and drop a table (or query) onto a form and it would create a subform and it would save as a subform. But in 2010 (and maybe 2007) you can drag and drop and it stays as a table (sort of). So, you may need to explicitly create a form from your table and then drop that form on the main form to be able to have control over certain things that you can't do from a table.

[Amicron]

Yep. What Bob said is 100% correct. You need to create a SUBFORM instead of using a table. Then you'll be able to play with the properties of the subform. Besides, you NEVER want your end-users playing directly with tables.