View Full Version : Can I obtain the record description? (access)
Mhtml
12-18-2002, 12:05 PM
Can I obtain the description I have entered when I cerated the table in the access GUI?
BigDaddy
12-18-2002, 02:41 PM
You mean the notes field that describes each field? No--not that I'm aware of. You can obtain the field name itself, and the value in the field, but the notes thing is only for the dba.
Mhtml
12-19-2002, 01:41 AM
How unfortunate. That would make life a whole bunch easier for me when I have to write out a bizillion fields.
I was just going to use this I made up. To get all the current field names and values, I was going to save as a html (I still will) and then I have my form with hundreds of fields from the small code there.
<table><form action="updateskin.asp" method="post">
<%
SqlGetSkin = "SELECT * FROM Skins"
rs.Open SqlGetSkin, conn
For each x in rs.fields
%>
<tr><td><%=x.name%></td><input size="30" type="text" name="<%=x.name%>" value="<%=x.value%>" />
<%
next
set rs = nothing
conn.close
set conn = nothing %>
</table>
But since I can't get descriptions I will have to sit and write them down so others can use it..:( Oh well :)
vBulletin® v3.8.2, Copyright ©2000-2012, Jelsoft Enterprises Ltd.