Hentning af data fra tabel til formular som ikke er postkilde.

hvis det må være i ASP så er det:

<%
set conn = server.CreateObject(\"ADODB.Connection\")
conn.open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" Server.MapPath(\"database.mdb\")

strSQL = \"select * from tabel\"
set rs = conn.execute(strSQL)
%>
<html>
<body>
<%= rs(\"kolnnenavn\") %>
</body>
</html>

sorry... sådan her!:

<%
set conn = server.CreateObject(\"ADODB.Connection\")
conn.open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath(\"database.mdb\")

strSQL = \"select * from tabel\"
set rs = conn.execute(strSQL)
%>
<html>
<body>
<%= rs(\"kolnnenavn\") %>
</body>
</html>

a very simple way of getting a few fields from a table is by using the DLookup() function

me.field1 = Dlookup(\"tblFieldname\", \"tblName\", \"tblFieldname = \'test\'\")

Hallloooooooo???

er dette spm stadivæk i live???

=DFirst(\"ditFeltNavn\", \"ditTabelNavn\")

Terry> You will always get \'test\' as result of your lookup... ;-)

proaccess> glad your awake! The example was only given as a \"test\" to show how to get data from a table. In tart\'s case, where he only has one record, then Dfirst is obviously the choice. But if he does decide to put extra records in there, then he may want to select a given record. Anyway, hopefully tart will get something out of all the suggested solutions.