<html> <meta http-equiv="x-ua-compatible" content="ie=edge"> <meta charset="utf-8"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.1/css/bootstrap.css"> <script src="mysql-9-access.js?002"></script> <head> <script> var tableName = "社員マスタ"; $(function(){ $("#btn").on("click", function(){ var value = getFieldValue( tableName ); for( var i = 1; i < count; i++ ) { $("#fld" + (i+1) ).val( value[i] ); } }); var count = getFieldCount( tableName ); var name = getFieldName( tableName ); console.dir(name); for( var i = 0; i < count; i++ ) { $("<span>") .appendTo( $("body") ) .text(name[i]) .css( { "display": "inline-block", "width": "120px" }) .prop( { "id" : "col" + (i+1) }) ; $("<input>") .appendTo( $("body") ) .css( { "background-color": "skyblue", "color": "white" }) .prop( { "value": "", "id" : "fld" + (i+1) }) ; $("<br>") .appendTo( $("body") ) ; } }); </script> </head> <body> <input type="button" id="btn" value="参照" style="position:absolute;left:500px;top:0px;"> </body> </html>