Results 1 to 5 of 5
  1. #1
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480

    Allow users to select their own backgrounds...


    So I have an application and a sizable user base. the main form has a background image, it makes the application look nice. I would like to expand on this functionality and allow the users select their own backgrounds. Maybe a command button or something to select the .jpg or .bmp or even URL of the img... Just wondering if anyone has any exp doing this kind of thing?

  2. #2
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    no luck Let me explain how the background works today. Currently a file is saved on their PC with a specific name.. this file is used as the background. I guess I could have a combination of select file/output file queries that would over wright this file and making the selected file the background... I don't know, what do you think?

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Never done it, but I would think you could throw up a file dialog to let the user browse to the picture, capture the path and set the form's picture property to it. One method:

    http://access.mvps.org/access/api/api0001.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Yes, but this choice would be lost everytime the form is closed unless it was saved with that change. Also, replacing the db with updated version would again wipeout this choice.

    Would have to save the user's choice to a table (UserProfile ?) then in the form Load event, set the property to display the image of choice.

    redbull, too nice, spoiling users like grandma with grandkids

    Personally, I don't like background pictures on forms. They contribute nothing to functionality, are distracting, and if embedded cause file bloat.
    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
    redbull's Avatar
    redbull is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Mar 2012
    Location
    Missouri
    Posts
    480
    lol yea, I already know where I can save the file path where it will remain untouched. June7, to quote my boss "you are looking for trouble"

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

Similar Threads

  1. Replies: 1
    Last Post: 10-08-2012, 09:01 AM
  2. Replies: 5
    Last Post: 07-26-2012, 12:59 PM
  3. Users
    By Faisal6309 in forum Access
    Replies: 1
    Last Post: 03-07-2012, 04:39 PM
  4. How to restrict users?
    By cindytan in forum Access
    Replies: 5
    Last Post: 02-08-2012, 09:40 AM
  5. Replies: 8
    Last Post: 04-21-2011, 05:29 PM

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