Search results for query: *

What do your underlying tables look like. How are you capturing the membership in multiple committees? Peter Caine caibo@wwdb.org

Thanks Rick; I was invoking the report from a control button on a form. I reopened my main form then my report selection form after issuing the hide window command and everything works perfectly. Peter Caine caibo@wwdb.org

I assume that your database is a MS Jet ( Access ) DB. If this is the case, create a query which provides the correct view of the data for the other program and alter the other program to access the query rather than the table. Peter Caine caibo@wwdb.org

Use a function to return the numeric value for use in the calculation. Function GetSeason(strSeason as String) as Integer Select Case UCase(Mid(strSeason,1,2)) Case "FA" GetSeason = 1 Case "SP" GetSeason = 2 Case "SU&quot...

My application hides the Database Window at startup. A subsequent call to select a report object in VBA code causes the Database Window to become visible. How can I hide the Database Window using VBA code? Peter Caine caibo@wwdb.org

I have Visual Studio installed. If you don't have VB or Visual studio, you could create your own string utility functions as follows;<br><br>Public Function IsDigit(strVar As String) As Boolean<br><br>IsDigit = False<br><br>' Check for Digit<br>If Asc(strVar) &gt; 47 And Asc(strVar) &lt; 58...

An alternative could be to use the IsDigit Function as follows.<br><br>Public Function GetDigits(strVal As String)<br><br>Dim i As Long<br><br>GetDigits = &quot;&quot;<br><br>For 1 = 1 to Len(strVal)<br>&nbsp;&nbsp;&nbsp;If IsDigit(Mid$(strVal,i,1)...

I need to be able to update distributed verions of the system.mdw file for group permissions as new objects are added to the application. Any tools for this or do I have to create them?

I need to be able to update table definitions on distributed copies of a custom application. Are there any tools that would help with this or do I have to write the VBA code from scratch?