Datasheet View in Form

[Jaap]

Hello, when click right mouse button, can't find Datasheet View any more as in the past?


I'm not able to carry out this command?
There is something to do please?


Regards,
Jaap

[June7]

I don't recall ever seeing the Datasheet option on shortcut menu when click on form in Navigation Pane. But I am still using 2010 so maybe something has changed.

It will show in shortcut when click on form as well as Views button on ribbon if the form's AllowDatasheetView property is set to yes.

[Jaap]

Thank you for replying,

Like to send attachment, I've made database empty, Compact and Repair done, and have made a Rar zip file of it with size: 1,48 KB (1.525 bytes)
But error appear after attach this file.

WinZip is needed in case of RarZip?

Regards,
Jaap

[pbaldy]

It doesn't look like rar is a supported extension. Just use the built-in Windows method to zip.

[davegri]

I'll bet this would be the cause...

[June7]

I already tested that. Changing the property has no effect on the shortcut menu in the Navigation Pane.

I doubt providing your db would be useful in analyzing this issue.

Even if you could attach an rar, I could not open it.

[davegri]

OP never mentioned Navigation Pane. Perhaps Jaap could tell us a bit more. Under what conditions were the two context menus obtained?

[Jaap]

Thank you, here the two different Form surroundings in the same database...



Regards Jaap

[isladogs]

This has already been answered indirectly but hopefully I can clarify this for the OP.

This is the standard context menu I have on most of my forms - form view / layout view and design view only:



The reason is that I only allow those views in the form property sheet (Access 2010) - design view is always allowed



However if I change all possible form views to Yes:




The context menu adds the additional items



So all you need to do is set Datasheet view to Yes on a suitable form

[Jaap]

Dear ridders52 and all the others, I'm very grateful for the help, now it's working fine again. big smile!!!
Sorry I didn't understand you directly.


Regards,
Jaap

[June7]

Interesting, my shortcut menu does not show the Cut/Copy/Paste options, greyed out or not, just not there. I do show BuildEvent and TabOrder. That is when I click on the Form button in upper left corner next to the ruler, different menu when clicking on form header. Clicking on object in Navigation Pane shows Cut/Copy/Paste options.

@ridders52, if you are using 2010 how do you get that menu?

[isladogs]

Hi June

Just by right clicking on a form in Form View!
Whereas if you do that in Design View you will instead get something like this (depending on where you click and which form types are enabled):

[June7]

Okay, had to be Single or Continuous not Datasheet form view. Click in middle of form. Clicking on header shows shorter menu. Guess I normally click on the header.

[isladogs]

Okay, had to be Single or Continuous not Datasheet form view. Click in middle of form. Clicking on header shows shorter menu. Guess I normally click on the header.

I get the same context menu anywhere in header/footer or detail sections of single or continuous forms.
I rarely use datasheet forms but, as you say, datasheet gives a different context menu

[June7]

Actually, when I said header, I meant the form caption area of the form window

Also, if I click directly over a control, then get even another shortcut menu.