Report in ADP Not always showing all Data

J

J Arty

I have the following code in a form:

Private Sub btnOk_Click()
Dim strDocName, strDocName1 As String

If IsNull(Me.Num.Value) Then
strDocName = "Receipt3"

DoCmd.OpenReport strDocName, acViewDesign
Reports!Receipt3.RecordSource = "select * FROM OrderReceivedTbl" _
& " where Dater >= '" _
& Me.Datef.Value & "' AND Dater <= '" _
& Me.Datet.Value & "'ORDER BY OrderNumber"
DoCmd.OpenReport strDocName, acViewPreview
Else
strDocName1 = "Receipt3"

DoCmd.OpenReport strDocName1, acViewDesign
Reports!Receipt3.RecordSource = "select * FROM OrderReceivedTbl" _
& " where Dater >= '" _
& Me.Datef.Value & "' AND Dater <= '" _
& Me.Datet.Value & "'AND Num = '" _
& Me.Num.Value & "'ORDER BY OrderNumber"
DoCmd.OpenReport strDocName1, acViewPreview
End If
End Sub

It is run after the user imports some texte files they receive by email from
the parent company.... They download all the files, and then run the import
module... After importing they go to print a report off all the records
imported...

The problem is this, sometimes the records of the last file imported don't
show in the report...
example... They import 04101901.txt, 04101902.txt... the firs file has 3
records and the next file 2....
only the records of the first file show...

Can anyone help me with this issue...

J
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top