Search on dates

[BobNTN]

It is working this morning Bob. Played around with the docmd statement. I simply now have

docmd.OpenQuery "QryInv2Tbl"

and nothing else.

Curious thing though, it will not append the exact same record more than once. Not that it will need to other than during testing, but I found that curious.

 

[HiTechCoach]

It is working this morning Bob. Played around with the docmd statement. I simply now have

docmd.OpenQuery "QryInv2Tbl"

and nothing else.

Curious thing though, it will not append the exact same record more than once. Not that it will need to other than during testing, but I found that curious.

if it is not allowing duplicates, I find that is usually because you have an index or primary key set to "No Dups."

 

[BobNTN]

I got that ironed out coach. Thanks.

Let me ask another question.

Is there a way to print 2 or 3 different reports from the one search form ?
As in, print the invoice, close it which saves that to a table, (that all works) then auto opens a second report that uses the same inputs from the search form then print, close (no save) then auto opens a third report using the same inputs from the form ?

I suppose that would involve a lot of code ?

 

[BobNTN]

Never mind, that's a dumb question.
Each report would be using different queries.

Thanks a lot for the help.

 

[HiTechCoach]

I got that ironed out coach. Thanks.

Let me ask another question.

Is there a way to print 2 or 3 different reports from the one search form ?
As in, print the invoice, close it which saves that to a table, (that all works) then auto opens a second report that uses the same inputs from the search form then print, close (no save) then auto opens a third report using the same inputs from the form ?

I suppose that would involve a lot of code ?

As long as the same the form that collected the data range is still opened so that it can be referenced, it can be used by multiple objects. You could have 10 reports and 20 queries all referencing the same form for criteria at the same time!

 

[BobNTN]

That's great.
So how do I open a report at the closing of another ?
I am running an append query 'on close' of this report.

 

[HiTechCoach]

one possible way would be to add code to the close event to open the next report.