Print Order!

[Bob V]

How can I make this code print Invoices in order of
[qryClientOnly,OwnerName].......Thanks for any Help.......Bob

Case "PrintInvoiceBatch"
Me.Caption = "Print Invoices Batch"
cmdStatement.Caption = "Print Invoices"

lbOwnerName.Visible = False
cbOwnerName.Visible = False


tbDateFrom.value = Format("01-" & Month(Now) & "-" & Year(Now),
"dd-mmm-yyyy")
tbDateTo.value = Format(Now, "dd-mmm-yyyy")
fraCreditType.Visible = False
lblCreditOnly.Visible = False
lblCreditTypeAll.Visible = False

fraSelectInvoice.Visible = False

 

[Tom Wickerath]

Hi Bob,

If you are talking about a report, the sort order is controlled in report
design using View > Sorting and Grouping. Reports do not use orders specified
in queries.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Bob V]

Thanks Tom, At the moment they are grouped by tblInvoice.InvoiceID if I
change this all the OwnerID Invoices go on to one Invoice and not separated.
I tried adding tblInvoice.OwnerID but the report does not recognize it.
So is it still possible to print in order OwnerID, InvoiceID so as when I
print all his invoices in the last 3 months would be together
Thanks for any help............Bob

Hi Bob,

If you are talking about a report, the sort order is controlled in report
design using View > Sorting and Grouping. Reports do not use orders
specified
in queries.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

How can I make this code print Invoices in order of
[qryClientOnly,OwnerName].......Thanks for any Help.......Bob

Case "PrintInvoiceBatch"
Me.Caption = "Print Invoices Batch"
cmdStatement.Caption = "Print Invoices"

lbOwnerName.Visible = False
cbOwnerName.Visible = False


tbDateFrom.value = Format("01-" & Month(Now) & "-" &
Year(Now),
"dd-mmm-yyyy")
tbDateTo.value = Format(Now, "dd-mmm-yyyy")
fraCreditType.Visible = False
lblCreditOnly.Visible = False
lblCreditTypeAll.Visible = False

fraSelectInvoice.Visible = False

 

[Tom Wickerath]

Hi Bob,

Please clarify your original question:
"How can I make this code print Invoices in order of
[qryClientOnly,OwnerName]"

What exactly do you mean by this? Can you provide some sample data?

I tried adding tblInvoice.OwnerID but the report does not recognize it.

Is this field in the report's recordset?

So is it still possible to print in order OwnerID, InvoiceID so as when I
print all his invoices in the last 3 months would be together

Possibly, if you can get your report to run correctly without (apparently)
complaining about OwnerID. Or is this an OwnerID field from a different table
(ie. not from tblInvoice)?

Have you tried grouping by a concatenated value: [OwnerID] & [InvoiceID] ?
Not really sure if this will be helpful, since I'm really not understanding
the issue yet.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Bob V]

Thanks Tom, Where do I find the Reports Recordset?
tblInvoice does have a OwnerID field as well
When I set the date range I am tring to sort the printing by the date range
and then OwnerID
tblInvoice.InvoiceID is Grouped Header and Footer on the report
Thanks for any help..Bob

Hi Bob,

Please clarify your original question:
"How can I make this code print Invoices in order of
[qryClientOnly,OwnerName]"

What exactly do you mean by this? Can you provide some sample data?

I tried adding tblInvoice.OwnerID but the report does not recognize it.

Is this field in the report's recordset?

So is it still possible to print in order OwnerID, InvoiceID so as when I
print all his invoices in the last 3 months would be together

Possibly, if you can get your report to run correctly without (apparently)
complaining about OwnerID. Or is this an OwnerID field from a different
table
(ie. not from tblInvoice)?

Have you tried grouping by a concatenated value: [OwnerID] & [InvoiceID] ?
Not really sure if this will be helpful, since I'm really not
understanding
the issue yet.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Thanks Tom, At the moment they are grouped by tblInvoice.InvoiceID if I
change this all the OwnerID Invoices go on to one Invoice and not
separated.
I tried adding tblInvoice.OwnerID but the report does not recognize it.
So is it still possible to print in order OwnerID, InvoiceID so as when I
print all his invoices in the last 3 months would be together
Thanks for any help............Bob

 

[Bob V]

Would this help:
Case "PrintInvoiceBatch"
If IsNull(tbDateFrom.value) Or tbDateFrom.value = "" Or
IsNull(tbDateTo.value) Or tbDateTo.value = "" Then
MsgBox "Please Enter the Begining Date and End Date.",
vbApplicationModal + vbInformation + vbOKOnly
Exit Sub
End If
Me.Visible = False
DoCmd.OpenReport "rptInvoiceBatch", acViewPreview, , , ,
"PrintInvoiceBatch"

Thanks Tom, Where do I find the Reports Recordset?
tblInvoice does have a OwnerID field as well
When I set the date range I am tring to sort the printing by the date
range and then OwnerID
tblInvoice.InvoiceID is Grouped Header and Footer on the report
Thanks for any help..Bob

Hi Bob,

Please clarify your original question:
"How can I make this code print Invoices in order of
[qryClientOnly,OwnerName]"

What exactly do you mean by this? Can you provide some sample data?

I tried adding tblInvoice.OwnerID but the report does not recognize it.

Is this field in the report's recordset?

So is it still possible to print in order OwnerID, InvoiceID so as when
I
print all his invoices in the last 3 months would be together

Possibly, if you can get your report to run correctly without
(apparently)
complaining about OwnerID. Or is this an OwnerID field from a different
table
(ie. not from tblInvoice)?

Have you tried grouping by a concatenated value: [OwnerID] & [InvoiceID]
?
Not really sure if this will be helpful, since I'm really not
understanding
the issue yet.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Thanks Tom, At the moment they are grouped by tblInvoice.InvoiceID if I
change this all the OwnerID Invoices go on to one Invoice and not
separated.
I tried adding tblInvoice.OwnerID but the report does not recognize it.
So is it still possible to print in order OwnerID, InvoiceID so as when
I
print all his invoices in the last 3 months would be together
Thanks for any help............Bob

 

[Tom Wickerath]

Hi Bob,

Honestly, what would be more helpful at this point is if you could answer
the questions I asked you in my second reply.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________