11389.html

来自「VB技巧问答10000例,是一个教程」· HTML 代码 · 共 30 行

HTML
30
字号
<html>
  <head>
    <title>报表出问题啦</title>
  </head>
  <body bgcolor="#FFFFFF" vlink="#808080">
    <center>
      <h1>报表出问题啦</h1>
    </center>
<hr size=7 width=75%>

<hr size=7 width=75%><p>
Posted by <a href="mailto:g863805@oz.nthu.edu.tw">Fred Tsai</a> on March 26, 1999 at 16:12:32:<p>
各位高手真的要帮忙一下啦<br>我用VB要跑一份报表,我以经建立了一个临时资料库存取要列印的资料(it works & shows),可是当我按下列印纽时就出现"报表档名不正确"<br>这会是什嘛原因???下面是出[问题的那一段程式..<br>感激不尽....<br>  sql_str = "select * from MonthReport"<br>  Set db = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\AKT_Temp.mdb")<br>  Set rs = db.OpenRecordset(sql_str)<br>  <br>  For i = 1 To Grid1.Rows - 1<br>     Grid1.Row = i<br>     rs.AddNew<br>     <br>     Grid1.Col = 0<br>     rs.Day = Grid1.Text<br>     Grid1.Col = 1<br>     rs.EngineerName = Grid1.Text<br>     Grid1.Col = 2<br>     rs.ID = Grid1.Text<br>     Grid1.Col = 3<br>     rs.Project = Grid1.Text<br>     Grid1.Col = 4<br>     rs.[Direct Hours] = Grid1.Text<br>     Grid1.Col = 5<br>     rs.[I&W Hours] = Grid1.Text<br>     Grid1.Col = 6<br>     rs.[Indirect Hours] = Grid1.Text<br>     Grid1.Col = 7<br>     rs.[Overtime Hours] = Grid1.Text<br>    <br>     rs.Update<br>  Next<p>  Report1.DataFiles(0) = App.Path + "\AKT_Temp.mdb"<br>  Report1.ReportFileName = App.Path + "\monthp.rpt"<p> Report1.Action = 0<br>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 11389-->
<!--top: 11980--><li><a href="11980.html">Re: 报表出问题啦</a> <b>edyln</b> <i>18:06:14 4/14/99</i>
(<!--responses: 11980-->0)
<ul><!--insert: 11980-->
</ul><!--end: 11980-->
<!--top: 11469--><li><a href="11469.html">Re: 报表出问题啦</a> <b>半百</b> <i>17:09:32 3/29/99</i>
(<!--responses: 11469-->0)
<ul><!--insert: 11469-->
</ul><!--end: 11469-->
</ul><!--end: 11389-->
<br><hr size=7 width=75%><p>

</body></html>

⌨️ 快捷键说明

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