Results 1 to 7 of 7
  1. #1
    Kirsti is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Location
    New Zealand
    Posts
    172

    VBA for Embedded Image in Form 'Send To Back'


    Hi there,

    I have an embedded image on my form that is covering a control and I want to 'send to back'. According to Google, this is an option in the Format Menu in properties, but I have Access 2003 and don't seem to have this object.

    I also understand that there is a DoCmd to Send to Back, but I don't know how to use this properly. Is someone able to help me with the syntax?

    Thanks in advance,
    Kirsti

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,528
    Don't have what object - the Properties sheet, Format tab, or 'Send to back' option?

    I am not seeing SendToBack on Properties sheet.

    What happens if you right click on the embedded image control? Does that open a shortcut menu? Is there a listing for Position?

    I think the DoCmd.RunCommand acCmdSendToBack is for use on objects not controls.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Kirsti is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Location
    New Zealand
    Posts
    172
    I have the Properties sheet and Format tab, just can't see a 'Send to back' option.

    If I right click on the embedded image control, it does open a shortcut menu, but there is not a listing for 'Position'.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,528
    I don't see any option for SendToBack on Properties sheet either.

    Sounds like you are out of luck with 2003.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Kirsti is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Location
    New Zealand
    Posts
    172
    Thanks June. I will work around it.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,528
    What do you want the image control behind? What if you create that control after creating the image control? Does it layer on top?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    Kirsti is offline Competent Performer
    Windows 7 32bit Access 2003
    Join Date
    Jan 2012
    Location
    New Zealand
    Posts
    172
    Yes, you're right! It does layer.

    Very annoying, but thanks for your help.

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

Similar Threads

  1. send email with attached image in body
    By trevor40 in forum Programming
    Replies: 5
    Last Post: 02-14-2014, 01:17 AM
  2. How to send embedded word document as a mail
    By ravidcurious in forum Programming
    Replies: 1
    Last Post: 12-17-2013, 01:43 PM
  3. Replies: 2
    Last Post: 07-10-2013, 11:19 AM
  4. Embedded macro on form
    By trout in forum Macros
    Replies: 7
    Last Post: 07-09-2013, 01:13 PM
  5. Replies: 4
    Last Post: 05-21-2012, 08:21 AM

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 - Senior Forums