Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Access openform code fails

Access openform code fails

Access openform code fails

I have a database that stores bitmap images (filename and path only) related to specific items in a table. I have a form tied to the table that lists the images that relate to the current item. The form has a command button that allows me to pick images from the list and view them in a separate image viewer form (in theory, anyway; I get an error message that indicates that the open form action was canceled).

I copied and modified the code from a developer's website (with the author's permission). The code came in the form of a sample address book database; I just changed the various form and table names to reflect the names in my database. The sample database works fine, so I know that the code is ok.

The form viewer works if I open it separately- it doesn't filter the images and just lists them all. The code works up until it gets to the openform action, at which point it triggers the error code.

Here is the code, any suggestions?

Private Sub cmdViewImage_Click()

   On Error GoTo Err_Handler

   Dim strFilter As String, strImageList As String
   Dim varItem As Variant
   ' open Images form modally if image(s) selected from list
   If Me!lstImages.ItemsSelected.Count > 0 Then
       ' build comma separated string of ImageIDs selected
       For Each varItem In Me!lstImages.ItemsSelected
           strImageList = strImageList & "," & lstImages.Column(0, varItem)
       Next varItem
       ' discard leading comma
       strImageList = Mid$(strImageList, 2)
       strFilter = "ArtifactID = " & Me!ArtifactID & _
       " And ImageID In (" & strImageList & ")"
       Me.Visible = False
       DoCmd.OpenForm "frmImages", WhereCondition:=strFilter, _
                                   WindowMode:=acDialog, _
       MsgBox "At least one image must be selected from the list.", vbInformation, "Images"
   End If
   Exit Sub
   MsgBox Err.Description & " (" & Err.Number & ")", vbExclamation, "Error"
   Resume Exit_here
End Sub

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Research Report - How Engineers are Using Remote Access
Remote access enables engineers to work from anywhere provided they have an internet connection. We surveyed our audience of engineers, designers and product managers to learn how they use remote access within their organizations. We wanted to know which industries have adopted remote access, which software they are using, and what features matter most. Download Now
eBook - Managing the Context of Product Complexity Using the Digital Twin
Keeping track of changes to complex products is difficult—think Aerospace & Defense equipment, new generations of commercial aircraft, and software-based automobiles. A new way to managing the digital context of the physical product is required and the answer is the Digital Twin. This ebook explores the opportunity available for Operations and Maintenance for the Digital Twin. Download Now
White Paper - Trends in Industrial Filtration
Substantial progress has been made in filtration technologies in recent years. New filter media materials, designs and processes have led to filters that are more efficient, reliable, compact and longer lasting. This white paper will discuss the various trends that are impacting operational responsibilities of MROs today and the resources that are available for staying up-to-date on the latest filtration solutions. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close