Form til at "skrive" i databasen

move the question to ASP and youmay get an answer!

Terry: I didnt move it to ASP because this form is in Html!
I put it here in access because my formmail is to WRITE in access....

well if you think this is Access relevant then we need more informaion!
Whatis the problem, what are you trying to do?

Im trying to write  from a htmlform to my database in acess.
So a new user can add himself.

simonia>I have also looked att anotherquestion placed by you
http://www.eksperten.dk/spm/186497
The reason why you rae getting no answre is BECAUSE it is more a WEB (ASP/HTML) than an Access question. For example what has the HTML in you rquestion to do with Access?

Which version of Access? In 2000 and newer you can create a DAP (Data Access Page) which is actually HTML. Try doing that first otherwise youwill HAVE to use ASP!
Link to ASP?
http://www.aspemporium.com/aspEmporium/tutorials/StoredProcedures.asp
http://www.html.dk/

Terry: It has to do with it, that I want to submit the formresults to my accessdatabase and not to forexample an email or something else.
I want a user to be added to my accessdatabase when he has filled out the formmail and clicked on submit.

And Im STILL not looking for a guide, just a humananswer on how to get this formmail to work the way I want it to if possible.

Well OK, let the question hang a while and see if some HTML/ASP freek comes by :o)

They probably wont now...
When you see a question like this allredy have this many answers, youre just assuming that someone allready got help.

simonia> I am only trying to help when I suggest you move the question to EITHER ASP Or HTML. I have been working with Access for a number of years now, but I WILL NOT get invloved in HTML

I will in a few days, if theres no help here...

Prøv det her sæt form action sådan her:
<form action="xxxxxxxx.asp?submode=save" method="POST">
Nederst på siden skriver du så:
<% if Request.QueryString("submode")="save" then %> <%

Const adOpenKeyset = 1
Const adLockOptimistic = 3
%>
'Din forbindelse til db'en
<%

    Set rs = Server.CreateObject("ADODB.RecordSet")
    strSQL = "Select * From din tabel"
    rs.Open strSQL, Conn, adOpenKeyset, adLockOptimistic

      rs.AddNew
'skriv dine kolonne navne i rs delen og dit formnavn i request delen
 
      rs("xxxxx") = Request.form("Fornavn")
      rs("xxxxx") = Request.form("Efternavn")
      rs("xxxxx") = Request.form("Email")
      rs("xxxxx") = Request.form("Telefon")

      rs.Update

    rs.Close
    Set rs = Nothing

Conn.Close
set Conn = Nothing
response.redirect "xxxxxxxx.asp"%>
<%end if%>

Tak prøver jeg lige, vender tilbage enere...

men ehmmmmm, skal der oprettes en ny aspside det skal sendes igennem da? der hvor du skriver xxxxx.asp?

Oh simonia, ASP! whats that to do with Access?

Terry, you apperently dont know anything about what Im asking, so please stop answering if you dont have an answer. Everyone who write here is getting an email everytime you reply here saying theres a new message here. Besides youre first "answer" was hardly an answer. I write here, because Im in urgent need of an experts advice, not because I need to waste some time. And this is not a personal attack on you, but a friendly advice for you to remember in the future.
I can hardly be the only one feeling like this.
Thanks in advance.

Simonia

simonia>I apparently no nothing at all about what you are asking, thats why I am advising you to move your question elsewhere, and THIS IS NOT a personal atack on you either, its meant to HELP you get the "urgent" answer you are looking for, nothing more nothing less! But then it cant be that urgent. Oh! the only peaople that are gettiug these  mails are fedefifi, you and myself :o)

Lukket:/