Results 1 to 11 of 11

Thread: MessageBoard

  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Unanswered: MessageBoard

    Hi,

    Im wanting to do a nice and easy messageboard in Access.

    I just want a form that will show the threads and an option to add a new message, or reply to an already created message.

    Anybody got any ideas?

    Thanks

  2. #2
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557

    Tables

    Okay to start off you will need atleast two tables.

    1. tblPosts

    2. tblReplies

    In table posts you will need everything you want to keep track of like:

    tblPosts

    PostID (autoNumber) Primary Key
    Username (text)
    Date (date/time)

    tblReplies

    ReplyID (autoNumber) Primary Key
    PostID (number) Foreign Key
    Username (text)
    Date (date/time)

    and so on and so forth.

    I hope that helps you get started.

    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  3. #3
    Join Date
    Apr 2004
    Posts
    4
    Thanks for that,

    Any idea of the code to use, not only to view the board in a threaded way, but also to be able to post a message?

    Thanks

  4. #4
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    To post a message you would want the form that 'views' to have a button linked to a form that allows you to add a new post and a button to reply to the current post. I am not exactly sure on all the coding needed to make it thread the way you want it to. I havent done that yet. I have been meaning to on the web with ColdFusion. (which is how I know the tables and relationships)

    You will need a few queries, that is how the data will be sorted. Then use a form to open that query some how. (the form should probably be unbound)

    Hope this helps a bit.
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ummm... this is a bit more difficult then you seem to think.

    As far as what "code" to use, what have you tried so far?

    You DO have to make SOME attempt at this before people can get a good idea of exactly what you want to do.

    Otherwise you're just asking people to make something for you that would otherwise cost you cash.

  6. #6
    Join Date
    Apr 2004
    Posts
    4
    Ok,

    The problem I have is linking the main table to the replies table.

    Ideally I would like to have the Main message, then below it the replies. When I link them it repeats the main message as well as the replies, if that makes sense?

    Also having difficulty showing it in text format on a form, looks strange in the normal datatable format!

  7. #7
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Making the posts in true "threaded" form would be pretty difficult.

    I have an off-handed suggestion though...

    what if you used a treeview to navigate the posts and a listbox for posting/replying?

    It would take a fair amount of code to correctly populate the treeview, but it would solve your nesting problem quite handily..?

  8. #8
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Show us exactly what you are doing is what we need.

    We need to see some effort on your part. (like include the database)


    Thanks,
    JS
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

  9. #9
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Alternately...

    If you're ok having a format similar to dbforums, that's pretty easy to duplicate in access.

    Also, you haven't mentioned whether this is online or not.

  10. #10
    Join Date
    Apr 2004
    Posts
    4
    Guys,

    Thanks for your help, im going to have it where a list shows the messages and you then click a button to view the replies to that message.

    Seams to work fine, just need to make it look good now!

    Thanks

  11. #11
    Join Date
    Mar 2004
    Location
    Nashville, TN
    Posts
    557
    Okay not a problem
    Have you ever thought about thinking on purpose?

    Jarvis Stubblefield
    Patriot Designs
    Web/Database Development and Consulting
    The-Patriot.net by Patriot Designs

Posting Permissions

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