🚀 go-pugleaf

This is a bona fide design breif.  You will need to understand windows,
access97, e-mail and form handling to assist here.

There are two components to this design.  A windows based interface and a
web based form.  I am not sure how to do either, but I know it is possible
and need someone to, tell me how they intend doing it (I can have a
reasonably good instructive conversationas I am literate in database, html,
cgi etc - enough to make sense).

The windows based form interface is simple enough, I will design this using
FP98.  What I need is the form handler to take one piece of information from
the form (it will only have one field) and post it to three places
simultaneously whilst also carrying two other pieces of information
(concealed from the user). Allow me to explain:

A surfer inputs their name and hits SUBMIT.  Their name gets sent to a
database on the server which records their name in one field, the web site
address in another field (somehow this is attached to the form, hidden from
the user) and the extended date (mmddyy hh:mm:ss) - also hidden from the
user.

In addition to sending this information to the database, an e-mail is sent
with these three pieces of information, in the SUBJECT box it read something
like: Another User Signed In to a predetermined e-mail address.

The third place the information is received is a simple windows based
interface.  In reality all this is, is an e-mail client that is constantly
connected to the internet and is all the time checking (say every 60
seconds) the same e-mail address (different from the one mentioned above)
for new mail.  However, what the user sees is a simple form with three boxes
on it (this form is an Access97 form) - the form Refreshes every 60 seconds
and reveals the new 'e-mail' if one has arrived.  The format is The Surfers
name (1st field), web page address (2nd field) and time/date (3rd field).

I have prepared a sample of how this form might look at th following
address:
www.everyco.net/delta/visitor.htm

As stated, this form must update itself (to the virtual server to check for
new mail) every 60 seconds using the REFRESH command in a macro - but how it
gets its information from the server I do not know - hence the reason for
this posting

It is worth notinh that in the second box, the Web SIte Address is a
Hyperlink - so whomever is using it can open the page

Then they can reject the three pieces of data or recorfd them in a simple
three field table.


That's it!

So what do you do and what will I do?

I can do everything except:

1. get the data from the form on the web site and get it sent to the
database (Acces 97) on the server (probably in a folder called database
curiously enough)

2. get the data into an e-mail saying "Another User Signed In"

3. get an e-mail client to capture text and somehow send it into a form in
Access so that I can do stuff with it


Finally, I am happy to assist or be hands off - your choice.  However, i do
need control over the design of the final Access Interface and I will also
need to design the web interface too.

Please indicate a cost and time schedule - oh an how you wnt to be paid

As stated this is a bona fide enquiry - looking forward to your input

Thanks

Patrick Reynolds