Kamis, 10 Mei 2012

Re: [MS_AccessPros] Re: Problem closing a datasheet

 

Hi Clive
 
Thankyou for your quick response suggestions.
 
I have gone for the double click on a field option - it seems to work fine.
 
cheers
 
Phil
 
 

________________________________
From: Clive <zctek@aol.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, 9 May 2012, 11:09
Subject: [MS_AccessPros] Re: Problem closing a datasheet

 
Hi Phil,

The cleanest way is to show your Form as a subform
in in a new form.

By doing that you can have a a close button on the
new outer form and you can also have the luxury of
a command button to toggle the subform between Form
and Datasheet views.

Alternatively you could use a double-click Event
on one or more of your Form Fields to close the
form. I use that sometimes on databases for my own
use only but for users you need some way of
indicating that the facility is available.

Hope that helps.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> Hi
>
> I have hidden the ribbon for certain users.
>
> If they open a form in form view they can right click to give them an option to change to datasheet view.
>
> If they stay in window mode I don't have a problem but ...
>
> If they have maximised the form before they go into datasheet view there seems to then be no facility to close the datasheet as right click no longer shows a menu to either go back to form view or close.
>
> I think the close button appears in the ribbon - but as I said I have hidden the ribbon for these users?
>
> Any ideas ho they can close the form from maximised datasheet view?
>
> cheers
>
> Phil
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar