Ivo
|
| Posted: 06/26/2002, 6:36 AM |
|
My apologies if this question has already been answered:
Is it possible to hide a table if there is no data for the selection on this table...
Thanx in advance,
Ivo
PS: I'am using ASP with a Access databae
|
|
|
 |
Freeman Kusek
|
| Posted: 06/27/2002, 1:02 AM |
|
I assume you are using CodeCharge 2.0 in which case there is an article in the Tips & Articles secion on how to hide forms:
http://www.gotocode.com/art.asp?art_id=54&
However, your condition is unique because you want to hide a form if there are no records to be displayed. This will require you to execute an SQL statement in the Open event of the form to check whether any records will be displayed in the form. You can use the sSQL variable in the Open event to get the SQL squery that will be executed for the form. Once you get the result of the SQL query, then you can decide on whether or not to show the form.
|
|
|
|
Frans
|
| Posted: 06/28/2002, 1:28 AM |
|
Hello,
With PHP and Mysql it is. Probably also with other apps.
Create a grid Form. Select your table and Fields. Give a good Captionname because you have no Form Title. Assign no Form Title to it. Go to Form Properties>Common. Uncheck Allow Sorting, Allow Insert. Set Grid Type to Columnar. Uncheck Page Navigation and set Records to no value.
I've done several forms this way to hide the form if there is no corresponding data in it and it works very well.
|
|
|
|
|
