INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...This was the ONLY place that I could find information that I could use to resolve the problem. So thanks once again to member TomSark and the SQL forum!..."
Geography
Where in the world do Tek-Tips members come from?
|
 Alert user when number is skipped
|
|
|
itsuit (IS/IT--Management) |
21 Jan 09 11:38 |
I use an Access 2000 report to create checks based on information in an external ODBC database. I'd like to have the user alerted if a check number in the report is skipped (the check number comes from a field in the external view and is stored as a number).
Any help is appreciated. |
|
Tek-Tips Forums is Member Supported. Click Here to donate.
|
pwise (Programmer) |
21 Jan 09 11:53 |
Create A numbers table 1 field digitid with numbers from 1 to ....... create a query AllChecknums CODESelect digitid
from numbers
inner join (Select min(Checkno)mincheckno,max (checkno) maxcheckno
from ExternalTable)
on digitid between mincheckno and maxcheckno your recordsource on the report should be CODESelect digitid from AllChecknums
left join ExternalTable
on ExternalTable.checknum = AllChecknums.digitid on the report add text box with this control source CODE=nz(ExternalTable.checknum,AllChecknums.digitid)+ " is missing in ExternalTable" |
|
|
 |
|
