Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Wisconsin, USA
    Posts
    160
    Thanks
    1
    Thanked 0 Times in 0 Posts

    stored parameter

    Am using Access db with VB 6 and Crystal Reports. CR9 does not play nice with OS 7 64bit, all reports cause the program to crash. And when using CR XI, the newer version of the report writer, in three of the reports on name tags, this is the error msg 'Can not find QE property'.

    The form and report use a Union All Select query.
    Code:
    SELECT FirstName, LastName, MaidenName, ClassYear, ClassPhoto, 
         ClassYear as SortYear, Lastname AS SortName, 1 AS SortOrder
    FROM Members
    WHERE NumAttend>0 
    UNION ALL SELECT Spouse, LastName, Null, Null, Null, Classyear, Lastname, 2
    FROM Members 
    WHERE NumAttend>1
    ORDER BY SortYear, SortName, SortOrder
    If the code is commented in the form and the report, the name tags print without photos.

    This code in either the form
    Code:
    Private Sub crSection_Format(ByVal pFormattingInfo As Object)
        On Error GoTo ErrHandle
    
        Set crSection.ReportObjects("Classmate").FormattedPicture = _
            LoadPicture(Report.Sections("DetailSection3").ReportObjects("PicFile").Value)
    End Sub
    or in the report
    Code:
    Private Sub DetailSection1_Format(ByVal pFormattingInfo As Object)
      Set crNameTagsAdhesive.Classmate.FormattedPicture = _
        LoadPicture(crNameTagsAdhesive.PicFile.Value)
    End Sub
    creates the error.

    Thought a stored procedure might work but my understanding is the procedure is entered into the design view in Access which does not show up when using a Union All Select parameter.

    I'm stumped. Any ideas would be great.
    Thanks

    Kim

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Can you clarify a few things please? What is OS 7 64-bit? Is it Windows 7 64-bit? Also, how are the photos stored? The SELECT statement suggests it is stored in an Access table, but the more usual solution is to store the file name and path in a text field and dynamically link to the photo that way. Unfortunately, I'm not familiar with Crystal Reports - I've never found a reporting need that couldn't be handled with the Access reports capability. Finally, I don't believe a stored procedure would help you - for one thing they only are useful if your data is being stored in SQL Server. If I were faced with your situation, I would end up redesigning the forms and reports in Access and not use VB6 or Crystal, but I realize that may not be an option. Hopefully someone with Crystal experience can offer some suggestions.
    Wendell

  3. #3
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Wisconsin, USA
    Posts
    160
    Thanks
    1
    Thanked 0 Times in 0 Posts
    The Operating System is indeed Windows 7 64-bit. The photos are placed in a directory and the path is stored in an Access database.

    Your suggestion to redesign is not an option. but thanx for your input.
    Thanks

    Kim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •