📄 如何使access主窗体右上角的一些按钮失效(如关闭、最大化、最小化、还原)_mysky.htm
字号:
<TR>
<TD>
<DIV class=cnt id=blog_text><FONT
size=3>如何使ACCESS主窗体右上角的一些按钮失效(如关闭、最大化、最小化、还原)</FONT>
<DIV class=post-title>
<H3></H3></DIV>
<DIV class=itemtext>
<P>
<TABLE style="WIDTH: 100%" cellSpacing=1 cellPadding=5>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: #81a9e8 1px solid; PADDING-RIGHT: 10px; BORDER-TOP: #81a9e8 1px solid; MARGIN-TOP: 0px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; BORDER-LEFT: #81a9e8 1px solid; COLOR: #00284d; PADDING-TOP: 10px; BORDER-BOTTOM: #81a9e8 1px solid; BACKGROUND-COLOR: #f2f2f2; TEXT-DECORATION: none"
width="100%"><BR>Private Declare Function DeleteMenu Lib "user32"
(ByVal hMenu As Long, ByVal nPosition As Long, ByVal wFlags As Long)
As Long <BR>Private Declare Function GetSystemMenu Lib "user32"
(ByVal hwnd As Long, ByVal bRevert As Long) As Long <BR>Private
Const MF_BYCOMMAND = &H0& <BR>Private Const SC_MAXIMIZE =
&HF030 <BR>Private Const SC_RESTORE = &HF120<BR>Private
Const SC_SIZE = &HF000<BR>Private Const SC_MOVE =
&HF010<BR>Private Const SC_MINIMIZE = &HF020<BR>Private
Const SC_CLOSE = &HF060<BR><BR><FONT color=#008000>'以上代码放在声明段
</FONT>
<P></P>
<P>Dim hMenu As Long, Success As Long <BR>hMenu =
GetSystemMenu(Application.hWndAccessApp, 0) <BR><FONT
color=#008000>'禁止还原按钮</FONT><BR>Success = DeleteMenu(hMenu,
SC_RESTORE, MF_BYCOMMAND) <BR><FONT
color=#008000>'禁止改变大小</FONT><BR>Success = DeleteMenu(hMenu, SC_SIZE,
MF_BYCOMMAND) <BR><FONT color=#008000>'禁止最大化</FONT><BR>Success =
DeleteMenu(hMenu, SC_MAXIMIZE, MF_BYCOMMAND) <BR><FONT
color=#008000>'禁止最小化</FONT><BR>Success = DeleteMenu(hMenu,
SC_MINIMIZE, MF_BYCOMMAND) <BR><FONT
color=#008000>'禁止关闭</FONT><BR>Success = DeleteMenu(hMenu, SC_CLOSE,
MF_BYCOMMAND) <BR><FONT color=#008000>'禁止移动</FONT><BR>Success =
DeleteMenu(hMenu, SC_MOVE, MF_BYCOMMAND)
</P></TD></TR></TBODY></TABLE><BR>如果要用 API 函数去实现上述操作应该使用 SENDMESSAGE
函数</P>
<P>
<TABLE style="WIDTH: 100%" cellSpacing=1 cellPadding=5>
<TBODY>
<TR>
<TD
style="BORDER-RIGHT: #81a9e8 1px solid; PADDING-RIGHT: 10px; BORDER-TOP: #81a9e8 1px solid; MARGIN-TOP: 0px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px; BORDER-LEFT: #81a9e8 1px solid; COLOR: #00284d; PADDING-TOP: 10px; BORDER-BOTTOM: #81a9e8 1px solid; BACKGROUND-COLOR: #f2f2f2; TEXT-DECORATION: none"
width="100%">Public Const WM_SYSCOMMAND = &H112<BR>Public Const
SC_CLOSE = &HF060& <FONT
color=#008000>'关闭窗体</FONT><BR>Public Const SC_MINIMIZE =
&HF020& <FONT color=#008000>'最小化窗体</FONT><BR>Public Const
SC_MAXIMIZE = &HF030& <FONT
color=#008000>'最大化窗体</FONT><BR>Public Const SC_RESTORE =
&HF120& <FONT color=#008000>'恢复窗体大小</FONT><BR>Public Const
WM_SETTEXT = &HC <FONT
color=#008000>'设置窗体的Caption</FONT><BR>Public Const WM_GETTEXT =
&HD <FONT color=#008000>'取得窗体的caption</FONT><BR>Declare Function
SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long,
ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As
Long<BR><FONT color=#008000>'以上放入声明段</FONT>
<P></P>
<P>Private Sub Command_Click(Index As
Integer)<BR> Dim S As
String<BR> S = String(80, Chr(0))</P>
<P> Select Case
Index<BR> Case
0<BR>
SendMessage Application.hWndAccessApp, WM_GETTEXT, Len(S), ByVal S
<FONT
color=#008000>'读出窗体的</FONT>Caption<BR> <FONT
color=#008000>'在用户自己的窗体中加一个文本框，用于操作ACCESS主窗体标题</FONT><BR>
Text1.Text = Left(S, InStr(S, Chr(0)) -
1)<BR> Case
1<BR> <FONT
color=#008000>'因为Text1.text属于Variant类型，所以一定先要用CStr把它转换成字符串</FONT><BR>
SendMessage Application.hWndAccessApp, WM_SETTEXT, 0, ByVal
CStr(Text1.Text) <FONT
color=#008000>'设置窗体的Caption</FONT><BR>
Case
2<BR>
SendMessage Application.hWndAccessApp, WM_SYSCOMMAND, SC_MAXIMIZE,
ByVal 0&<FONT
color=#008000>'使窗体最大化</FONT><BR>
Case
3<BR>
SendMessage Application.hWndAccessApp, WM_SYSCOMMAND, SC_MINIMIZE,
ByVal 0&<FONT
color=#008000>'使窗体最小化</FONT><BR>
Case
4<BR>
SendMessage Application.hWndAccessApp, WM_SYSCOMMAND, SC_RESTORE,
ByVal 0&<FONT
color=#008000>'使窗体恢复原来的大小</FONT><BR>
Case
5<BR>
SendMessage Application.hWndAccessApp, WM_SYSCOMMAND, SC_CLOSE,
ByVal 0&<FONT
color=#008000>'关闭窗体</FONT><BR>
End Select<BR>End
Sub</P></TD></TR></TBODY></TABLE></P></DIV></DIV></TD></TR></TBODY></TABLE><BR>
<DIV class=opt><A title=查看该分类中所有文章
href="http://hi.baidu.com/gallonchai/blog/category/accessÏà¹Ø">类别：access相关</A> |
<A title=将此文章添加到百度搜藏 onclick="return addToFavor();"
href="http://cang.baidu.com/do/add" target=_blank>添加到搜藏</A> | 浏览(<SPAN
id=result></SPAN>) | <A
href="http://hi.baidu.com/gallonchai/blog/item/bb8441ce324f4c3bb700c869.html#send">评论</A> (0)
<SCRIPT language=javascript>/*<![CDATA[*/var pre = [true,'ACCESS用链接表方法链SQL', 'ACCESS用链接表方法链SQL','/gallonchai/blog/item/0f70861b717882d7ad6e7599.html'];var post = [true,'使用VBA代码刷新链接表（ODBC）','使用VBA代码刷新链接表（ODBC）', '/gallonchai/blog/item/ef78a9fa94f56adcb58f3171.html'];if(pre[0] || post[0]){ document.write('<div style="height:5px;line-height:5px;"> </div><div id="in_nav">'); if(pre[0]){ document.write('上一篇：<a href="' + pre[3] + '" title="' + pre[1] + '">' + pre[2] + '</a> '); } if(post[0]){ document.write('下一篇：<a href="' + post[3] + '" title="' + post[1] + '">' + post[2] + '</a>'); } document.write('</div>');}/*]]>*/</SCRIPT>
</DIV>
<DIV class=line></DIV>
<STYLE type=text/css>#in_related_doc A {
TEXT-DECORATION: none
}
</STYLE>
<DIV id=in_related_tmp></DIV>
<SCRIPT language=javascript type=text/javascript>/*<![CDATA[*/function HI_MOD_IN_RELATED_DOC_CALLBACK(arg){ if(arg.length <= 1) return false; var hasMore = arg[0]; var D=function(A,B){A[A.length]=B;} if(arg.length % 2 == 0) D(arg, ["","","",""]); var html = ['<div id="in_related_doc"><div class="tit">相关文章：</div>']; D(html, '<table cellpadding="0" cellspacing="3" border="0">'); for(var i = 1, j = arg.length; i < j; i += 2){ D(html, '<tr>'); D(html, '<td width="15px"><a style="font-size:25px" >•</a></td><td><a href="http://hi.baidu.com/' + arg[i][3] + '/blog/item/' + arg[i][2] + '.html" target="_blank" title="' + arg[i][0] + '">' + arg[i][1] + '</a>'); D(html, new Array(10).join('\u3000')); D(html, '</td>'); if(arg[i + 1][0] != "") D(html, '<td width="15px"><a style="font-size:25px" >•</a></td><td><a href="http://hi.baidu.com/' + arg[i + 1][3] + '/blog/item/' + arg[i + 1][2] + '.html" target="_blank" title="' + arg[i + 1][0] + '">' + arg[i + 1][1] + '</a></td>'); else D(html, '<td> </td><td> </td>'); D(html, '</tr>'); } if(hasMore) D(html, '<tr><td colspan="4"><a target="_blank" href="/sys/search?pageno=1&type=7&sort=1&word=%C8%E7%BA%CE%CA%B9ACCESS%D6%F7%B4%B0%CC%E5%D3%D2%C9%CF%BD%C7%B5%C4%D2%BB%D0%A9%B0%B4%C5%A5%CA%A7%D0%A7%28%C8%E7%B9%D8%B1%D5%A1%A2%D7%EE%B4%F3%BB%AF%A1%A2%D7%EE%D0%A1%BB%AF%A1%A2%BB%B9%D4%AD%29&item=bb8441ce324f4c3bb700c869">更多>></a></td></tr>'); D(html, '</table></div><div class="line"> </div>'); var div = document.getElementById('in_related_tmp'); if(div){ div.innerHTML = html.join(''); while(div.firstChild){ div.parentNode.insertBefore(div.firstChild, div); } div.parentNode.removeChild(div); } window.setTimeout("tracker_init('in_related_doc')",100);}if(RelatedDocData == -1){ // not supported xhr var script = document.createElement('script'); script.type = 'text/javascript'; script.src = '/sys/search?type=8&word=%C8%E7%BA%CE%CA%B9ACCESS%D6%F7%B4%B0%CC%E5%D3%D2%C9%CF%BD%C7%B5%C4%D2%BB%D0%A9%B0%B4%C5%A5%CA%A7%D0%A7%28%C8%E7%B9%D8%B1%D5%A1%A2%D7%EE%B4%F3%BB%AF%A1%A2%D7%EE%D0%A1%BB%AF%A1%A2%BB%B9%D4%AD%29&item=bb8441ce324f4c3bb700c869&t=' + new Date().getTime(); document.getElementsByTagName('HEAD')[0].appendChild(script);}else if(RelatedDocData == null){ GetAndEval = true;}else{ eval(RelatedDocData);}/*]]>*/</SCRIPT>
<DIV id=in_reader>
<DIV class=tit>最近读者：</DIV>
<SCRIPT> var g_spAnnony=true;var g_read=[ ["jjbb2","e9b36a6a626232b600","jjbb2"], ["huhailin","ee09776f6c696e5f68754002","wolin_hu"],{}];g_read.length=g_read.length-1;var _rh1="";var _rh2="";function wrreader(){ _rh1 += '<table width="100%" ><tr>'; _rh2+='<tr>'; if(g_spAnnony){ _rh1+='<td align="center" width="10%" ><img border="0" width="55" height="55" src="http://img.baidu.com/hi/img/portraitn.jpg"></td>'; _rh2+='<td> </td>'; if(g_read.length>0){ _rh1+='<td align="left" width="12%">'; }else{ _rh1+='<td align="left" width="100%">'; } _rh1+="<a href='http://passport.baidu.com/?login&tpl=sp&tpl_reg=sp&u="+myref+"' target='_self'>登录</a>后，您就出现在这里。</td>"; _rh2+='<td> </td>' } if(g_read.length==0){ if(!g_spAnnony){ _rh1+='<td align=left width="100%">最近还没有登录用户看过这篇文章……</td>'; _rh2+='<td> </td>'; } }else{ for(i=0,len=g_read.length;i<len;i++){ _rh1+='<td align="center" valign="bottom" width="10%" class="user"><a href="/'+g_read[i][0]+'" target="_blank"><img border="0" src="http://himg.baidu.com/sys/portraitn/item/'+g_read[i][1]+'.jpg"></a></td>'; _rh2+='<td align="center" valign="top" class="user"><a href="/'+g_read[i][0]+'" target="_blank">'+g_read[i][2]+'</a></td>'; } } _rh1+='<td width="100%"></td></tr>'; _rh2+='<td></td></tr></table>'; document.write(_rh1+_rh2);}wrreader();</SCRIPT>
</DIV>
<DIV class=line></DIV>
<SCRIPT language=JavaScript>allkey=allkey+"268962d15d40ed389b5027b9_bb8441ce324f4c3bb700c869_";</SCRIPT>
<DIV id=in_comment><A name=comment></A>
<DIV class=tit>网友评论：</DIV>
<SCRIPT>function writecmt(type,id,cmtname,cmturl,portraitId){ var html1=""; if(type==1){ html1="<a href='"+cmturl+"' target='_blank' title='"+cmturl+"'><img border='0' src='http://himg.baidu.com/sys/portraitn/item/"+portraitId+".jpg'><br>"+cmtname+"</a>"; }else{ if(cmtname=="" || cmtname=="匿名网友"){ if(cmturl==""){ html1="<a>匿名网友</a>"; }else{ html1="<a href='"+cmturl+"' target='_blank' title='"+cmturl+"'>"+cmtname+"</a>"; } }else{ if(cmturl==""){ html1="<div class='f14' style='display:inline'>网友:<a>"+cmtname+"</a></div>"; }else{ html1="<div class='f14' style='display:inline'>网友:<a href='"+cmturl+"' target='_blank' title='"+cmturl+"'>"+cmtname+"</a></div>"; } } } document.write(html1);}</SCRIPT>
<DIV id=page></DIV></DIV>
<DIV id=in_send><A name=send></A>
<FORM id=popFormSubmit name=form1 onsubmit="return checkcmtform()"
action=/gallonchai/commit method=post><INPUT type=hidden value=8 name=ct> <INPUT
type=hidden value=1 name=cm> <INPUT type=hidden value=bb8441ce324f4c3bb700c869
name=spBlogID>
<SCRIPT language=JavaScript> document.write("<input type='hidden' name='spRefURL' value='"+window.location.href+"'>");</SCRIPT>
<DIV class=tit>发表评论：</DIV>
<TABLE cellSpacing=5 cellPadding=0 width=620 border=0>
<TBODY>
<TR>
<TD class=f14>姓 名：</TD>
<TD><INPUT id=spBlogCmtor style="WIDTH: 220px" onfocus=hidErr(1);
tabIndex=1 maxLength=49 onchange="checkname('spBlogCmtor')"
name=spBlogCmtor>
<SCRIPT>document.write(" <a href='http://passport.baidu.com/?reg&tpl=sp&return_method=get&skip_ok=1&u=http://hi.baidu.com/sys/reg/' target='_blank'>注册</a>");document.write(" | <a href='http://passport.baidu.com/?login&tpl=sp&tpl_reg=sp&u="+myref+"'>登录</a>");</SCRIPT>
<DIV id=nmerror style="DISPLAY: none">*姓名最长为50字节</DIV></TD></TR>
<TR id=1_err style="DISPLAY: none">
<TD> </TD>
<TD>
<DIV class=error id=1_err_con></DIV></TD></TR>
<TR>
<TD class=f14>网址或邮箱：</TD>
<TD><INPUT id=spBlogCmtURL style="WIDTH: 360px" onfocus=hidErr(2);
tabIndex=2 maxLength=128 onchange="checkeandu('spBlogCmtURL')"
name=spBlogCmtURL> (选填)</TD>
<SCRIPT>G("spBlogCmtor").value="";G("spBlogCmtURL").value="";</SCRIPT>
</TR>
<TR id=2_err style="DISPLAY: none">
<TD> </TD>
<TD>
<DIV class=error id=2_err_con></DIV></TD></TR>
<TR>
<TD class=f14 vAlign=top>内 容：</TD>
<TD><TEXTAREA id=spBlogCmtText style="WIDTH: 520px; HEIGHT: 155px" onfocus=hidErr(3); tabIndex=3 name=spBlogCmtText></TEXTAREA>
<SCRIPT>G("spBlogCmtor").value=G("spBlogCmtor").defaultValue;G("spBlogCmtText").value="";</SCRIPT>
</TD></TR>
<TR id=3_err style="DISPLAY: none">
<TD> </TD>
<TD>
<DIV class=error id=3_err_con></DIV></TD></TR>
<TR id=vercode>
<TD class=f14 vAlign=top>验证码：</TD>
<TD vAlign=top><INPUT type=hidden
value=A6841064F1F7A2A2C308468349AA3EB9493FC43A7420B1680DC1FDFB303C5AAC99F6AA3FB31BFAB3FAA5726FB3ECDA0004706D8EDCC55713AB673AA40B754F03
name=spVcode> <INPUT id=spVerifyKey onfocus=f_focus() tabIndex=4
maxLength=4 size=6 name=spVerifyKey autocomplete="off"><BR>
<SCRIPT type=text/javascript>/*<![CDATA[*/var imgsrc="http://hiup.baidu.com/cgi-bin/genimg?A6841064F1F7A2A2C308468349AA3EB9493FC43A7420B1680DC1FDFB303C5AAC99F6AA3FB31BFAB3FAA5726FB3ECDA0004706D8EDCC55713AB673AA40B754F03";function f_focus(){ if(G('yanzheng').style.display=="none" ){ G('verifypic').src=imgsrc; G('yanzheng').style.display="block"; }}function newverifypic(){ G("verifypic").src = imgsrc +"&t="+ Math.random(); return false;}/*]]>*/</SCRIPT>
<DIV id=yanzheng style="DISPLAY: none"><IMG id=verifypic height=40
width=120><WBR><A title=看不清左边的字符 onfocus=this.blur();
onclick="return newverifypic();"
href="http://hi.baidu.com/gallonchai/blog/item/bb8441ce324f4c3bb700c869.html#">看不清?</A>
</DIV></TD></TR>
<TR>
<TD class=f14 vAlign=top> </TD>
<TD class=f14 vAlign=top><INPUT id=btn_ok tabIndex=5 type=submit value=发表评论 name=btn_ok></TD></TR></TBODY></TABLE></FORM></DIV><BR></DIV>
<TABLE height=8 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=modbl width=7> </TD>
<TD class=modbc> </TD>
<TD class=modbr width=7> </TD></TR></TBODY></TABLE></DIV></DIV></DIV></DIV>
<SCRIPT language=javascript><!--var hstr="/gallonchai/brwstat?key1=1";document.write("<script src='"+hstr+"&key2="+allkey+"'><\/script>");//--></SCRIPT>
<BR>
<CENTER>
<DIV id=ft>©2008 Baidu</DIV></CENTER>
<SCRIPT>if(document.getElementById("m_blog")){ var imgarray = document.getElementById("m_blog").getElementsByTagName('img'); var imgw = document.getElementById("m_blog").offsetWidth; imgw =imgw-40; for(var i=0; i<imgarray.length; i++){ if(imgarray[i].className=="blogimg" && imgarray[i].width>=imgw) imgarray[i].width=imgw; }}// Fix ff bugsvar blog_text = document.getElementById('blog_text');blog_text.innerHTML = blog_text.innerHTML.replace(/href\s*=\s*("|')?(\.\.\/\.\.\/)/gi,"href=$1../$2");</SCRIPT>
</CENTER><IMG style="DISPLAY: none" src=""> </BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -