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
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