⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 reassign.htm

📁 这是access数据库使用的一些例子,可供学习使用
💻 HTM
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML XMLNS:dt = uuid:C2F41010-65B3-11d1-A29F-00AA00C14882 XMLNS:a = 
urn:schemas-microsoft-com:office:access XMLNS:x = 
urn:schemas-microsoft-com:office:excel XMLNS:o = 
urn:schemas-microsoft-com:office:office><HEAD><TITLE>Ressign Issues</TITLE><LINK 
href="./Reassign_files/filelist.xml" rel=File-List type=text/xml>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers VALUE = TRUE>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<STYLE id=MSODAPDEFAULTS type=text/css rel = stylesheet></STYLE>

<OBJECT classid=CLSID:0002E530-0000-0000-C000-000000000046 id=MSODSC><PARAM NAME="XMLData" VALUE="&lt;xml xmlns:a=&quot;urn:schemas-microsoft-com:office:access&quot;&gt;&#13;&#10; &lt;a:DataSourceControl&gt;&#13;&#10;  &lt;a:OWCVersion&gt;9.0.0.2404&lt;/a:OWCVersion&gt;&#13;&#10;  &lt;a:ConnectionString&gt;Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=Issues.mdb;Mode=Share Deny None;Jet OLEDB:System database=&amp;quot;&amp;quot;&lt;/a:ConnectionString&gt;&#13;&#10;  &lt;a:MaxRecords&gt;10000&lt;/a:MaxRecords&gt;&#13;&#10;  &lt;a:GridX&gt;24&lt;/a:GridX&gt;&#13;&#10;  &lt;a:GridY&gt;24&lt;/a:GridY&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;OpenIssuesNavigation&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ConsumesRecordset/&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;IssueID&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;IssueID&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;IssueID_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;Title&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;Title&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;Title_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;Description&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;Description&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;Description_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;Priority&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;Priority&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;Priority_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;DateEntered&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;DateEntered&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;DateEntered_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;EnteredBy&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;EnteredBy&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;EnteredBy_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;AssignedTo&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ControlSource&gt;AssignedTo&lt;/a:ControlSource&gt;&#13;&#10;   &lt;a:ChildLabel&gt;AssignedTo_Label&lt;/a:ChildLabel&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;DropdownList0&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ListRowSource&gt;Employees&lt;/a:ListRowSource&gt;&#13;&#10;   &lt;a:ListBoundField&gt;EmployeeID&lt;/a:ListBoundField&gt;&#13;&#10;   &lt;a:ListDisplayField&gt;EmployeeName&lt;/a:ListDisplayField&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:ElementExtension&gt;&#13;&#10;   &lt;a:ElementID&gt;NewAssignee&lt;/a:ElementID&gt;&#13;&#10;   &lt;a:ListRowSource&gt;EmployeesQuery&lt;/a:ListRowSource&gt;&#13;&#10;   &lt;a:ListBoundField&gt;EmployeeID2&lt;/a:ListBoundField&gt;&#13;&#10;   &lt;a:ListDisplayField&gt;EmployeeName1&lt;/a:ListDisplayField&gt;&#13;&#10;  &lt;/a:ElementExtension&gt;&#13;&#10;  &lt;a:GroupLevel&gt;&#13;&#10;   &lt;a:RecordSource&gt;IssuesForReport&lt;/a:RecordSource&gt;&#13;&#10;   &lt;a:DefaultSort&gt;&lt;/a:DefaultSort&gt;&#13;&#10;   &lt;a:HeaderElementId&gt;HeaderIssuesForReport&lt;/a:HeaderElementId&gt;&#13;&#10;   &lt;a:FooterElementId&gt;&lt;/a:FooterElementId&gt;&#13;&#10;   &lt;a:CaptionElementId&gt;&lt;/a:CaptionElementId&gt;&#13;&#10;   &lt;a:RecordNavigationElementId&gt;NavigationSectionIssuesForReport&lt;/a:RecordNavigationElementId&gt;&#13;&#10;   &lt;a:DataPageSize&gt;1&lt;/a:DataPageSize&gt;&#13;&#10;  &lt;/a:GroupLevel&gt;&#13;&#10;  &lt;a:Datamodel version=&quot;0816&quot;&gt;&#13;&#10;   &lt;a:SchemaRowsource id=&quot;Employees&quot; type=&quot;dscTable&quot;&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;EmployeeID&quot; datatype=&quot;3&quot; size=&quot;0&quot; iskey=&quot;1&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;EmployeeName&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;WorkPhone&quot; datatype=&quot;130&quot; size=&quot;30&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;SupervisorID&quot; datatype=&quot;3&quot; size=&quot;0&quot;/&gt;&#13;&#10;   &lt;/a:SchemaRowsource&gt;&#13;&#10;   &lt;a:SchemaRowsource id=&quot;EmployeesQuery&quot; type=&quot;dscView&quot;&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;EmployeeID&quot; datatype=&quot;3&quot; size=&quot;0&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;EmployeeName&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;   &lt;/a:SchemaRowsource&gt;&#13;&#10;   &lt;a:SchemaRowsource id=&quot;IssuesForReport&quot; type=&quot;dscView&quot;&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;IssueID&quot; datatype=&quot;3&quot; size=&quot;0&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;Title&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;Description&quot; datatype=&quot;203&quot; size=&quot;0&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;Status&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;Priority&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;DateEntered&quot; datatype=&quot;7&quot; size=&quot;0&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;EnteredBy&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;AssignedTo&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;DateResolved&quot; datatype=&quot;7&quot; size=&quot;0&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;Resolution&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;    &lt;a:SchemaField id=&quot;ResolvedBy&quot; datatype=&quot;130&quot; size=&quot;50&quot;/&gt;&#13;&#10;   &lt;/a:SchemaRowsource&gt;&#13;&#10;   &lt;a:RecordsetDef id=&quot;Employees&quot; uniquetable=&quot;Employees&quot;&gt;&#13;&#10;    &lt;a:PageField id=&quot;EmployeeID&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;EmployeeName&quot;/&gt;&#13;&#10;   &lt;/a:RecordsetDef&gt;&#13;&#10;   &lt;a:RecordsetDef id=&quot;EmployeesQuery&quot;&gt;&#13;&#10;    &lt;a:PageField id=&quot;EmployeeID1&quot; source=&quot;EmployeeID&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;EmployeeName1&quot; source=&quot;EmployeeName&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;EmployeeID2&quot; source=&quot;EmployeeID&quot;/&gt;&#13;&#10;   &lt;/a:RecordsetDef&gt;&#13;&#10;   &lt;a:RecordsetDef id=&quot;IssuesForReport&quot;&gt;&#13;&#10;    &lt;a:PageField id=&quot;IssueID&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;Title&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;Description&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;Priority&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;DateEntered&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;EnteredBy&quot;/&gt;&#13;&#10;    &lt;a:PageField id=&quot;AssignedTo&quot;/&gt;&#13;&#10;   &lt;/a:RecordsetDef&gt;&#13;&#10;  &lt;/a:Datamodel&gt;&#13;&#10; &lt;/a:DataSourceControl&gt;&#13;&#10;&lt;/xml&gt;'&quot;"></OBJECT>
<META content="MSHTML 5.00.1011.2000" name=GENERATOR>
<META content="strtedge 011" name="Microsoft Theme 2.00">
<LINK href="./Reassign_files/file0001.css" id=mstheme rel=StyleSheet type=text/css>
<LINK href="./Reassign_files/file0002.css" id=mstheme rel=StyleSheet type=text/css>
<LINK href="./Reassign_files/file0003.css" id=mstheme rel=StyleSheet type=text/css>
</HEAD>
<BODY bottomMargin=48 leftMargin=24 link=#800080 rightMargin=24 topMargin=24 vLink=#800080>
<P>
<P>
<H1 id=HeadingText style="FONT-WEIGHT: normal"><FONT size=5>Reassign an Issue</FONT></H1>
<P id=HeadingText style="FONT-WEIGHT: normal">Find the issue you want to
reassign, then select an employee name at the bottom of the page to 
automatically reassign it.</P>
<P></P>
<DIV class=MicrosoftAccessBanner id=HeaderIssuesForReportBanner 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: Tahoma; FONT-SIZE: 8pt; FONT-WEIGHT: normal; HEIGHT: 0.2in; PADDING-LEFT: 1px; WIDTH: 500px">
Header: IssuesForReport</DIV>
<DIV class=MSOShowDesignGrid id=HeaderIssuesForReport style="BACKGROUND-COLOR: transparent; HEIGHT: 168px; POSITION: relative; VISIBILITY: hidden; WIDTH: 500px">
<SPAN class=MSTheme-Label id=IssueID_Label style="HEIGHT: 0.177in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.042in; WIDTH: 1.083in" title=IssueID>IssueID</SPAN>
<TEXTAREA id=IssueID style="HEIGHT: 17px; LEFT: 108px; OVERFLOW: hidden; POSITION: absolute; TOP: 4px; WIDTH: 72px" tabIndex=1 title=IssueID></TEXTAREA> 

<SPAN class=MSTheme-Label id=Title_Label style="HEIGHT: 0.177in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.292in; WIDTH: 1.083in" title=Title>Title</SPAN>
<TEXTAREA id=Title style="HEIGHT: 17px; LEFT: 108px; OVERFLOW: hidden; POSITION: absolute; TOP: 28px; WIDTH: 354px" tabIndex=2 title=Title></TEXTAREA> 

<SPAN class=MSTheme-Label id=Description_Label style="HEIGHT: 0.177in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 0.542in; WIDTH: 1.083in" title=Description>Description</SPAN><TEXTAREA id=Description style="HEIGHT: 56px; LEFT: 108px; OVERFLOW: hidden; POSITION: absolute; TOP: 52px; WIDTH: 354px" tabIndex=3 title=Description></TEXTAREA> 

<SPAN class=MSTheme-Label id=Priority_Label style="HEIGHT: 0.177in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 1.208in; WIDTH: 1.083in" title=Priority>Priority</SPAN><TEXTAREA id=Priority style="HEIGHT: 17px; LEFT: 108px; OVERFLOW: hidden; POSITION: absolute; TOP: 116px; WIDTH: 122px" tabIndex=4 title=Priority></TEXTAREA> 

<SPAN class=MSTheme-Label id=DateEntered_Label style="HEIGHT: 17px; LEFT: 266px; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 120px; WIDTH: 72px" title=DateEntered>Date Entered</SPAN><TEXTAREA id=DateEntered style="HEIGHT: 17px; LEFT: 344px; OVERFLOW: hidden; POSITION: absolute; TOP: 120px; WIDTH: 117px" tabIndex=5 title=DateEntered></TEXTAREA> 

<SPAN class=MSTheme-Label id=EnteredBy_Label style="HEIGHT: 17px; LEFT: 265px; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 140px; WIDTH: 66px" title=EnteredBy>EnteredBy</SPAN><TEXTAREA id=EnteredBy style="HEIGHT: 17px; LEFT: 344px; OVERFLOW: hidden; POSITION: absolute; TOP: 140px; WIDTH: 117px" tabIndex=6 title=EnteredBy></TEXTAREA> 

<SPAN class=MSTheme-Label id=AssignedTo_Label style="HEIGHT: 0.177in; LEFT: 0.042in; OVERFLOW: visible; PADDING-LEFT: 1px; POSITION: absolute; TOP: 1.458in; WIDTH: 1.083in" title=AssignedTo>AssignedTo</SPAN><TEXTAREA id=AssignedTo style="HEIGHT: 17px; LEFT: 108px; OVERFLOW: hidden; POSITION: absolute; TOP: 140px; WIDTH: 122px" tabIndex=7 title=AssignedTo></TEXTAREA></DIV>

<DIV class=MicrosoftAccessBanner id=NavigationSectionIssuesForReportBanner 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: Tahoma; FONT-SIZE: 8pt; FONT-WEIGHT: normal; HEIGHT: 0.2in; PADDING-LEFT: 1px; WIDTH: 500px">NavigationSection: 
IssuesForReport</DIV>
<DIV class=MSOShowDesignGrid id=NavigationSectionIssuesForReport style="BACKGROUND-COLOR: transparent; HEIGHT: 35px; POSITION: relative; VISIBILITY: hidden; WIDTH: 500px">

</DIV>
<P>&nbsp;</P>
<P>Reassign Issue To:&nbsp; 
<SELECT id=NewAssignee style="HEIGHT: 20px; LEFT: 2.333in; TOP: 1.417in; WIDTH: 194px" tabIndex=8 title=NewAssignee>
</SELECT>
</P>
<P>
<P>&nbsp;</P>
<P>&nbsp;</P>
</BODY>

</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -