PC Review


Reply
Thread Tools Rate Thread

detect where the user goes?!

 
 
=?Utf-8?B?RGFuaWVs?=
Guest
Posts: n/a
 
      6th Oct 2004
Hello,

In a form, I have set it up so that when the user sets the focus on a
specific field it displays certain other fields and then when it loses the
focus it hide those same field. My problem is that although I want to hide
these fields when the user goes elsewhere, I want them to remain visible
should the user select on of them How can I acheive this?

This is the function that is called by the field's lostfocus event:
Function HideForecastComments()

Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Label63].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Forecast Comments].Visible = False
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Create New Record].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto record 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go Back 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Go fwd 1].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![Goto Last].Visible = True
Forms![Drawing Management Frm]![Drawing History Frm
sous-formulaire].Form![RecordCounter].Visible = True

End Function

How can I detect where/what the user clicks? Basically, I would like it to
change the visibility as per the above function except when the user selects
control "Forecast Comments".

Thanks,

Daniel



 
Reply With Quote
 
 
 
 
=?Utf-8?B?bHdlbGxz?=
Guest
Posts: n/a
 
      7th Oct 2004
What do you mean goes elsewhere? If you mean going to a new form or closing
the existing form, set your function to the forms OnExit Event. This way the
forms fields will remain visible until you close the form. Will this help?

"Daniel" wrote:

> Hello,
>
> In a form, I have set it up so that when the user sets the focus on a
> specific field it displays certain other fields and then when it loses the
> focus it hide those same field. My problem is that although I want to hide
> these fields when the user goes elsewhere, I want them to remain visible
> should the user select on of them How can I acheive this?
>
> This is the function that is called by the field's lostfocus event:
> Function HideForecastComments()
>
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Label63].Visible = False
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Forecast Comments].Visible = False
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Create New Record].Visible = True
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Goto record 1].Visible = True
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Go Back 1].Visible = True
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Go fwd 1].Visible = True
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![Goto Last].Visible = True
> Forms![Drawing Management Frm]![Drawing History Frm
> sous-formulaire].Form![RecordCounter].Visible = True
>
> End Function
>
> How can I detect where/what the user clicks? Basically, I would like it to
> change the visibility as per the above function except when the user selects
> control "Forecast Comments".
>
> Thanks,
>
> Daniel
>
>
>

 
Reply With Quote
 
=?Utf-8?B?RGFuaWVs?=
Guest
Posts: n/a
 
      7th Oct 2004
Maybe I should explain myself a bit more to give you the full picture. I
have been asked to add more controls to an already filled form. Of course
they do not want me to increase the size of the form (they do not want to use
scroll bars....). Anyways, back to the issue at hand, the only solution that
I could come up with was to supperpose several control and try and control
their visibility (hence my problem).

In this specific case, I have had to superpose a commentary field over top
of custom navigation buttons and also added a Forecast control where the user
will input time estimates. Basically what I am trying to acheive, maybe I'm
going about it the wrong way?, is that when and only when the user sets the
focus on the Forecast control I want the comments control to become visible
and the navigation buttons disappear. Now for my problem, when the user
choses to go elsewhere, leave the Forecast control, if they set the focus on
the comments control it remains dominant but if they set the focus on any
other control the navigation button should become dominant instead.

I'm open to any other idea on how to resolve this little problem,

Daniel



"lwells" wrote:

> What do you mean goes elsewhere? If you mean going to a new form or closing
> the existing form, set your function to the forms OnExit Event. This way the
> forms fields will remain visible until you close the form. Will this help?
>
> "Daniel" wrote:
>
> > Hello,
> >
> > In a form, I have set it up so that when the user sets the focus on a
> > specific field it displays certain other fields and then when it loses the
> > focus it hide those same field. My problem is that although I want to hide
> > these fields when the user goes elsewhere, I want them to remain visible
> > should the user select on of them How can I acheive this?
> >
> > This is the function that is called by the field's lostfocus event:
> > Function HideForecastComments()
> >
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Label63].Visible = False
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Forecast Comments].Visible = False
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Create New Record].Visible = True
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Goto record 1].Visible = True
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Go Back 1].Visible = True
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Go fwd 1].Visible = True
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![Goto Last].Visible = True
> > Forms![Drawing Management Frm]![Drawing History Frm
> > sous-formulaire].Form![RecordCounter].Visible = True
> >
> > End Function
> >
> > How can I detect where/what the user clicks? Basically, I would like it to
> > change the visibility as per the above function except when the user selects
> > control "Forecast Comments".
> >
> > Thanks,
> >
> > Daniel
> >
> >
> >

 
Reply With Quote
 
=?Utf-8?B?TWF1cmljaW8gU2lsdmE=?=
Guest
Posts: n/a
 
      7th Oct 2004
It looks to me your problem can be better solved using a TabControl. With it
you could create pages of controls. If you don't want the tabs to appear, you
can change the style to buttons or even none (which will look like you are
doing now)

Have a look and let us know

Mauricio Silva

"Daniel" wrote:

> Maybe I should explain myself a bit more to give you the full picture. I
> have been asked to add more controls to an already filled form. Of course
> they do not want me to increase the size of the form (they do not want to use
> scroll bars....). Anyways, back to the issue at hand, the only solution that
> I could come up with was to supperpose several control and try and control
> their visibility (hence my problem).
>
> In this specific case, I have had to superpose a commentary field over top
> of custom navigation buttons and also added a Forecast control where the user
> will input time estimates. Basically what I am trying to acheive, maybe I'm
> going about it the wrong way?, is that when and only when the user sets the
> focus on the Forecast control I want the comments control to become visible
> and the navigation buttons disappear. Now for my problem, when the user
> choses to go elsewhere, leave the Forecast control, if they set the focus on
> the comments control it remains dominant but if they set the focus on any
> other control the navigation button should become dominant instead.
>
> I'm open to any other idea on how to resolve this little problem,
>
> Daniel
>
>
>
> "lwells" wrote:
>
> > What do you mean goes elsewhere? If you mean going to a new form or closing
> > the existing form, set your function to the forms OnExit Event. This way the
> > forms fields will remain visible until you close the form. Will this help?
> >
> > "Daniel" wrote:
> >
> > > Hello,
> > >
> > > In a form, I have set it up so that when the user sets the focus on a
> > > specific field it displays certain other fields and then when it loses the
> > > focus it hide those same field. My problem is that although I want to hide
> > > these fields when the user goes elsewhere, I want them to remain visible
> > > should the user select on of them How can I acheive this?
> > >
> > > This is the function that is called by the field's lostfocus event:
> > > Function HideForecastComments()
> > >
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Label63].Visible = False
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Forecast Comments].Visible = False
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Create New Record].Visible = True
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Goto record 1].Visible = True
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Go Back 1].Visible = True
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Go fwd 1].Visible = True
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![Goto Last].Visible = True
> > > Forms![Drawing Management Frm]![Drawing History Frm
> > > sous-formulaire].Form![RecordCounter].Visible = True
> > >
> > > End Function
> > >
> > > How can I detect where/what the user clicks? Basically, I would like it to
> > > change the visibility as per the above function except when the user selects
> > > control "Forecast Comments".
> > >
> > > Thanks,
> > >
> > > Daniel
> > >
> > >
> > >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
detect user Irene Microsoft Access Form Coding 11 27th May 2008 08:52 PM
detect the user Irene Microsoft Access 3 18th Apr 2008 07:38 PM
detect user Irene Microsoft Access Security 4 18th Apr 2008 02:05 AM
Detect in C# the name of the ASP.NET user. =?Utf-8?B?VmlsaGVsbQ==?= Microsoft ASP .NET 8 10th Aug 2007 10:21 AM
Detect changes from user =?Utf-8?B?Qm9i?= Microsoft VB .NET 1 14th May 2004 02:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:40 AM.