Re: Macro error

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

From: WebTracer (randy_at_webtracersolutions.com)
Date: 08/26/04 

Date: 26 Aug 2004 08:45:09 -0700

Thanks for the thought - but that change produces the exact same error.
Unfortunately.

Any other thoughts?

Not sure if I mentioned it, but the macro runs perfectly in Access 2k
and XP, but upon conversion to 2k3 it fails. Weird - seems to me that
if it runs fine in the other 2 versions, it should certainly run OK in
2k3 - but alas, like a lot of MS things, what you think should happen
and what does happen are 2 TOTALLY different things.

Ken Snell [MVP] wrote:
> Try changing this step:
>
> SetValue [Forms]![Main].[Filter] "(([Call].[CallID]=" &
> [Forms]![brsCallStatus]![brsCallStatusSubform1].[Form]![Call ID] &
"))"
>
>
> to this step:
>
> SetValue [Forms]![Main].[Filter] "(([CallID]=" &
> [Forms]![brsCallStatus]![brsCallStatusSubform1].[Form]![Call ID] &
"))"
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "WebTracer" <randy@webtracersolutions.com> wrote in message
> news:cgirrr$i58@odah37.prod.google.com...
> > Sure.
> >
> > SelectCall1 ([brsCallStatusSubform1].[Form].[CurrentRecord])=0
> > StopMacro
> >
> >
> > SetValue [Forms]![Main].[AllowFilters] Yes
> >
> > SetValue [Forms]![Main].[Filter] "(([Call].[CallID]=" &
> > [Forms]![brsCallStatus]![brsCallStatusSubform1].[Form]![Call ID] &
"))"
> >
> > SetValue [Forms]![Main].[Caption] "Call ID: " &
> > [Forms]![brsCallStatus]![brsCallStatusSubform1].[Form]![Call ID]
> >
> > Close brsCallStatus No
> >
> > RunCommand ApplyFilterSort
> >
> > GoToControl CallPersonID
> >
> > The database is a help desk application. This form that runs this
is a
> > form that is used to select a call, a range of calls, or all calls.
> > When you hit OK, this macro (or one just like it, they all fail -
> > filter condition is the only change) runs. It fails, stating that
the
> > Active X item isn't installed or OLE DB object failed.
> >
> > Thanks
> >

Relevant Pages

  • Re: Copy/paste -- a workable workaround
    ... function also fails intermittently. ... We all use remote ... the macro won't fail. ... >>Run this via remote desktop and watch the clipboard ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Command Line switch: autorun
    ... and have this run whenever a given task in the Task Scheduler fails. ... You would not write the code within the Outlook VBA Editor itself. ... So I thought that running a macro that emails me would do it. ... >>> Reminder Manager, Extended Reminders, Attachment Options ...
    (microsoft.public.outlook.program_vba)
  • Re: cannot execute a shell command from vi
    ... Preben 'Peppe' Guldberg wrote: ... >> I wrote a macro for vi ... > I'm not sure what exact vi that is. ... > I guess this is one line (and that there is a space between -m and bin). ...
    (comp.editors)
  • Re: print a sample list of every font
    ... And note that you can modify the provided macro to produce any sample text ... I don't recall if this is still made clear in the introductory ... I really need to use this, as my font sample listings are woefully out of date. ... achievement, and who at the worst, if he fails, at least fails while ...
    (microsoft.public.word.docmanagement)
  • Re: Draw a Double Line in Word 2007?
    ... Assuming the ability to create buttons tied to a macro hasn't been taken ... Dim nStartVer As Single ... .Line.Style = msoLineThinThin ... achievement, and who at the worst, if he fails, at least fails while ...
    (microsoft.public.word.docmanagement)