Date on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know if I did this correctly. I have two reports which run off of
queries that require a date to be given when the query is ran. One report has
two queries and both need a date inputed in. So that means everytime a user
wants to open the report they have to put in the date twice. And when they
print the report or email the report snapshot, the date needs to put in
again.
Is there any way to simplify this so the date is asked for only once?
 
Yes, build a pop-up form with a date field (you could even put a
date-picker) and then call that field in your queries. This is a very
common question. If you will search before you post a new thread, you will
often find the answer yourself. That is why the newsgroups keep historical
posts out here.

Rick B
 
Thank you for your advice. Right now I have one button on a form I made to
act like a switchboard that has "sendobject" macro which generates the two
reports individually I want emailed out. When the reports are generated it
ask for the dates still. Is there a way around this? Can I place the
sendobject button on the popup as well?
 
Just put the date field on the form where you have your send button. Fill
it in before clicking that button.

Rick B
 
I don't know....I just can't get it right. It may be just a Monday or because
my expertise is limited and that is an exaggeration in itself. I can open
the report, I just can't get it to email automatically. I click the button
and the report opens than it is another step to email. Before, I had the
report generated and a new message opened up with the report attached and
ready to go (I just didn't like putting the date in more than once). I am
using macros because it is the only thing I know right now. I am not to sure
about the Visual Basic side to it that I keep reading. Yes, I have searched
the newsgroup but it all seems to be visual basics I even tried printing out
some of the code so I could type it in, still not working like I want it.
Sorry if I am to much of a bother...
 
Back
Top