Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: Images Missing in Acces Report

    Hi
    We print Labels with student Images , using MS Access.
    The Images are stored in a file system and while printing the images are retrived using the student Id.
    Each sheet has 10 labels and it has to print 10 JPG images per sheet.
    The first few pages say (50) are fine, but after the 50 images are either duplicated in labels or missing.
    If we print selective then the sheets are fine (say Student ID range).
    Any bulk print in excess of 100pages, this behaviour is seen.
    The systems throws no error and we have to check each sheet to verufy.
    We print about 35000 labels and it is a pain to review, check and reprint.

    The following is the code used for reference.
    --------------------------------------------------------
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    On Error Resume Next
    Dim varfile As Variant
    FNAME = Null
    IMAGE.Visible = False
    If GENDER = 1 Then
    MF = "m"
    Else
    MF = "f"
    End If
    If SRC = "N" Then
    FN = "I:\I2k9\" & [APP_NO] & MF & ".jpg"
    Else
    FN = "I:\m2k9\" & [APP_NO] & ".jpg"
    End If

    varfile = Dir(FN)
    If varfile <> "" Then
    FNAME = FN
    Else
    FNAME = Null
    End If
    If Not IsNull(FNAME) Then
    IMAGE.Visible = True
    IMAGE.Picture = FNAME
    End If
    End Sub
    ------------------------------------------------
    I am running this report on 2GB RAM system.
    Even If I run on smaller PC's the symptoms are same, more than 100 sheets has images duplicated or missing.

    Any help is appreciated.
    -Ramdas Sunkari
    svsramdas@gmail.com
    Last edited by rsunkari; 05-04-09 at 08:04. Reason: More relevant title

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    you may well be blowing the system resources. There may not be a solution to your problem, but there may be a work around. generate the report in blocks, say 10 pages per block. you could automate this say as a form which calls the report with a range and repeats until the complete print run is comleted

    Ive seen similar problems before with memory leaks and other design/testing flaws
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2009
    Posts
    2
    Thanks
    But Did anyone reported this to MS ?
    Or is it something we have to live with ?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by rsunkari
    Thanks
    But Did anyone reported this to MS ?
    Or is it something we have to live with ?
    I don't know what is causing the porblems, I'm only surmising (guessing). If I was in your position, and I had a report which worked for a small amount fo data, but not a large amount, and was dabbling with images memory leaks/shortage of system resources would be me first guess

    having diagnosed a symptom I'd then do a google to see if it was a common problem. if I was sure my report wasn't leaking resources then I'd suspect a program fault, design a workaround and move on.

    I'd also be tempted to reboot the machine which ran the reports afterwards jsut to make sure the system resourcers aren't further compromised
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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