Re: am i doing something wrong or just beating my head on the big wall?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

ditto, thanks.

havent used the command before, altho have been thinking of setting up some
sort of memo field with some code to try running.

anyone have some simple examples of where they have used this command.

thanks.

jim

"Ook" <usenet@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OropLbVOFHA.1476@xxxxxxxxxxxxxxxxxxxxxxx
> Sweeeeeetttt :-)
>
>
> "Alan C. Sheffield" <asheffield @ park west gallery.com> wrote in message
> news:eh5OZjUOFHA.3808@xxxxxxxxxxxxxxxxxxxxxxx
> > how about:
> >
> > EXECSCRIPT('SET DELETED '+IIF(SET('Deleted')='ON','Off','On'))
> >
> > Alan Sheffield
> > Programmer
> > Park West Gallery
> >
> >
> > "jim sturtz" <jim@xxxxxxxxxxx> wrote in message
> > news:e3PCyPHOFHA.3076@xxxxxxxxxxxxxxxxxxxxxxx
> > > i cant figure out how to write a set deleted toggler as an IIF.
> > >
> > > macro, name expression, eval. nothing would work for me.
> > >
> > > i could get it with a two liner but then it doesnt really toggle
without
> > > re-executing the k line
> > >
> > > k=IIF(SET('Deleted')='ON','Off','On')
> > > SET DELETED &k && this works
> > >
> > >
> > > but when i tried variation of
> > > SET DELETED IIF(SET('Deleted')='ON',Off,On)
> > >
> > > i couldnt get anything except syntax errors.
> > >
> > > i am trying to make a function key toggle the set so finally made it
> work
> > as
> > > a function
> > >
> > >
> > >
> > > ****
> > > on key label f9 setchanger
> > >
> > > procedure setchanger
> > > DO CASE
> > > CASE SET('DELETED')='ON'
> > > SET DELETED OFF
> > > OTHERWISE
> > > SET DELETED ON
> > > ENDCASE
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: Button to edit additional field in continous subform - new problem
    ... OpenForm with the window mode acDialog, and pass the name of the control and the value in OpenArgs. ... Add 2 command buttons for Ok and Cancel. ... Is there a way to use a form for edit memo field instead of "RunCommand acCmdZoomBox"? ...
    (microsoft.public.access.forms)
  • Re: line spacing of memo field
    ... "Stephen Lebans" wrote: ... Could you tell me what command I can use to set the line spacing. ... I am using the VBA command "print" to print memo field in a report. ...
    (microsoft.public.access.reports)
  • Re: Please Help: Append New text to old text
    ... unbound textbox is used to enter the data into. ... and when the command button (now ... the other memo field is simply a temporary holding area. ... I place mine side by side with CommentsField so the ...
    (microsoft.public.access.formscoding)
  • RE: Unbound option group question
    ... after the gotorecord line in your command button click event. ... "steve a" wrote: ... Dim strCountry As String ... However the toggle button stays in shadow and cannot be ...
    (microsoft.public.access.forms)
  • Re: How do I get my command buttons to rebound after one click?
    ... buttons the first time it will automatically rebound? ... Private Sub Toggle50_MouseDown(Button As Integer, Shift As Integer, X As ... The behavior you mention is that of a Toggle Button, not a Command ...
    (microsoft.public.access.formscoding)