How to print all the records after each working day (1 Viewer)

[113hans]

Hi guys
I can print a current record using the command button I put in my sample
but I have to click 1 by 1 for each client
so I wish the button can print all the records after each working day in 1 click only
I think the code have to have a filter following the daily time or something like that
just don't know how to do it, please help me.

Here my sample

 

[The_Doc_Man]

If you have a date/time field then you could have something like this "air code."

SELECT bunch-of-fields FROM working-table WHERE DATE(entry-date-field) = DATE(NOW()) .... and other criteria.

 

[Cronk]

docmd.openreport "Report1",,,"Transdate=Date()"

 

[Pat Hartman]

Do not use Now() when you mean Date()

 

[The_Doc_Man]

Yeah, Pat, I've developed some sloppy habits. Date() by itself implies TODAY so could have left that out. Would have worked, but was sloppy.

 

[113hans]

docmd.openreport "Report1",,,"Transdate=Date()"

With or without "Transdate=Date()", it still print the current report, I can't explain that.

 

[113hans]

If you have a date/time field then you could have something like this "air code."

SELECT bunch-of-fields FROM working-table WHERE DATE(entry-date-field) = DATE(NOW()) .... and other criteria.

"Syntax error" the access-brother told me.

 

[The_Doc_Man]

When we send you "air code" it is not expected to run. It is just an example where you have to fill in the blanks with your list of fields, proper table names, and whatever other criteria are used for your selection. Since I don't open other people's databases for security reasons (... OK, I'm paranoid), I didn't know the field names and table names to use.

 

[Cronk]

DATE(NOW()) is not valid syntax

CDATE maybe but that would keep the hours/minutes with NOW()

 

[Cronk]

"Syntax error" the access-brother told me.

Works for me. Did you put 3 commas in? Transcribe it accurately?

 

[113hans]

Works for me. Did you put 3 commas in? Transcribe it accurately?

I put your code and @The_Doc_Man code in the sample, check it please.

 

[113hans]

When we send you "air code" it is not expected to run. It is just an example where you have to fill in the blanks with your list of fields, proper table names, and whatever other criteria are used for your selection. Since I don't open other people's databases for security reasons (... OK, I'm paranoid), I didn't know the field names and table names to use.

Not that paranoid, I think you just choose to see the risk that people usually miss.

 

[arnelgp]

here you can check "Arnel'l Print" button.

 

[113hans]

I encounter some error messages

Don't know how to know it

 

[arnelgp]

your Date Separator is Dot (.).
try this, I change the WhereCondition of OpenReport to:

IIf(Me.lstDayToPrint <> "All", "TransDate=#" & Format$(Replace$(Me.lstDayToPrint, ".", "/"), "mm/dd/yyyy") & "#", "(1=1)")

 

[113hans]

You mean this

I should change it to what: 01 - 04 - 2024 or 01 / 04 / 2024

 

[arnelgp]

if the last db i posed is working, no need to change your Locale Date/Time format.

 

[Cronk]

I put your code

And I wrote

  Docmd.OpenReport

And you put

 Docmd.outputTo

You'll see ArnelGP also uses docmd.OpenReport

 

[113hans]

And I wrote

  Docmd.OpenReport

And you put

 Docmd.outputTo

You'll see ArnelGP also uses docmd.OpenReport

I tried to adapt to my aim
Here I use only your code, it just print a current record, not all records in one day.

 

[113hans]

if the last db i posed is working, no need to change your Locale Date/Time format.

I don't change my Local Date/Time format but still a yellow warning