Page 1 of 3 123 LastLast
Results 1 to 15 of 36
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    *.jpg Manager (v2k)

    I have a database I am building for a real estate company. I created a single form with the control source set to real estate agents. There is a tab for current homes for sale. Here is where I am struggling:

    * I have a set of jpg photos for each agent of their current homes for sale
    * As you scroll from one agent to the next, I want the homes for that agent to appear in a subform as thumbnail pictures
    * The user could then scroll through all the photos for each broker
    * I am thinking I could create a folder for each agent so the photos could be saved in a specific location for each agent and the database could reference the proper folder
    * My dilemma is how to get the database to pull all the jpg in a scrollable window

    And there is my dilemma. Any help/thoughts, etc. would be appreciated.
    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: *.jpg Manager (v2k)

    Perhaps Thumbs Plus is something for you?

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Hi Hans,
    Thanks a bunch. I reviewed the demo and plan on contacting them but do you know how I could use this in conjunction with a database?
    Thanks,
    Andrew

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: *.jpg Manager (v2k)

    Frankly, I don't know, but I thought you might be able to do something with it since they use an Access database as storage.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Outstanding. Thanks...I will contact them and if I find any new info, I'll pass it on.

  6. #6
    Lounger
    Join Date
    Jan 2003
    Location
    Herndon, Virginia, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Do you need to do it as a continuous form? You could do it as a single subform with navigation buttons and just change the picture property of an image control. One other possiblity is making something that looks like a continuous subform, but is actually 3 (or more) image controls that you change via code -- it's trickier programming, but it would be a neat effect.

    I've attached an example of the single form approach.

    HTH, Brent
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    The tricky part is how to access the file names. Since they change frequently, I want the database to automatically recognize which jpg files are under each folder without someone having to enter them in a table.
    Your approach about multiple might just do the trick. I am sure there is code that will extract file names from a folder and you're right about the navigation buttons being a bit trickier with multiple subforms but we all love a challenge.
    Thanks for the advice!!

  8. #8
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Andrew.
    I've been working on something like this myself, I'ts not easy.
    I think it would be very tricky holding different pics in different folders.
    Ideally, one folder to hold all the images would be better in reference to the code which has to pull the correct pic.
    It would be difficult to find the correct folder, and then determine which is the correct pic(s).

    Then you have to determine an easy way to name the pic.

    Lets say you have a pic called House1.jpg , you could re-name this with a common identifier:- Branch1-House1.jpg.
    Where you have several pics, if they all had the common identifier, you could filter these from the folder.

    There are many pitfalls here, usually digital cameras, will name the pic in a pre determined format .
    You then have to save them to a location with the prefixed identifier.
    Several pics, renaming them could end up as a labourious task.

    What you're asking is do-able, but complicated.

    In my situation, I had a little help writing a VB exe program to locate images from a card reader, store the names, add the identifier and then store the image in a pre determined location.
    From here, again with help, filter them out using a complicated Access form and linking them to a particular record.
    Alas the thumbnail scenario hasn't been accomplished yet but can be done on a report.

    I'm sorry I don't have an answer to your plight, but if this information helps you, I wish you good luck.

  9. #9
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    <P ID="edit" class=small>(Edited by D Willett on 09-Aug-03 12:54. )</P>Just a thought.
    If a form had lets say 10 unbound texts.
    A table or query already exists with a field containg an image path.
    Would it be possible to create a loop to fill the unbound texts with path names from the table or query.?

    If so, maybe creating 10 pic controls and referencing them individually to the unbounds to show each pic from the path.

    Would this work ??

    Does anyone already have some loop code to get it started ?

    I ask this because I know a continuous form won't do it.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: *.jpg Manager (v2k)

    Here is a very simple demo. It contains a form four unbound image controls. Navigation buttons let you scroll through the images in a folder. It also shows clearly that it isn't very efficient <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    The demo is in Access 97, zipped. The browse for folder dialog requires Internet Explorer 4 or higher or a recent version of Windows; apart from that, nothing special is used.
    Attached Files Attached Files

  11. #11
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Hans,
    Thanks to you and the others for the help on this one. I was entering new territory and was lost until I received the feedback. The file you sent was outstanding and I really appreciate the extra effort.
    Thanks again and have a great week!
    Andrew

  12. #12
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Outstanding as ever.(knew you'd pick up on this) <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    I was trying to do something like this over the weekend (there's a routine in the Courtesy Car Planner to loop and fill)
    Gives me something to start with.

    Thanks again

  13. #13
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Hans

    Is there a way to supress the Import dialog in between loading each pic and, is this advisable ?

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: *.jpg Manager (v2k)

    According to Suppress the "Loading Image" dialog on Dev Ashish's Access Web, you can suppress the dialog with RegEdit. The usual warnings about editing the registry apply. Change the ShowProgressDialog value in HKEY_LOCAL_MACHINESOFTWAREMicrosoftShared ToolsGraphics FiltersImportJPEGOptions from Yes to No. I can't test it here myself, since the powers that be have protected this registry setting.

  15. #15
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: *.jpg Manager (v2k)

    Hans
    Thanks. I found that on Devs site also. Using both methods (Regedit) & (Timer event) don't work.
    It must be something to do with WinXP or Access version.

    It wasn't too important, I thought it would just look slicker some how.
    Another thing I was just messing with, changing the bordercolor to vbRed on click.
    Do I need to declare each pic control ?

    Dim i as integer
    for i = 1 to 12
    'Yes I've expanded it
    Me.Controls("img" & i).BorderColor = vbRed ??????????
    Next

    Access doesn't like the expression and hangs.

Page 1 of 3 123 LastLast

Posting Permissions

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