Results 1 to 2 of 2
  1. #1
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314

    Access does not honor picture rotations performed in Windows or its Windows applications

    Context: Access 2016, Windows 10, linked photos
    I often have batches of photos which need rotating before they can be used for display in Access. However, Photo rotations performed directly in Windows File Explorer, or in its Photo applications, such as Photo Gallery, are not honored by Access in its forms, or in it reports. Access continues to display them with their original orientation. This is a major problem. Is there a work-a-round for this, other than doing them manually one by one in PS?

    This has been a problem in earlier Access versions for years, not just in Access 2016. Interestingly, the photos usually display correctly in Windows File Explorer from their original non-rotated images. What is it going to take to get MS to fix the problem?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do you save the photos with the proper/desired orientation?

    I found this link and code via Google
    and tried it with this code
    Code:
    Sub testRotate()
    'thanks to Daniel Pineault ...devhut
    Dim inImage As String: inImage = "C:\users\jack\documents\MsgBox-VbaRef.png"
    Dim outImage As String: outImage = "C:\users\jack\documents\MsgBox-VbaRef-OUT.png"
       Call WIA_RotateImage(inImage, outImage, 90)
    End Sub
    Before image
    Click image for larger version. 

Name:	MsgBox-VbaRef.jpg 
Views:	12 
Size:	157.0 KB 
ID:	33970


    After image
    Click image for larger version. 

Name:	MsgBox-VbaRef-OUT.jpg 
Views:	11 
Size:	101.3 KB 
ID:	33969

    I also found this link that describes the various filters available with the Windows Image Acquisition (WIA) .
    Last edited by orange; 05-11-2018 at 10:49 AM. Reason: tested code at devhut link

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 02-02-2018, 12:47 PM
  2. Access Applications in the Windows 10 Store question
    By BrickEngraver in forum Access
    Replies: 0
    Last Post: 03-02-2016, 02:01 AM
  3. Replies: 7
    Last Post: 06-18-2012, 11:31 AM
  4. Replies: 3
    Last Post: 05-31-2012, 02:49 PM
  5. Replies: 3
    Last Post: 07-15-2010, 05:53 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums