📄 copy of accounts query.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:a =
"urn:schemas-microsoft-com:office:access" xmlns:x =
"urn:schemas-microsoft-com:office:excel" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Copy of Accounts Query</TITLE>
<META content="HTML 4.0" name=vs_targetSchema><LINK
href="Copy%20of%20Accounts%20Query_files/filelist.xml" type=text/xml
rel=File-List>
<META content=Access.Application name=ProgId>
<META name=VBSForEventHandlers value="true">
<META http-equiv=Content-Type content=text/html;charset=UTF-8>
<META content=10.00.2225 name=DesignerVersion>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-com:office:access"> <a:DataSourceControl> <a:OWCVersion>10.0.0.2621 </a:OWCVersion> <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\PIS.mdb;Mode=Share Deny None;Extended Properties=&quot;&quot;;Persist Security Info=False;Jet OLEDB:System database=&quot;&quot;;Jet OLEDB:Registry Path=&quot;&quot;;Jet OLEDB:Database Password=&quot;&quot;;Jet OLEDB:Engine Type=0;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password=&quot;&quot;;Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString> <a:MaxRecords>10000</a:MaxRecords> <a:GridX>24</a:GridX> <a:GridY>24</a:GridY> <a:OfflineType>2</a:OfflineType> <a:XMLLocation>0</a:XMLLocation> <a:XMLDataTarget></a:XMLDataTarget> <a:ConnectionFile></a:ConnectionFile> <a:ElementExtension> <a:ElementID>slip</a:ElementID> <a:ControlSource>slip</a:ControlSource> <a:ChildLabel>slip_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>patcode</a:ElementID> <a:ControlSource>patcode</a:ControlSource> <a:ChildLabel>patcode_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>phycode</a:ElementID> <a:ControlSource>phycode</a:ControlSource> <a:ChildLabel>phycode_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>roomno</a:ElementID> <a:ControlSource>roomno</a:ControlSource> <a:ChildLabel>roomno_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>addfee</a:ElementID> <a:ControlSource>addfee</a:ControlSource> <a:ChildLabel>addfee_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>roomrate</a:ElementID> <a:ControlSource>roomrate</a:ControlSource> <a:ChildLabel>roomrate_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>phyfee</a:ElementID> <a:ControlSource>phyfee</a:ControlSource> <a:ChildLabel>phyfee_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>drugcost</a:ElementID> <a:ControlSource>drugcost</a:ControlSource> <a:ChildLabel>drugcost_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>examfee</a:ElementID> <a:ControlSource>examfee</a:ControlSource> <a:ChildLabel>examfee_Label</a:ChildLabel> </a:ElementExtension> <a:ElementExtension> <a:ElementID>Accounts QueryNavLabel</a:ElementID> <a:RecordsetLabel>Accounts Query |0 of |2;Accounts Query |0-|1 of |2</a:RecordsetLabel> </a:ElementExtension> <a:GroupLevel> <a:RecordSource>Accounts Query</a:RecordSource> <a:DefaultSort></a:DefaultSort> <a:HeaderElementId>HeaderAccounts Query</a:HeaderElementId> <a:FooterElementId></a:FooterElementId> <a:CaptionElementId>CaptionAccounts Query</a:CaptionElementId> <a:RecordNavigationElementId>NavigationAccounts Query</a:RecordNavigationElementId> <a:DataPageSize>10</a:DataPageSize> <a:GroupFilterControl></a:GroupFilterControl> <a:RecordSelector/> </a:GroupLevel> <a:Datamodel a:version="0816"> <a:SchemaRowsource a:id="Accounts Query" a:type="dscProcedure"> <a:SchemaField a:id="slip" a:datatype="202" a:size="50"/> <a:SchemaField a:id="patcode" a:datatype="202" a:size="50"/> <a:SchemaField a:id="phycode" a:datatype="202" a:size="50"/> <a:SchemaField a:id="roomno" a:datatype="202" a:size="50"/> <a:SchemaField a:id="addfee" a:datatype="6" a:size="8"/> <a:SchemaField a:id="roomrate" a:datatype="6" a:size="8"/> <a:SchemaField a:id="phyfee" a:datatype="6" a:size="8"/> <a:SchemaField a:id="drugcost" a:datatype="6" a:size="8"/> <a:SchemaField a:id="examfee" a:datatype="6" a:size="8"/> </a:SchemaRowsource> <a:RecordsetDef a:id="Accounts Query"> <a:PageField a:id="slip"/> <a:PageField a:id="patcode"/> <a:PageField a:id="phycode"/> <a:PageField a:id="roomno"/> <a:PageField a:id="addfee"/> <a:PageField a:id="roomrate"/> <a:PageField a:id="phyfee"/> <a:PageField a:id="drugcost"/> <a:PageField a:id="examfee"/> </a:RecordsetDef> </a:Datamodel> </a:DataSourceControl> </xml>"></OBJECT>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN: left
}
.MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
}
.MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden; POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
.Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSectionBanner); PADDING-TOP: 2px; FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface
}
.MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW: hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
.MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
.MsoExpandCollapse {
CURSOR: hand
}
.MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-BOTTOM: gainsboro 1px solid; POSITION: absolute; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
.MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM: gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
}
.MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid; BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid; BACKGROUND-COLOR: buttonhighlight
}
.MsoNavToggleButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid; BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid; BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonhighlight
}
.MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
.MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px; BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma
}
.MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; WIDTH: 0.17in; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR: gainsboro
}
.MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11240); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11241); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; WIDTH: 0.17in; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow; POSTION: relative
}
.MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url(owc://GIF/#11242); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; WIDTH: 0.17in; TOP: 0px; POSTION: relative
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
.MSODatasheetText {
FONT-WEIGHT: 300; FONT-SIZE: 10pt; COLOR: #000000; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none
}
</STYLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR>
<SCRIPT language=Javascript id=MSODSC_Validation>
validateBrowser();
function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" && intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0 height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white><b> Data Access Page Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD bgColor='#cccccc' width=500px><BR>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p align='center'>"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -