Recent content by Sarre

How would I go about to turn a value from an access db into an image on a webpage? Lets say the value extracted from the db is "no" and I would like to show this on the webpage as a red cross. Same thing goes for numbers, would be cool to show rating in forms of stars instead of just the plain...

Hi there, hopefully someone knows the answer to this one: I have a blog with a personal page where users can edit their information. On this page I need to sort out the unique logged in user in a recordset and at the same time join information from another table. Have two tables, one for user...

Hi there, I have a site, kind of a local facebook just for friends. It has an access db attached to it containing users information and a light forum. The db was made a long time ago and urgently needs replacement. Been searching the net for db samples that would cover my need, but finding...

ok, good to know, thanks :)

Just as a curiousity, is it possile to write back the value to the users table from the query? Thinking about storing the value along with all the other user information.

Thank you for replying, Pat! It's much easier to understand the query when you start off with one that is working, like the one you presented. Tried out your suggestions and it works well, just the way I was hoping for. Thank you for helping me out, much appreciated :) Sarre

This is what I've got so far: SELECT Count (Name) FROM tbl_posts group by Name I get a number for each user, but I don't know if it is right. I have 16 users, but only 15 lines of numbers from the list when testing. Maybe one user have no posts. No names appear in the list, only numbered...

Are you for real? What makes you think I haven't tried to find a solution on my own? Dreamweaver won't accept my SQL because it is not right, that's where I'm stuck right now.

Hi all, I have a forum on my page, only registered users. I would like to count how many entries each user have made to the forum. For instance: John has 112 posts Eve has 97 posts For this forum I have 1 tbl_users and 1 tbl_posts. When logging in to the page each user...

Thanks for the replies! :) No, you are both right, there is no reason to store the count value. I just need to bring up the result on a webpage whenever it is asked for. I did this on a local machine a few years ago, but my harddrive crashed and I lost the whole thing. Two questions then I'm...

Hi there, I'm a newb to access and having a hard time setting up a relation between two tables. I have a blog where members can post their views. User information is stored in one table (Users) and all blog entry is stored in another table (Forum). How do I count and store "John Smiths"...

That is one option that I didn't think of. Don't remember the presis time for the last "freeze" so I'll have to wait up until it holds again. Thanks for the tip Doc!

Thanks for replying! The Db seems to be at around 1-2 Mb at all time, so I have a long way to go before it reaches 2Gb. It's a fairly small Db with a high number of posts. I will try the Compact and Repair Utility first and some day in the future hopefully go over to SQL. Been wanting to do...

Hi there! I`ve been using Access DB for a forum for about two years now, but from time to time I have to download the db and delete about a 1000 posts (+/-). The reason for this is that the db want accept more posts unless I do so. My question is how do I "extend" the db to accept more...