Help with If statement

[Guest]

I have a command button that when clicked, it brings up an input box. The
user has to put in a date (mm/dd/yyyy). I need an If statement that searches
the column, if the date typed in is in the column, of course it will bring up
the data. But if the date is not in the column, I need another input box to
come up that reads, 'Date not found, try again.' If the user doesn't want to
try again, then a command button to close the input box. (I'm not sure, but
that command button may be a default button)

Here is what I have to pull the correct date:

SELECT *
FROM tblInvLog
WHERE InvDt=[What is the invoice date? (mm/dd/yyyy)];

But again, I need an If statement that tells the user the date was not
found. Right now, if the date is not found, it still brings up the table, but
with no data.

Anybody have any ideas?

Thanks

 

[Guest]

Do your users a favor and use a control on a form to enter the date. You can
then check to make sure the date is in the report's record source prior to
attempting to open. Otherwise use the On No Data event of the report to
display a message and close the report.

 

[Guest]

Hi Duane,

Thanks for the repsonse, but the users' response isn't going on a report.
It's going on a form where the user can see all of the invoices that were
paid for that day, using the navigation buttons at the bottom of the form to
scroll through the invoices. I also wouldn't know what control to use, since
there will be so many invoice dates, (365 days x many years), I thought it
would just be easier instead of having to scroll through so many dates, to
just type in a date.

Do your users a favor and use a control on a form to enter the date. You can
then check to make sure the date is in the report's record source prior to
attempting to open. Otherwise use the On No Data event of the report to
display a message and close the report.

--
Duane Hookom
Microsoft Access MVP

I have a command button that when clicked, it brings up an input box. The
user has to put in a date (mm/dd/yyyy). I need an If statement that searches
the column, if the date typed in is in the column, of course it will bring up
the data. But if the date is not in the column, I need another input box to
come up that reads, 'Date not found, try again.' If the user doesn't want to
try again, then a command button to close the input box. (I'm not sure, but
that command button may be a default button)

Here is what I have to pull the correct date:

SELECT *
FROM tblInvLog
WHERE InvDt=[What is the invoice date? (mm/dd/yyyy)];

But again, I need an If statement that tells the user the date was not
found. Right now, if the date is not found, it still brings up the table, but
with no data.

Anybody have any ideas?

Thanks

 

[Guest]

Consider using the combo box wizard to create a combo box that finds a record
on your form. If you reference the invoice date as the row source of the
combo box, your users won't be able to enter a date that isn't in the table.

--
Duane Hookom
Microsoft Access MVP

Hi Duane,

Thanks for the repsonse, but the users' response isn't going on a report.
It's going on a form where the user can see all of the invoices that were
paid for that day, using the navigation buttons at the bottom of the form to
scroll through the invoices. I also wouldn't know what control to use, since
there will be so many invoice dates, (365 days x many years), I thought it
would just be easier instead of having to scroll through so many dates, to
just type in a date.

Do your users a favor and use a control on a form to enter the date. You can
then check to make sure the date is in the report's record source prior to
attempting to open. Otherwise use the On No Data event of the report to
display a message and close the report.

--
Duane Hookom
Microsoft Access MVP

I have a command button that when clicked, it brings up an input box. The
user has to put in a date (mm/dd/yyyy). I need an If statement that searches
the column, if the date typed in is in the column, of course it will bring up
the data. But if the date is not in the column, I need another input box to
come up that reads, 'Date not found, try again.' If the user doesn't want to
try again, then a command button to close the input box. (I'm not sure, but
that command button may be a default button)

Here is what I have to pull the correct date:

SELECT *
FROM tblInvLog
WHERE InvDt=[What is the invoice date? (mm/dd/yyyy)];

But again, I need an If statement that tells the user the date was not
found. Right now, if the date is not found, it still brings up the table, but
with no data.

Anybody have any ideas?

Thanks

 

[Guest]

Thanks Duane.

Consider using the combo box wizard to create a combo box that finds a record
on your form. If you reference the invoice date as the row source of the
combo box, your users won't be able to enter a date that isn't in the table.

--
Duane Hookom
Microsoft Access MVP

Hi Duane,

Thanks for the repsonse, but the users' response isn't going on a report.
It's going on a form where the user can see all of the invoices that were
paid for that day, using the navigation buttons at the bottom of the form to
scroll through the invoices. I also wouldn't know what control to use, since
there will be so many invoice dates, (365 days x many years), I thought it
would just be easier instead of having to scroll through so many dates, to
just type in a date.

Do your users a favor and use a control on a form to enter the date. You can
then check to make sure the date is in the report's record source prior to
attempting to open. Otherwise use the On No Data event of the report to
display a message and close the report.

--
Duane Hookom
Microsoft Access MVP


:

I have a command button that when clicked, it brings up an input box. The
user has to put in a date (mm/dd/yyyy). I need an If statement that searches
the column, if the date typed in is in the column, of course it will bring up
the data. But if the date is not in the column, I need another input box to
come up that reads, 'Date not found, try again.' If the user doesn't want to
try again, then a command button to close the input box. (I'm not sure, but
that command button may be a default button)

Here is what I have to pull the correct date:

SELECT *
FROM tblInvLog
WHERE InvDt=[What is the invoice date? (mm/dd/yyyy)];

But again, I need an If statement that tells the user the date was not
found. Right now, if the date is not found, it still brings up the table, but
with no data.

Anybody have any ideas?

Thanks