Message Box for a certain condition.

  • Thread starter Thread starter Peter
  • Start date Start date
P

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
 
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
 
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
 
Try:
WHERE [Job Sheet].[Date Billed] Is Null


--
Duane Hookom
Microsoft Access MVP


Peter said:
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


Peter said:
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
Click to expand...
Click to expand...
 
Dear Duane & Tom,
Thanks for your help. Worked well. I tried
everything except seperating IsNull.

Much appreciated

Peter
--
Aussie


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


--
Duane Hookom
Microsoft Access MVP


Peter said:
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


Peter said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top