Re: DoCmd.OpenReport

The fields are set to text and the reports are working off queries, of
course. I'm not sure what you mean by what the value of the field is when it
fails. If the incorrect information is put in the parameter, then the
actions will fail and no reports will come up. I hope that answered your
question.

In this case, however, there are - in fact - reports for these "SAIDPARTNERS"

I hope that answered your question.


"Dirk Goldgar" wrote:

"TechTutors" <TechTutors@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B4B11EFD-A076-4894-A2D9-DDE529C4E4CC@xxxxxxxxxxxxxxxx
Dim ReportName

If Me.Action = 1 Then ReportName = "Rpt_ActivationBounty_Detail"
If Me.Action = 2 Then ReportName = "Rpt_RevenueShare_Detail"
If Me.Action = 3 Then ReportName = "Rpt_ClientSummary"
If Me.Action = 4 Then ReportName = "Rpt_CheckRequisition"
If Me.Action = 5 Then ReportName = "Rpt_ItemCodes_NONVAR_AUDIT"
If Me.Action = 6 Then ReportName = "Rpt_ItemCodes_VAR_AUDIT"

DoCmd.OpenReport ReportName, acViewPreview, , "Partner_ID=" & Me.Lkp



The client selects a Partner from a drop-down list... Then selects which
report they want to open for that Partner. They Hit GO! and an "enter
parameter" fields comes up asking them to type the Partner_ID... They
type
it in and it works just fine...

... Except for a handful of partners... I recieve a Run-Time error 3075...
Syntax error (missing operator) in query expression
'(Partner_ID=SAIDPARTNER)'.


What's the value of Me.Lkp when it fails? What type of field is Partner_ID?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.

Relevant Pages

  • coreutils-6.9.91 released (bug-fix-only)
    ... Coreutils version 6.9.91 has been released. ... There has been unusually few reports of problems with ... If that command fails because you don't have the required public key, ...
    (gnu.announce)
  • Re: Best way to copy users home areas onto a new drive
    ... additional features but where xcopy.exe fails, ... It has most of the features ... to copy permissions press F5 instread of drag-and-drop, ... Another tool with good reports is XXCOPY. ...
    (microsoft.public.windows.server.general)
  • Re: Why cant I print reports on Citrix network?
    ... Printer set up is a bit obscure on Citrix. ... to fail, and fails the worst, if there is any kind of problem. ... I'm trying to help a user who is not able to print reports in an Access ... database is on a network file server. ...
    (microsoft.public.access.reports)
  • [SLE] hp 6270 usb scanner detection/setup
    ... sane-find-scanner detects it and reports it ... But then scanimage -L, ... me about it, fails to find it. ... xscanimage also fails. ...
    (SuSE)
  • Re: Improper Detection of CD Type?
    ... check of its device and device driver as being RW. ... screen reports the drive as being simple a CD drive with no reference to ... On the "Recording" tab, make sure there's a tick in "Enable CD ... What exactly do you mean by "attempts to write to a blank CD fails" - what ...
    (microsoft.public.windowsxp.hardware)
Quantcast