Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Access SQL query IIF
If I've understood what you're trying to do correctly, your bracket looks to be in the wrong place IIF(`Policy Details`.`Class of Policy` = 'igi',`Introducer Details-Scheme`.`LetRes Comm`) AS `Comm`, Introducer Details-Scheme`.`Buildings Comm` AS Comm2`- Neilll
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
PopUP Transparent
I've had what i think could be a similar problem with a pop up form. The form did not display correctly. After opening the form I used the Form.Repaint Method forms.frmName.repaint this fixed my problem- Neilll
- Post #13
- Forum: Microsoft: Access Forms
-
Preview a report
Have you tried setting the forms Visible property to False in the Reports Open Event- Neilll
- Post #2
- Forum: Microsoft: Access Reports
-
Calling a Crystal Report from an Access 97 Form
Try looking at 149-160451 "Running Crystal Reports from Visual Basic" This shows how to use the Crystal Viewer. Just make sure the Database references include CRAXDRT.dll- Neilll
- Post #2
- Forum: Business Objects: Crystal Reports 4 Other topics
