Recent content by loganswell

Thank you for your helpful answer!!

I'm sorry if this has been covered before. I did check out some FAQs but everything was a great deal more technical than was really appropriate. I have actually spent hours trying to find the answer to what is probably a very simple question but when I go to the help section of both PSP7 and...

Thank you for your help! :o)

Hi, (The following question may be only suitable for UK users - not sure) I'm trying to help a friend get connected to Broadband ADSL. The company (TalkTalk) supplies an installation CD along with the hardware (ADSL modem that plugs into a USB port +cables etc. We get so far with the...

I think a combination of ideas may be the answer... If the IP address contained in the guestbook submission is the same as the previous one and a period of say 48 hours has not elapsed, then reject submission. That would surely eliminate the bulk entries but still allow a genuine human to make...

Hi and thank you all for taking an interest. The entries aren't really slanderous or even offensive. It's all just stupid inane stuff like "Very nice site - your work is appreciated" and often you can easily tell that it's written by someone whose first language is not English. It wouldn't be...

Hi monksnake, Thank you for your reply. Yes, the field validation idea is good but unfortunately most bogus entries are actually valid! I already have some validation in that if you attempt to include the string "URL" or the string "http" then the message will be rejected. God knows how many...

Thank you trollacious. I shall look at this. This is however only one option and I don't even know if it's what I need to solve my problem. For example this would be ineffective if the method of access to my database on the web server was direct ie by-passing my own ASP code. Best wishes...

Hi monksnake, Yes, I agree I was a bit vague but didn't want to go into too much detail at the outset. You can see first-hand the nature of the problem if you are willing to have a look at the guestbook itself on the following web link: http://www.jarsek.com/thornliebankchurch/guestbook.asp...

Hi, Me again... I am still having the same bother with my ASP guestbook only now it's worse. Do you think that if I introduced a system whereby an image file is displayed with a number or letters (like you get when joining Yahoo groups) would make a difference? The person who is making the...

Thank you trollacious - that was helpful! :o)

Hi, I have a couple of web sites that have simple little guestbooks. They're coded using ASP in its simplest form reading / writing from / to an Access database. I have recently been getting a huge number of spurious entries that are just "gobbledegook" and seem to serve no purpose even to...

Hi people, I have a web site that is hosted in California and I am in Scotland (UK GMT+1 [BST or daylight saving time]) When people add entries to the guestbook (which is an Access database) it is showing as local (Pacific?) time. The database is set up just as a date/time field. Is it...

Hi! Can anyone tell me what to place in a date field in my Access Query (design view) so that it will show all records in the database where a date field has been left blank? I tried ="" but that didn't work (as I suspected)! Thank you! :o)

Yes, this certainly HAS generated a lot of responses and I'm grateful to all the contributors! I was sure that it could be done as I'd done it before years ago but just couldn't remember what it was I did! The memory goes with advancing years. I do wish that I was clever enough to use VBA to...