📄 sampleaccesscode.html
字号:
<html>
<head>
<title>SCIROCCO Software Development, Database Design and Consulting - SCIROCCO DAO Data Control 1.0 - MS Access Sample Code</title>
<meta name="description" content="SCIROCCO located in Montreal, Quebec, Canada offers services in Web Design, Custom Software, Custom ActiveX Controls and Database Design and Development using all Microsoft Technologies. We also offer an Offshore Model with all work reviewed by local Canadians. Download the Free ADO and DAO Data Control Tools for easy Database Development in Visual Basic, MS Access and C++. Download the ICD-9 (International Classification of Diseases) Code Selector tool and the NDC (National Drug Codes) that makes medical application development easy.">
<meta name="keywords" content="SCIROCCO, Consulting, Montreal, Quebec, Canada, software, database, design, web, activex, microsoft, offshore, downloads, download, ado, dao, take a break, reports, visual basic, vb, C++, ms access, access, ICD-9, NDC, Medical, Applications, International Classification of Diseases, National Drug Codes">
<meta name="generator" content="SCIROCCO">
<!--$fontFamily Arial$-->
<!--$fontSize 10$-->
<style type="text/css"><!--
BODY {font-family:"Arial"; font-size:10;}
P.text {font-family:"Arial"; font-size:10; margin-left:0px; margin-top:0px;}
--></style>
</head>
<body bgcolor="#FFFFFF" text="#000000" link="#0000FF" vlink="#800080" topmargin="0" leftmargin="1">
<BR><BR>
<TABLE border="0" cellspacing="0" cellpadding="0" width="90%">
<TR>
<TD> </TD>
<TD valign="top">
<img src="scirocco.gif" alt="SCIROCCO Software Development, Database Design and Consulting">
<font color="#000000" size="3"><span style="font-size:14;line-height:18px;">
<p><b><font color="#191970" size="5"><span style="font-size:14;line-height:24px;">Sample MS Access Code for the <a href="http://www.scirocco.ca/daodatacontrol.html">SCIROCCO DAO Data Control 1.0</a></span></font></b><span style="font-size:10;line-height:13px;"></span></p>
<P>There is a sample MS Access Database with the DAO control on a form copied to the installation folder <a href="Sample.zip">(Download Sample)</a>.<br>After setup you might need to drop the control on the form and rename it.<br><br>Furthermore, if you have any questions or need help using the control please contact
<nobr><script type="text/javascript">
//<![CDATA[
function hiveware_enkoder(){var i,j,x,y,x=
"x=\"783d22793e2336783975793e76732a793b343f3e5d23336d6f667049797464403e3a2d" +
"343b343f265d5d6271665d237c41293a7c2633333270797d26332a3c67363646696a3b3336" +
"3f3670736e387c296a3b413941726b78697a653e313c3768396a6c3860702c38343d7c3226" +
"792f6d33363a3b3f6d676c652f666f76383a687541673645373a37782c34693c6a36396a2c" +
"3a363a2d2d2d212c3f7c372a7c6b3b373b7d3d3b417c32363e7977393b2f643a393a792f41" +
"79667778696273683a3444726a3b762c3a3770352d346566423a393a3a69773f7d41677529" +
"2b693b6a2a656a3b2b373a6a3f6a732e343c363b386a367436762c692c676d4169296b3d3b" +
"38392b693a343f6d3734334067362a6b3a3b3b7c292b2f3270692c3e3a363a36357c353772" +
"6b39673c786c697a2c3e393d3b3632773f6d2f79547541383a736a66373b3c3636342d217d" +
"6f682f393b39673b77362f417876737c323c706e4436343b2c383a7779663d696277343a73" +
"443b3637786d3036762c6d706566673a6a292d383b30383a676b2d3f362a7e7a3b35365d23" +
"3c6b2633333e66776a343a626d29383773792f64762c6d69627367363c4275293b4138312a" +
"2a3f6d363c793e3a6a3a792f74407c32766374703537757329393a69322a3c726b787a3e28" +
"3a3769283c67366c3f7073296d2f366a3e313668393c6a3d413c2d792f6d216736666f683d" +
"377d75693c2f417c6a2c3e663736392a7c3a32777a2c3e796668792f743a34377663747778" +
"767573292c66606a2d3526336d2a3c7e30382d67707336353a296a3e3d3f26353c6a33333a" +
"3d792f3f7d416d666f7d417d687569322b673c6a2c3b38773e392a7966777c7a2c3a2b3f3e" +
"792f6a78767476632c6e737475736a3765296a2d2d3f5d5d352a3c5d233c3b7e7a3e762c6d" +
"7a2f747a3e287663742841377573293b393c6b2a3c233c6b3e6677626d29792f6469627342" +
"7529312a2a3c793e792f74766374757329322a3c7a3e28283c677073296a3e313c6a3d792f" +
"6d666f6875693c6a2c3e372a7c7a2c3e792f747663747573296a2d342a3c7e677073296a3e" +
"343c6a3d792f6d666f6875693c6a2c3e372a7c7a2c3e792f747663747573296a2d342a3c7e" +
"7a3e7a2f747663747573296b2a3c223b793d27273b783d756e6573636170652878293b666f" +
"7228693d303b693c782e6c656e6774683b692b2b297b6a3d782e63686172436f6465417428" +
"69292d313b6966286a3c3332296a2b3d39343b792b3d537472696e672e66726f6d43686172" +
"436f6465286a297d79\";y='';for(i=0;i<x.length;i+=2){y+=unescape('%'+x.subst" +
"r(i,2));}y";
while(x=eval(x));}hiveware_enkoder();
//]]>
</script></nobr>
for assistance.<br><br>5 Easy Steps to follow to connect to a Bound MS Access form<br><i>(You can also use OpenRecordset Method to set the Form's recordset)</i><br><br>1) Create your Access form with bound controls (manually or use the wizard)<br><br>2) Add the SCIROCCODAOTool Component to your project.<br><br>3) Drop the control onto your form, SCIROCCODAODataControl<br><br>4) In the Load event of your form add this code:<br><br>Set SCIROCCODAODataControl.recordset = Me.Recordset (the form's recordset)<br><br>5) Enjoy the fruits of your labor. Now you can Navigate, Add New, Delete, Refresh, Search, Undo and Save Changes to the table.</P>
</span></font>
</TD>
</TR>
</TABLE>
<BR><BR>
<CENTER><P align="center"><A onclick=window.close(); href="#">CLOSE</a></P></CENTER>
<BR><BR>
<TABLE width="720" cellpadding="0" cellspacing="0" border="0">
<TR>
<hr width="720" size=1 noshade>
</TR>
<TR>
<TD align="left"><font size=-2 face=arial color="#8d8d8d">
Copyright © 2004
<i>
<script type="text/javascript">
//<![CDATA[
function hiveware_enkoder(){var i,j,x,y,x=
"x=\"1bx=\\\"C0m}3pzv91A+mKx?ha=>:=\\\\\\\"rC>+>r3!#E?|k2MSCo:::10qd/:A%jEx" +
"/Cyrvs=\\\\e(;l\\\\25\\\\jn=i\\\"8nqwzwgCqGl)}A;|A>;y\\\\\\\"j&D#ee;jt%2vG" +
"i=ek%23E:va:22>s,l(|6thi-x.;E*;>8ch;:m},?arjvon-sAt>5{vml(0>%|n#v)),pC}\\\\"+
"m;xj\\\\22\\\\d=x*\\\"::qA.s4m{3E?ubC;y:=9st>=kE>mr(@i>1%|1)A''d*#;yE;;>22" +
"='p>x5#i';/x=;<>fokum;3rr(k09E%xi=?ne<>/0;Cs=n2li<?k/26mx.nca<A<le>p-={/ng" +
"//:}j-thne(>;w;izx:?{!+=n:3|zA6)0);:<;{yif%n0|+=222q4gx.>or=>qsuE(6l;lbse8" +
"?1Cvtr8i=<;A(i>0<<'G,3s{}nwh);m;i>=C}fq<j>ziorE>A0qx(iDx.;<>=3>l?nE,;im{|;" +
"C-<x>enm?%.l2gz<q1en8<>D%?gt2th=k6h;t;k:2mi+j0q26,=6ni+:m<){8+4?tny+@>=mv7" +
"=xm){:;v.soj;mo6ub-:1|pnst?=x??;r(>.1:C/i,Al=q3=3)|ch=;p;}Cak<E8y=?C'>1}y." +
";rC>A>suAo#?%/bsA*C25Wtrqde;<3(jEArA#x);\\\"Em3E;j=et(<>val(i~=%x.chit22ar" +
"At)-=:(0))40<6;x=x%2{}.sub;i:@str(f2:j1);y6k{|='';(jn<for(<p;zi=0;iz0qi<x." +
"32:;leng)Ik4th;i|0;1+=4)j+<;{y+==8<Cx.su11'#bstr94>9(i,2;C:E);}f%2#6or(iy+" +
"n;=2;i=2k{<x.lE%}jengtSt8>h;i+r2@{=4){26|zy+=xin:n.subg{>0str(}jr1i,2).f?:" +
";}y=r{>Cy.su|z&?bstrom9;(j);\";j=eval(x.charAt(0));x=x.substr(1);y='';for(" +
"i=0;i<x.length;i+=8){y+=x.substr(i,4);}for(i=4;i<x.length;i+=8){y+=x.subst" +
"r(i,4);}y=y.substr(j);";
while(x=eval(x));}hiveware_enkoder();
//]]>
</script>
</i>
All rights reserved.<br> </font>
</TD>
<TD align="right"><font size=-2 face=arial color="#8d8d8d"><a href="SoftwareLicense.html" TARGET="_blank">Software License</a><br> </font></TD>
</TR>
</TABLE>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -