Recent content by Jonathan Lueb

Bob, I created a new main report and added the subreports and it worked. Something must have been wrong with the other main report. Thanks for your help! Jonathan

Bob, Thanks for the quick reply! I've tried that. It doesn't make a difference. I tried having a record source for the main report and I tried having no record source for the main report. In both instances I did not create a link. I also tried it with links. Any subreport does not show up when...

I have 2 Independent reports that I want to add to a main report. The main report just gives a title and the total number of records. One sub report is a summary of the total number of kids in each grade and gives the perentage of the whole. The other report is a summary of the ethinic...

How do you define a field type when a make-table query is run? It is creating a text field and it needs to be a memo field because it's truncating the data in the field because it is more than 255 characters. Can this be done by modifying the SQL code? Jonathan

I think I've solved just about all my issues. The only thing left is how to deal with words with appostophies such as "Mary's". If anybody has any suggestions I'd appriciate it. Here is the code as it stands. Public Function fnFormatString(strInput As String) As String Dim varCells As Variant...

Ok Wayne, I've solved that issue, on my own, with the following code: For c = 1 To Len(SearchCharacterSet) SearchChar = Mid(SearchCharacterSet, c, 1) CharCount = UBound(Split(strInput, SearchChar)) For d = 1 To CharCount CarPos = InStr(strInput, SearchChar) If Not...

Thanks Wayne! I've got my code up to this point. Public Function fnFormatString(strInput As String) As String Dim varCells As Variant Dim SearchCharacterSet As Variant Dim i As Long Dim c As Long Dim strTemp As String Dim strVar1 As String Dim strVar2 As String Dim SearchChar As String...

Wayne, Thanks a lot that was exactly what I needed. I knew it was simple! I needed to change IsNumber to IsNumeric but otherwise it worked great I can expand on that to make other formatting changes in the text which is what I needed. Thanks for the incredibly quick reply and the help!!! Jonathan

I need to evaluate a field that contains a sentence that has words and numbers (codes) that need formatting codes added. Example: In the beginning 7225 God 430 created the heavens 8064 and the earth 776. Needs to become: In the beginning{\super\cf6 7225} God{\super\cf6 430} created the...