Message Box for a certain condition.

[Peter]

I have developed a job sheet and time sheet database with a billing function.

I want a warning box to pop up when somebody tries to enter their time on
the time sheet and they select a job that has already been completed and
billed that will warn them that the job they selected has already been billed.

Better still something that will prevent them from entering their time on
the time sheet for a job that has already been billed.

Can anyone help?

Thanks,

Peter

 

[Duane Hookom]

Use a combo box on your job sheet form that doesn't include closed jobs.

 

[Tom van Stiphout]

On Fri, 22 Aug 2008 19:02:00 -0700, Peter

Your dropdown list with jobs could have an underlying query like:
select JobID, JobName
from Jobs
where JobStatus <> "Closed"

-Tom.
Microsoft Access MVP

 

[Peter]

Thanks for the answers.

I am having trouble to get it to work not being very familiar with SQL. I am
inserting my WHERE clause before ORDER BY but having trouble with the grammar
I think. The selection criteria works off the Date Billed field in the Job
Sheet. I want to load all job codes into the Time Sheet form that have no
entry in the Date Billed field on the Job Sheet.

I have tried a number of things but none work. E.g. WHERE [Job Sheet].[Date
Billed] = #00/00/00#

Thanks

Peter

 

[Duane Hookom]

Try:
WHERE [Job Sheet].[Date Billed] Is Null


--
Duane Hookom
Microsoft Access MVP

Thanks for the answers.

I am having trouble to get it to work not being very familiar with SQL. I am
inserting my WHERE clause before ORDER BY but having trouble with the grammar
I think. The selection criteria works off the Date Billed field in the Job
Sheet. I want to load all job codes into the Time Sheet form that have no
entry in the Date Billed field on the Job Sheet.

I have tried a number of things but none work. E.g. WHERE [Job Sheet].[Date
Billed] = #00/00/00#

Thanks

Peter
--
Aussie

I have developed a job sheet and time sheet database with a billing function.

I want a warning box to pop up when somebody tries to enter their time on
the time sheet and they select a job that has already been completed and
billed that will warn them that the job they selected has already been billed.

Better still something that will prevent them from entering their time on
the time sheet for a job that has already been billed.

Can anyone help?

Thanks,

Peter

 

[Peter]

Dear Duane & Tom,
Thanks for your help. Worked well. I tried
everything except seperating IsNull.

Much appreciated

Peter
--
Aussie

Try:
WHERE [Job Sheet].[Date Billed] Is Null


--
Duane Hookom
Microsoft Access MVP

Thanks for the answers.

I am having trouble to get it to work not being very familiar with SQL. I am
inserting my WHERE clause before ORDER BY but having trouble with the grammar
I think. The selection criteria works off the Date Billed field in the Job
Sheet. I want to load all job codes into the Time Sheet form that have no
entry in the Date Billed field on the Job Sheet.

I have tried a number of things but none work. E.g. WHERE [Job Sheet].[Date
Billed] = #00/00/00#

Thanks

Peter
--
Aussie

I have developed a job sheet and time sheet database with a billing function.

I want a warning box to pop up when somebody tries to enter their time on
the time sheet and they select a job that has already been completed and
billed that will warn them that the job they selected has already been billed.

Better still something that will prevent them from entering their time on
the time sheet for a job that has already been billed.

Can anyone help?

Thanks,

Peter