Results 1 to 14 of 14
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Output Data to Presentation Method (2000)

    Hi looking to export information from our database into a program or have a live link (possibly Powerpoint) where it rotates information of a record on a screen that is in our shop window.

    We have information about the houses we sell and are looking to display information with a photograph (all stored within our database).

    Any suggestions / ideas?
    Best Regards,

    Luke

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

    Re: Output Data to Presentation Method (2000)

    Are the photographs themselves stored in the Access database? <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15> Or are their paths/filenames stored in a text field?

  3. #3
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Data to Presentation Method (2000)

    They are stored are text files for the file path
    Best Regards,

    Luke

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

    Re: Output Data to Presentation Method (2000)

    Uh, what does that sentence mean?

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

    Re: Output Data to Presentation Method (2000)

    Why don't you show an Access form? You could create a dedicated frontend database with a popup form that is set as startup form. The form would contain an image control and text boxes or labels.
    You could use the On Timer event to switch to another record after a specified interval.

  6. #6
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Data to Presentation Method (2000)

    Hans,

    Just getting round to this now.

    So I have created my form, how would I set the on timer event to scroll through the records every 10 seconds? And what would it do at the end once. I would want it to scroll through the records from the beginning again.
    Best Regards,

    Luke

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

    Re: Output Data to Presentation Method (2000)

    Open the form in design view.
    Activate the Event tab of the Properties window.
    Set the TimerInterval property to 10000 (this is the time in milliseconds).
    Create an event procedure for the On Timer event:

    Private Sub Form_Timer()
    If Me.CurrentRecord < Me.RecordsetClone.RecordCount Then
    RunCommand acCmdRecordsGoToNext
    Else
    RunCommand acCmdRecordsGoToFirst
    End If
    End Sub

  8. #8
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Data to Presentation Method (2000)

    <big>DO NOT POST IMAGES LARGER THAN 640x480 PLEASE! HansV</big>

    Stupid me, already resolved it already.

    Any pointers on how to get rid of the behaviour ont he screenshot.

    When the form loads there is the top field highlighted and if you click off, you get a cursor bar type icon. Upon flicking through to the next record it highlights it again.
    Attached Images Attached Images
    Best Regards,

    Luke

  9. #9
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Data to Presentation Method (2000)

    The other screenshot
    Attached Images Attached Images
    Best Regards,

    Luke

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

    Re: Output Data to Presentation Method (2000)

    Sorry, I don't understand your question.

  11. #11
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Data to Presentation Method (2000)

    When opening the database with a form loading it opens with a field text highlighted as in screenshot one where '... Lyndwood Court' has been hihglighted, veen though it is not like this really.

    If you click off this to say the amount of bedrooms, when the record moves to the next one, it will highlight this as in screenshot two.
    Best Regards,

    Luke

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

    Re: Output Data to Presentation Method (2000)

    Perhaps it's done with conditional formatting:
    - Select the controls.
    - Select Format | Conditional Formatting...
    - Under Condition 1, select Field has focus
    - Select a suitable background (fill) color and foreground (text) color.
    - Click OK.

  13. #13
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Output Data to Presentation Method (2000)

    No. it still highlights the field. Do you want a stripped down db version?
    Best Regards,

    Luke

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

    Re: Output Data to Presentation Method (2000)

    Yes, please, that would be helpful.

Posting Permissions

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