Results 1 to 3 of 3
  1. #1
    beha is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    10

    View data in table on Form as Diary?

    Hi

    I have a table i use as a diary. I would like to show the records in the diary table as one text filed on the Form where the diary is related to. As below.

    Attribute.Headline Car
    Attribute.About Door
    Attribute.Date 26-10-2011
    Attribute.Text The Doors play good Music
    -------------------------------------------------
    next memo
    -------------------------------------------------
    next memo

    I´m of course not interested in showing the attribute name. The above is not actual data
    I hope u understand my question.
    Regards


    Bergur

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    If you are primarily wanting to view the data, I'd suggest...

    Quote Originally Posted by beha View Post
    Hi

    I have a table i use as a diary. I would like to show the records in the diary table as one text filed on the Form where the diary is related to. As below.

    Attribute.Headline Car
    Attribute.About Door
    Attribute.Date 26-10-2011
    Attribute.Text The Doors play good Music
    -------------------------------------------------
    next memo
    -------------------------------------------------
    next memo

    I´m of course not interested in showing the attribute name. The above is not actual data
    I hope u understand my question.
    Regards
    Bergur
    creating a report in print preview and refer to it. That might mean another form to edit information, but it should be straightforward.

  3. #3
    beha is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    10
    Sometimes you get surprised how easy it can be made.
    I did make a report and then dropped the report on my form, did some changes in the layout, and voila

    I don´t know if it´s the right way to do it, but it works and looks pretty cool.
    Thanks for the reply.

    Regard
    Bergur

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

Similar Threads

  1. first create table in MS access data definition sql view
    By learning_graccess in forum Access
    Replies: 1
    Last Post: 10-14-2011, 06:23 AM
  2. Corrupt Table in Data Set View Access 2010
    By Peter Murray in forum Access
    Replies: 1
    Last Post: 11-29-2010, 04:16 PM
  3. Replies: 3
    Last Post: 08-17-2010, 02:49 PM
  4. Replies: 9
    Last Post: 02-19-2010, 12:07 PM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 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