ACCESS FEED: [MS_AccessPros] Re: How to display strikethrough when task is completed?

Selasa, 16 April 2013

[MS_AccessPros] Re: How to display strikethrough when task is completed?

Thanks Duane,
It is now working the way I wanted. Thanks again.

Kind Regards,
kumar Iyer

--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
> Kumar,
>
> Your original question should have included the significant specification of StatusCode = 50. The solution depended on this basic fact.
>
>
> If your field and value are StatusCode and 50 then try:
> =IIf([StatusCode]=50,"----------------------------------------------------------","")
>
> Or
>
> =IIf([StatusCode]=50,String(30,"-"),"")
>
> You can replace the 30 with some other number.
>
>
> Duane Hookom MVP
> MS Access
>
> ----------------------------------------
> > To: MS_Access_Professionals@yahoogroups.com
> > From: access_kri@...
> > Date: Tue, 16 Apr 2013 16:20:16 +0000
> > Subject: [MS_AccessPros] Re: How to display strikethrough when task is completed?
> >
> > Dear Duane,
> > Sorry, I didn't understand your solution at first and hence got the idea of using line control, but it didn't work. So I tried your solution again. The strikethrough is visible at all times and not when the status is complete.
> >
> > I am having a field called Status code and it is storing value of status code 10=Reported, 20=Planned, 30=Scheduled, 40=Inprogress and 50=completed.
> >
> > I desire that when I update the statuscode field to 50 ie.completed, the jobDescription field should display a strikethrough. For other statuses, it should not display the strike through.
> >
> > Thanks and Regards,
> > Kumar
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > >
> > > Kumar,
> > >
> > >
> > > I'm not sure why you didn't follow the instructions that I provided. I didn't suggest anything involving code. There was no line control. There was nothing to do with a visible property.
> > >
> > > I had opened my sandbox database, created new form and tested this prior to replying back to your question.
> > >
> > > Duane Hookom MVP
> > > MS Access
> > >
> > >
> > > ----------------------------------------
> > > > To: MS_Access_Professionals@yahoogroups.com
> > > > From: access_kri@
> > > > Date: Mon, 15 Apr 2013 16:17:12 +0000
> > > > Subject: [MS_AccessPros] Re: How to display strikethrough when task is completed?
> > > >
> > > > Dear Duane,
> > > > I included a line on jobDescription textbox and set its visbile property to no. Then on the form current event procedure, I wrote a if statement but it is making the line visible even when the status is other than complete. I am not able to figure it out why. Please guide
> > > >
> > > > Private Sub Form_Current()
> > > > If Statuscode = 50 Then
> > > > Line239.Visible = True
> > > > Else: Line239.Visible = False
> > > > End If
> > > >
> > > > Regards,
> > > > kumar
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > > > >
> > > > > Kumar,
> > > > >
> > > > > You can add a text box behind the JobDescription text box. Set the Control Source of the new text box to:
> > > > >
> > > > > =IIf([Completed],"----------------------------------------------------------","")
> > > > >
> > > > >
> > > > > Make sure the JobDescription text box background is transparent.
> > > > >
> > > > > Duane Hookom MVP
> > > > > MS Access
> > > > >
> > > > > -
> > > > >
> > > > > ---------------------------------------
> > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > From: access_kri@
> > > > > > Date: Mon, 15 Apr 2013 13:12:08 +0000
> > > > > > Subject: Re: [MS_AccessPros] How to display strikethrough when task is completed?
> > > > > >
> > > > > > Dear Duane,
> > > > > > I want the strikethrough displayed in the form as it is an entry cum dispaly form.
> > > > > >
> > > > > > Thanks and Regards,
> > > > > > Kumar
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@> wrote:
> > > > > > >
> > > > > > > Do you want to display this on a form or report? Duane Hookom MVPMS Access
> > > > > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > > > > From: access_kri@
> > > > > > > > Date: Mon, 15 Apr 2013 07:48:01 +0000
> > > > > > > > Subject: [MS_AccessPros] How to display strikethrough when task is completed?
> > > > > > > >
> > > > > > > > Dear All,
> > > > > > > > I am using Laundrylist Access 2007 database. I want that as soon as I update the Status to "Completed", the JobDescription should display a strikethrough. I am now using the conditional formating to change the shade for completed jobs. However, it gives pleasure when you strike off jobs from your pending list. Please help whether I can accomplish this through conditional formating or through VBA.
> > > > > > > >
> > > > > > > > Thanks and Regards,
> > > > > > > > Kumar
> > > > >
> > > >
> > > >
> > > >
> > > >
> > > > ------------------------------------
> > > >
> > > > Yahoo! Groups Links
> > > >
> > > >
> > > >
> > >
> >
> >
> >
> >
> > ------------------------------------
> >
> > Yahoo! Groups Links
> >
> >
> >
>