CROSSTAB Report with dynamic column headings 2

[vig]

I need help with the above.&nbsp;&nbsp;Since I am not a programmer, I used this process. 1. Created crosstab.(Project#=Row Head) (Work Date=Column Head) Hours=Value. 2. Named it EmployeeSales. 3. Copied the Developers Solutions &quot;Employee SalesDialogBod&quot; Form and EmployeeSalesReport into my database. The crosstab seem to work but when I try to preview the report from EmployeeSalesDialogBox I get a Compile error...In the Private Sub_Report, line 7 --If not (Is loaded(EmployeeSalesDialogBox)/ Then<br><br>What to do???what's my next step???any help will be appreciated. Detail please.&nbsp;&nbsp;Need this done this week.<br>Thanks.

 

[jimmythegeek]

1) Do you have the &quot;IsLoaded&quot; Function in your database? This is not an Access Built-in function. If you need it, I have it.<br>2) The syntax is wrong: If Not IsLoaded(&quot;EmployeeSalesDialogBox&quot Then ...<br><br>Let us know if either of these help.<br><br><br> <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href=

http://www.cgeek.com>CompuGEEKS</a><br>Custom

Application Development

 

[vig]

How do I know if the &quot;Is Loaded&quot; function is in my database?? Thanks.

 

[vig]

The routine below is in the database.&nbsp;&nbsp;I changed the dates to reflect test data.&nbsp;&nbsp;I searched for &quot;Is Loaded&quot; and found nothing. <br><br>Private Sub Form_Load()<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;'&nbsp;&nbsp;Used by Developer Solutions to return records for example.<br>&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;'&nbsp;&nbsp;Enter parameters in BeginningDate and EndingDate text boxes when<br>&nbsp;&nbsp;&nbsp;&nbsp;'&nbsp;&nbsp;form is loaded.<br>&nbsp;&nbsp;&nbsp;&nbsp;Me!SelectDate = #4/20/00#<br>&nbsp;&nbsp;&nbsp;&nbsp;Me!BeginningDate = #4/20/00#<br>&nbsp;&nbsp;&nbsp;&nbsp;Me!EndingDate = #4/28/00#<br><br>Thanks again for your help. As you can tell I reallllly need it. <br>&nbsp;&nbsp;&nbsp;&nbsp;<br>End Sub

 

[elizabeth]

Look in the Developers Solution database under Modules, there is a custom module named &quot;IsLoaded&quot;. Copy and paste that module into a new module in your database.

 

[vig]

Got it going. Thanks to Elizabeth and Jim.