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

Rabu, 17 April 2013

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

As per my previous suggestions, the line text box should be moved to the back. You can also set it to Locked and disabled.

Duane

----------------------------------------
> To: MS_Access_Professionals@yahoogroups.com
> From: access_kri@yahoo.com
> Date: Wed, 17 Apr 2013 16:33:35 +0000
> Subject: [MS_AccessPros] Re: How to display strikethrough when task is completed?
>
> Duane,
> There is one issue with your solution. Since the textbox containing the IIF statement is superimposed on the JobDescription text box, it is not allowing me to add new jobdescription or edit the job description. How to get over this issue- It should display strikethrough for completed jobs yet allow me to add new jobs or edit job descriptions. Thanks.
>
> Regards,
> kumar
>
> --- 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
> > >
> > >
> > >
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>