Replies

By not work I should clarify. I mean it will show all the 2010 data not the next 30 days that I am looking for. I tried <=DateAdd("d",+30,Now()) . It gave me all tha data for 2010. Any other solutions? Thanks so much..

Yes it does start with an equal sign. I think there are using it as a control on a form….

Thanks John. I tried using the cide below and in the field name I got an error Name#. Did I do something wrong? Thanks..

DLookUp(“[event_desc]”,”[event_codes_outcome]”,”[code_num] = ” & chr(34) & Forms![EIRELCTIRR0A_qry]![CandidatesCPR_Frm]![event_outcome_cde] & chr(34))

Attached is a screen shot. the driver i am using is an merant 3.60 32 bit pracle 8 driver. The oracle db is 10.0….

Fixed Wendell. Thanks. someone modified the export query and added a field that the specification did not recognize. this caused the export to fail. once i removed the extraneous field in the query it work fine….

Yes eveything you mentioned is there? What else can it be?

I was able to send the email when I rem out the statment marked 10/07. It failed when I left in and me.ExemptCP = 0. Why would that make the email fail? I have records with a 0 value in the filter on the form?

Do While i < Me.Recordset.RecordCount

If Not Me.NewRecord Then
If Me.site_cp_readiness_status “Y” And Me.Send_No = 0 Then
‘ 10/07 rem statement If Me.site_cp_readiness_status “Y” And Me.Send_No = 0 And Me.ExemptCP = 0 Then
If strPrevSite Me.Site_ID Or intfirst = 0 Then
Call Send_Emailobject(strEmailName)
strPrevSite = Me.Site_ID
intfirst = 1
End If
Call Insert_Datarecon_EmailStatus(strEmailName)
ElseIf Me.Send_No = -1 Then
intSendFlag = 1

End If ‘Send_No = 0
i = i + 1
Else: Exit Do
End If ‘Not Me.NewRecord
If i < Me.Recordset.RecordCount Then
DoCmd.GoToRecord acDataForm, Me.Name, acNext

Ideally we would want to exclude that site from being sent an email.

That didn’t seem to work. It looks like it is sending the email but it’s not actually sending anything. A message box comes up and sys now outputting my attachments but when I check the sent box nothing is actually sent. Any thoughts? Thanks..

OS is XP.

can’t it’s a shared document and i don’t have control of it..

Works great Hans. Thank you so much!!!

Yes it means quarter and I would like to sort by quarter and year. Thanks..

Thanks Pat..

That was it Hans. I had some goofy dates in there. Once I got them out it ran ok..