var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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?
Okay to start off you will need atleast two tables.
In table posts you will need everything you want to keep track of like:
PostID (autoNumber) Primary Key
ReplyID (autoNumber) Primary Key
PostID (number) Foreign Key
and so on and so forth.
I hope that helps you get started.
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?
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.
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.
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!
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..?
Show us exactly what you are doing is what we need.
We need to see some effort on your part. (like include the database)
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.
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!