By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

If no data for dates entered, need message box

P: n/a
I enter data into a database that resides on our network. Other
employees can print reports from the database, but they have no way of
telling if I've entered all the data. For instance, on Mondays, I
have to enter 3 days of data - Friday, Saturday, and Sunday. Last
Monday, an employee came to me questioning the results on his
report. He had requested data from the weekend: Friday through
Sunday. But when he printed the report, I had only entered data from
Friday and Saturday. The report is based on a query where you enter a
beginning date and an ending date. Is there any code that can be put
in the OnClick event of the button the employee clicks to request the
report that will look at the dates and if no data has been entered for
that date range, a message box will come up that says something like
"data has only been entered through [Friday's date]"?

Thanks,
JD

Aug 1 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
What if you have a seperate query that you check for the dates in and it
returns only the dates with data, then you can put a sub report on your
report that shows what dates have data

<jd****@yahoo.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...
>I enter data into a database that resides on our network. Other
employees can print reports from the database, but they have no way of
telling if I've entered all the data. For instance, on Mondays, I
have to enter 3 days of data - Friday, Saturday, and Sunday. Last
Monday, an employee came to me questioning the results on his
report. He had requested data from the weekend: Friday through
Sunday. But when he printed the report, I had only entered data from
Friday and Saturday. The report is based on a query where you enter a
beginning date and an ending date. Is there any code that can be put
in the OnClick event of the button the employee clicks to request the
report that will look at the dates and if no data has been entered for
that date range, a message box will come up that says something like
"data has only been entered through [Friday's date]"?

Thanks,
JD

Aug 1 '07 #2

P: n/a
On Aug 1, 10:26 am, "Scott" <scott.n.j...@ns.sympatico.cawrote:
What if you have a seperate query that you check for the dates in and it
returns only the dates with data, then you can put a sub report on your
report that shows what dates have data
That's an idea....let me try that. Thanks.

Aug 1 '07 #3

P: n/a
I've been thinking about this and a subreport that shows what dates
have data won't work. We print reports all the time with a whole
fiscal year of data. That would make for a very busy subreport. I
think what I really need is some code that will run when the database
opens that will look at the table and come back with a message box
that tells the latest date entered. I'm sure this can be done, but I
can't seem to wrap my brain around it. Any ideas?

Thanks!
JD

Aug 3 '07 #4

P: n/a
Hi,
Have you conciderd having two dropdown boxes on the form whereby the
user selects a start date and selects an end date, this approach would
only allow valid dates to be selected provided
The dropdown boxes have that table as it's rowsource type and you in
the row source you would select distinct datefieldname.
bobh.

On Aug 3, 10:46 am, jdp...@yahoo.com wrote:
I've been thinking about this and a subreport that shows what dates
have data won't work. We print reports all the time with a whole
fiscal year of data. That would make for a very busy subreport. I
think what I really need is some code that will run when the database
opens that will look at the table and come back with a message box
that tells the latest date entered. I'm sure this can be done, but I
can't seem to wrap my brain around it. Any ideas?

Thanks!
JD

Aug 3 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.