issues.htm

这是access数据库使用的一些例子,可供学习使用

style="OVERFLOW: auto" topMargin=24 vLink=#800080>
<CENTER>
<H1 id=标题文字 style="FONT-WEIGHT: normal">Issues Web Page&nbsp;</H1></CENTER>
<P title="issues web page">Click the expand(+)button to view an employee's 
issues</P>
<DIV class=MicrosoftAccessBanner id=页眉IssuesForReportAssignedToBanner 
style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; FONT-WEIGHT: normal; HEIGHT: 0.507cm; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 720px">页眉: 
IssuesForReport-AssignedTo</DIV>
<DIV class=MSOShowDesignGrid id=页眉IssuesForReportAssignedTo 
style="BACKGROUND-COLOR: transparent; HEIGHT: 0.869cm; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 15.238cm">
<OBJECT classid=CLSID:0002E532-0000-0000-C000-000000000046 
codeBase="file:\\VERCONTROL\OFFICE 2000\OFFICE2K\CD1\msowc.cab#version=9,0,0,2710" 
id=IssuesForReport-AssignedTo展开 
style="HEIGHT: 20px; LEFT: 10px; POSITION: absolute; TOP: 10px; WIDTH: 20px"><PARAM NAME="_State" VALUE=""><PARAM NAME="Bitmap" VALUE="0"></OBJECT><TEXTAREA id=AssignedTo style="HEIGHT: 0.445cm; LEFT: 4.74cm; OVERFLOW: hidden; POSITION: absolute; TOP: 0.211cm; WIDTH: 5.164cm" tabIndex=8 title=AssignedTo></TEXTAREA><SPAN 
class=MSTheme-Label id=AssignedTo_标签 
style="HEIGHT: 0.445cm; LEFT: 1.269cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.211cm; WIDTH: 3.472cm" 
title=AssignedTo>AssignedTo</SPAN></DIV>
<DIV class=MicrosoftAccessBanner id=页眉IssuesForReportBanner 
style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; FONT-WEIGHT: normal; HEIGHT: 0.507cm; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 720px">页眉: 
IssuesForReport</DIV>
<DIV class=MSOShowDesignGrid id=页眉IssuesForReport 
style="BACKGROUND-COLOR: transparent; HEIGHT: 317px; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 720px"><SPAN 
class=MSTheme-Label id=IssueID_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.044cm; WIDTH: 3.472cm" 
title=IssueID>IssueID</SPAN><TEXTAREA id=IssueID style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 0.044cm; WIDTH: 5.164cm" tabIndex=1 title=IssueID></TEXTAREA><SPAN 
class=MSTheme-Label id=Title_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.553cm; WIDTH: 3.472cm" 
title=Title>Title</SPAN><TEXTAREA id=Title style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 0.553cm; WIDTH: 5.164cm" tabIndex=2 title=Title></TEXTAREA><SPAN 
class=MSTheme-Label id=Description_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 1.059cm; WIDTH: 3.472cm" 
title=Description>Description</SPAN><TEXTAREA id=Description style="HEIGHT: 1.524cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 1.059cm; WIDTH: 10.244cm" tabIndex=3 title=Description></TEXTAREA><SPAN 
class=MSTheme-Label id=Status_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 2.666cm; WIDTH: 3.472cm" 
title=Status>Status</SPAN><TEXTAREA id=Status style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 2.666cm; WIDTH: 5.164cm" tabIndex=4 title=Status></TEXTAREA><SPAN 
class=MSTheme-Label id=Priority_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 3.176cm; WIDTH: 3.472cm" 
title=Priority>Priority</SPAN><TEXTAREA id=Priority style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 3.176cm; WIDTH: 5.164cm" tabIndex=5 title=Priority></TEXTAREA><SPAN 
class=MSTheme-Label id=DateEntered_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 3.684cm; WIDTH: 3.472cm" 
title=DateEntered>DateEntered</SPAN><TEXTAREA id=DateEntered style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 3.684cm; WIDTH: 1.758cm" tabIndex=6 title=DateEntered></TEXTAREA><SPAN 
class=MSTheme-Label id=EnteredBy_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 4.192cm; WIDTH: 3.472cm" 
title=EnteredBy>EnteredBy</SPAN><TEXTAREA id=EnteredBy style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 4.192cm; WIDTH: 5.164cm" tabIndex=7 title=EnteredBy></TEXTAREA><SPAN 
class=MSTheme-Label id=DateResolved_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 5.206cm; WIDTH: 3.472cm" 
title=DateResolved>DateResolved</SPAN><TEXTAREA id=DateResolved style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 5.206cm; WIDTH: 1.758cm" tabIndex=9 title=DateResolved></TEXTAREA><SPAN 
class=MSTheme-Label id=Resolution_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 5.716cm; WIDTH: 3.472cm" 
title=Resolution>Resolution</SPAN><TEXTAREA id=Resolution style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 5.716cm; WIDTH: 5.164cm" tabIndex=10 title=Resolution></TEXTAREA><SPAN 
class=MSTheme-Label id=ResolvedBy_标签 
style="HEIGHT: 0.445cm; LEFT: 1.483cm; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 6.222cm; WIDTH: 3.472cm" 
title=ResolvedBy>ResolvedBy</SPAN><TEXTAREA id=ResolvedBy style="HEIGHT: 0.445cm; LEFT: 4.954cm; OVERFLOW: hidden; POSITION: absolute; TOP: 6.222cm; WIDTH: 5.164cm" tabIndex=11 title=ResolvedBy></TEXTAREA></DIV>
<DIV class=MicrosoftAccessBanner id=浏览节IssuesForReportBanner 
style="BACKGROUND-COLOR: buttonface; BORDER-BOTTOM: buttonhighlight 2px outset; BORDER-LEFT: buttonhighlight 2px outset; BORDER-RIGHT: buttonhighlight 2px outset; BORDER-TOP: buttonhighlight 2px outset; DISPLAY: none; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; FONT-WEIGHT: normal; HEIGHT: 0.2in; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 720px">浏览节: 
IssuesForReport</DIV>
<DIV class=MSOShowDesignGrid id=浏览节IssuesForReport 
style="BACKGROUND-COLOR: transparent; HEIGHT: 35px; OVERFLOW: hidden; POSITION: relative; VISIBILITY: hidden; WIDTH: 720px">
<OBJECT classid=CLSID:0002E531-0000-0000-C000-000000000046 
codeBase="file:\\VERCONTROL\OFFICE 2000\OFFICE2K\CD1\msowc.cab#version=9,0,0,2710" 
id=IssuesForReport浏览 
style="LEFT: 1.481cm; POSITION: absolute; TOP: 0.105cm; WIDTH: 629px"><PARAM NAME="_State" VALUE=""><PARAM NAME="RecordSource" VALUE="IssuesForReport"><PARAM NAME="RecordsetLabel" VALUE="IssuesForReport |2 之 |0;IssuesForReport |2 之 |0-|1"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM NAME="ShowPrevButton" VALUE="-1"><PARAM NAME="ShowNextButton" VALUE="-1"><PARAM NAME="ShowLastButton" VALUE="-1"><PARAM NAME="ShowNewButton" VALUE="-1"><PARAM NAME="ShowDelButton" VALUE="-1"><PARAM NAME="ShowSaveButton" VALUE="-1"><PARAM NAME="ShowUndoButton" VALUE="-1"><PARAM NAME="ShowSortAscendingButton" VALUE="-1"><PARAM NAME="ShowSortDecendingButton" VALUE="-1"><PARAM NAME="ShowApplyFilterButton" VALUE="-1"><PARAM NAME="ShowToggleFilterButton" VALUE="-1"><PARAM NAME="ShowHelpButton" VALUE="-1"><PARAM NAME="ShowLabel" VALUE="-1"><PARAM NAME="FontName" VALUE="宋体"></OBJECT></DIV>
<P><A href="C:\WINDOWS\Desktop\access\Practices\CH13\Reassign.htm" 
id=超级链接0_Anchor><SPAN class=msoHyperlinkDisplayText id=超级链接0 
style="CURSOR: hand; HEIGHT: 0.476cm; OVERFLOW: hidden; PADDING-LEFT: 1px; WIDTH: 3.306cm" 
title=C:\WINDOWS\Desktop\access\Practices\CH13\Reassign.htm>Reassign 
Issues</SPAN></A></P></BODY></HTML>