472,983 Members | 2,656 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,983 software developers and data experts.

File not Found error on asp page

I am trying to deploy my first asp.net app to our webserver (2K server,
IIS 5)

My start page comes up and you can get to the subsequent pages that are
tied into our sql server (2K). Each page has a datagrid that loads up
just fine, but when I click on any link that updates the page, i.e. a
column header to sort the database, it returns a 404 error.

Any ideas why it works the for the inital load and not on a postback?

Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #1
11 2640
Got code?
Sounds as if you are doing something fishy...

"Steve Hoyer" <st********@hotmail.com> wrote in message news:%2****************@TK2MSFTNGP10.phx.gbl...
I am trying to deploy my first asp.net app to our webserver (2K server,
IIS 5)

My start page comes up and you can get to the subsequent pages that are
tied into our sql server (2K). Each page has a datagrid that loads up
just fine, but when I click on any link that updates the page, i.e. a
column header to sort the database, it returns a 404 error.

Any ideas why it works the for the inital load and not on a postback?

Steve Hoyer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #2
Check the IIS log. You'll see the eaxct request that raise this error...

Patrice

"Steve Hoyer" <st********@hotmail.com> a écrit dans le message de
news:%2****************@TK2MSFTNGP10.phx.gbl...
I am trying to deploy my first asp.net app to our webserver (2K server,
IIS 5)

My start page comes up and you can get to the subsequent pages that are
tied into our sql server (2K). Each page has a datagrid that loads up
just fine, but when I click on any link that updates the page, i.e. a
column header to sort the database, it returns a 404 error.

Any ideas why it works the for the inital load and not on a postback?

Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #3
Here seems to be the pertinent section of the log file. Note the
<Rejected-By-UrlScan> at the bottom.

192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/LFPSHome.htm - 404
192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/LFPSHome.html - 404
192.168.1.211 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.htm - 404
192.168.1.211 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.js - 404
192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/LFPAHome.htm - 200
192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/frmRegister.aspx -
200
192.168.1.102 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.htm - 404
192.168.1.102 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.js - 404
192.168.1.102 - 192.168.1.211 80 GET /<Rejected-By-UrlScan>
~/LFPAssisstant/frmRegister.aspx 404
Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #4
Unfortunatly, as is the way with these things, the code runs superbly
<grin> on my development machine. I am trying deploy it as my first
asp.net application and on the live server is the bombing.

I apologize for the length of this message, but if you ask for code, you
get code :)

Anyway, here is the HTML:

<%@ Page Language="vb" AutoEventWireup="false"
Codebehind="frmSessions.aspx.vb"
Inherits="LakeFrontParkAssisstant.frmSessions"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>frmSessions</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5"
name="vs_targetSchema">
</HEAD>
<body>
<A href="LFPAHome.htm">Go Home!</A>
<form id="Form1" method="post" runat="server">
<table cols="3" align="left">
<tr>
<td align="left" colSpan="3"><asp:label id="lblPageHeader"
runat="server" Font-Size="Large">Session
Maintenance</asp:label></THEAD></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:datagrid id="dgSessions"
runat="server" Font-Size="Small" AutoGenerateColumns="False"
AllowPaging="True"
PageSize="6" AllowSorting="True" BackColor="White"
Font-Names="Arial" HorizontalAlign="Left" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px" CellPadding="3"
GridLines="Vertical" ShowFooter="True">
<SelectedItemStyle Font-Size="Small" Font-Names="Arial"
Font-Bold="True" HorizontalAlign="Left" ForeColor="White"
BackColor="#008A8C"></SelectedItemStyle>
<EditItemStyle Font-Size="Small" Font-Names="Arial"
HorizontalAlign="Left" ForeColor="Black"
BackColor="Aquamarine"></EditItemStyle>
<AlternatingItemStyle Font-Size="Small" Font-Names="Arial"
HorizontalAlign="Left" BackColor="Gainsboro"></AlternatingItemStyle>
<ItemStyle Font-Size="Small" Font-Names="Arial"
HorizontalAlign="Left" ForeColor="Black"
BackColor="#EEEEEE"></ItemStyle>
<HeaderStyle Font-Size="Medium" Font-Names="Arial"
Font-Bold="True" HorizontalAlign="Left" ForeColor="White"
BackColor="#000084"></HeaderStyle>
<FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle>
<Columns>
<asp:ButtonColumn Text="Insert"
CommandName="Insert"></asp:ButtonColumn>
<asp:EditCommandColumn ButtonType="LinkButton"
UpdateText="Update" CancelText="Cancel"
EditText="Edit"></asp:EditCommandColumn>
<asp:ButtonColumn Text="Delete"
CommandName="Delete"></asp:ButtonColumn>
<asp:BoundColumn Visible="False" DataField="sessionid"
SortExpression="sessionid" HeaderText="Session ID"></asp:BoundColumn>
<asp:BoundColumn DataField="sessionname"
SortExpression="sessionname" HeaderText="Session
Name"></asp:BoundColumn>
<asp:BoundColumn DataField="begindate"
SortExpression="begindate" HeaderText="Begin Date"
DataFormatString="{0:MM-dd-yyyy}"></asp:BoundColumn>
<asp:BoundColumn DataField="enddate" SortExpression="enddate"
HeaderText="End Date"
DataFormatString="{0:MM-dd-yyyy}"></asp:BoundColumn>
</Columns>
<PagerStyle ForeColor="Black" BackColor="#999999"
Mode="NumericPages"></PagerStyle>
</asp:datagrid></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:label id="lblWhatsUp"
style="Z-INDEX: 101" runat="server" Font-Size="Medium"></asp:label></td>
</tr>
<tr>
<td align="left"><asp:label id="lblSessionName" style="Z-INDEX:
110" runat="server">Session Name:</asp:label></td>
<td align="left"><asp:label id="lblBeginDate" style="Z-INDEX: 111"
runat="server">Begin Date:</asp:label></td>
<td align="left"><asp:label id="lblEndDate" style="Z-INDEX: 113"
runat="server">End Date:</asp:label></td>
</tr>
<tr>
<td align="left"><asp:textbox id="txtSessionName" style="Z-INDEX:
102" runat="server"></asp:textbox></td>
<td align="left"><asp:textbox id="txtBeginDate" style="Z-INDEX:
103" runat="server"></asp:textbox></td>
<td align="left"><asp:textbox id="txtEndDate" style="Z-INDEX: 104"
runat="server"></asp:textbox></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:button id="btnDo"
runat="server"></asp:button></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:label id="lblSessionID"
style="Z-INDEX: 106" runat="server"
Visible="False"></asp:label><asp:label id="lblSQLWhere" style="Z-INDEX:
109" runat="server" Visible="False"></asp:label><asp:label
id="lblSQLSortCol" style="Z-INDEX: 107" runat="server"
Visible="False">sessionid</asp:label><asp:label id="lblSQLSortDir"
runat="server" Visible="False">ASC</asp:label></td>
</tr>
</table>
</form>
</body>
</HTML>
Followed by the code behind:

Public Class frmSessions
Inherits System.Web.UI.Page
Protected conString As New
SqlClient.SqlConnection("user=myuser;password=mypa ssword;server=myserver
;database=mydatabase")
Protected SQLStmt As String
Protected SQLSort As String
Protected SQLWhere As String

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()

End Sub
Protected WithEvents dgSessions As
System.Web.UI.WebControls.DataGrid
Protected WithEvents txtEndDate As System.Web.UI.WebControls.TextBox
Protected WithEvents lblWhatsUp As System.Web.UI.WebControls.Label
Protected WithEvents lblSessionID As System.Web.UI.WebControls.Label
Protected WithEvents lblSQLSortCol As
System.Web.UI.WebControls.Label
Protected WithEvents lblSQLSortDir As
System.Web.UI.WebControls.Label
Protected WithEvents lblSQLWhere As System.Web.UI.WebControls.Label
Protected WithEvents lblSessionName As
System.Web.UI.WebControls.Label
Protected WithEvents lblBeginDate As System.Web.UI.WebControls.Label
Protected WithEvents lblEndDate As System.Web.UI.WebControls.Label
Protected WithEvents txtBeginDate As
System.Web.UI.WebControls.TextBox
Protected WithEvents txtSessionName As
System.Web.UI.WebControls.TextBox
Protected WithEvents btnDo As System.Web.UI.WebControls.Button
Protected WithEvents lblPageHeader As
System.Web.UI.WebControls.Label

'NOTE: The following placeholder declaration is required by the Web
Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

SQLStmt = "SELECT sessionid, sessionname, begindate, enddate
FROM lfp_sessions"
SQLSort = " ORDER BY " & lblSQLSortCol.Text & " " &
lblSQLSortDir.Text
SQLWhere = ""

If Not Page.IsPostBack Then
BindData()
End If

'setup gui
GUI("Hide")

End Sub

#Region " Data Grid Events "

Private Sub dgSessions_ItemCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles
dgSessions.ItemCommand
'e.Item is the row of the table where the button was clicked.

Try
'choose button type
Select Case e.CommandName
Case Is = "Sort"
Case Is = "Select"
Case Is = "Insert"
GUI("Clear")
lblWhatsUp.Text = "Adding Item: "
LoadTextBoxes(e)
btnDo.Text = "Insert Record"
GUI("Show")
Case Is = "Edit"
Case Is = "Delete"
Case Is = "Page"
End Select
Catch Exc As Exception
'Process exception and return.
'Dim log As System.Diagnostics.EventLog = New
System.Diagnostics.EventLog
'log.Source = "My Application"
'log.WriteEntry(Exc.ToString())
'Console.WriteLine("Exception of type {0} occurred.",
exc.GetType().ToString())
Finally
End Try
End Sub

Private Sub dgSessions_DeleteCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles
dgSessions.DeleteCommand
GUI("Clear")
lblWhatsUp.Text = "Deleting Item: "
lblSessionID.Text = e.Item.Cells(3).Text
LoadTextBoxes(e)
btnDo.Text = "Delete Record"
GUI("Show")
End Sub

Private Sub dgSessions_EditCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles
dgSessions.EditCommand
GUI("Clear")
lblWhatsUp.Text = "Editing Item: "
lblSessionID.Text = e.Item.Cells(3).Text
LoadTextBoxes(e)
btnDo.Text = "Submit Changes"
GUI("Show")
End Sub

Private Sub dgSessions_PageIndexChanged(ByVal source As Object,
ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args)
Handles dgSessions.PageIndexChanged
GUI("Clear")
dgSessions.CurrentPageIndex = e.NewPageIndex
BindData()
End Sub

Private Sub dgSessions_SortCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridSortCommandEvent Args) Handles
dgSessions.SortCommand
If lblSQLSortCol.Text = e.SortExpression Then
Select Case lblSQLSortDir.Text
Case Is = "ASC"
lblSQLSortDir.Text = "DESC"
Case Is = "DESC"
lblSQLSortDir.Text = "ASC"
End Select
Else
lblSQLSortCol.Text = e.SortExpression
lblSQLSortDir.Text = "ASC"
End If
SQLSort = " ORDER BY " & lblSQLSortCol.Text & " " &
lblSQLSortDir.Text
BindData()
End Sub

#End Region

#Region " Data Handling "

Sub BindData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt &
SQLWhere & SQLSort, conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")
Dim dv As New DataView
dv = myDataSet.Tables("lfp_sessions").DefaultView
dgSessions.DataSource = dv
dgSessions.DataBind()
Catch Exc As System.OverflowException
Finally
End Try
End Sub

Sub DeleteData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt &
SQLWhere & SQLSort, conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")

myDataAdapter.DeleteCommand = New
SqlClient.SqlCommand("DELETE FROM lfp_sessions WHERE (sessionid =
@Original_sessionid)", conString)
myDataAdapter.DeleteCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@original_sess ionid",
System.Data.SqlDbType.Int, 4)).Value = lblSessionID.Text

myDataSet.Tables(0).AcceptChanges()
Dim myDataRow As DataRow = myDataSet.Tables(0).Rows(0)
myDataRow.Delete()
myDataAdapter.Update(myDataSet.Tables(0))

Catch Exc As System.OverflowException
Finally
End Try
End Sub

Sub EditData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt &
SQLWhere & SQLSort, conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")

myDataAdapter.UpdateCommand = New
SqlClient.SqlCommand("UPDATE lfp_sessions SET sessionname =
@sessionname, begindate = @begindate, enddate = @enddate WHERE
(sessionid = @Original_sessionid)", conString)
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@original_sess ionid",
System.Data.SqlDbType.Int, 4)).Value = lblSessionID.Text
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@sessionname",
System.Data.SqlDbType.VarChar, 50, "sessionname"))
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@begindate",
System.Data.SqlDbType.DateTime, 8, "begindate"))
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@enddate",
System.Data.SqlDbType.DateTime, 8, "enddate"))

myDataSet.Tables(0).AcceptChanges()
Dim myDataRow As DataRow = myDataSet.Tables(0).Rows(0)
myDataRow = FillRow(myDataRow)
myDataAdapter.Update(myDataSet.Tables(0))

Catch Exc As System.OverflowException
Finally
End Try
End Sub

Sub InsertData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt,
conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")

myDataAdapter.InsertCommand = New
SqlClient.SqlCommand("INSERT INTO lfp_sessions(sessionname, begindate,
enddate) VALUES (@sessionname, @begindate, @enddate)")

myDataAdapter.InsertCommand.Connection = conString
myDataAdapter.InsertCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@sessionname",
System.Data.SqlDbType.VarChar, 50, "sessionname"))
myDataAdapter.InsertCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@begindate",
System.Data.SqlDbType.DateTime, 8, "begindate"))
myDataAdapter.InsertCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@enddate",
System.Data.SqlDbType.DateTime, 8, "enddate"))

Dim myDataRow As DataRow = myDataSet.Tables(0).NewRow()
myDataRow = FillRow(myDataRow)
myDataSet.Tables(0).Rows.Add(myDataRow)
myDataAdapter.Update(myDataSet.Tables(0))

Catch Exc As System.OverflowException
Finally
End Try
End Sub

Function FillRow(ByVal dr As DataRow)
dr("sessionname") = txtSessionName.Text
dr("begindate") = txtBeginDate.Text
dr("enddate") = txtEndDate.Text
Return dr
End Function

#End Region

Private Sub btnDo_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnDo.Click

Try
Dim SQLTemp As String = SQLWhere
Select Case btnDo.Text
Case Is = "Insert Record"
SQLWhere = " WHERE sessionid = '" &
lblSessionID.Text & "'"
InsertData()
SQLWhere = SQLTemp
BindData()
Case Is = "Submit Changes"
SQLWhere = " WHERE sessionid = '" &
lblSessionID.Text & "'"
EditData()
SQLWhere = SQLTemp
BindData()
Case Is = "Delete Record"
SQLWhere = " WHERE sessionid = '" &
lblSessionID.Text & "'"
DeleteData()
SQLWhere = SQLTemp
If dgSessions.CurrentPageIndex >=
(dgSessions.PageCount - 1) Then
dgSessions.CurrentPageIndex = 0
BindData()
dgSessions.CurrentPageIndex =
(dgSessions.PageCount - 1)
End If
BindData()
End Select
Catch Exc As System.OverflowException

Finally
'handle GUI
GUI("Hide")
GUI("Clear")
End Try
End Sub

Private Sub GUI(ByVal strAction As String)
Try
Select Case strAction
Case Is = "Hide"
lblWhatsUp.Visible = False
lblSessionName.Visible = False
txtSessionName.Visible = False
txtBeginDate.Visible = False
lblBeginDate.Visible = False
txtEndDate.Visible = False
lblEndDate.Visible = False
btnDo.Visible = False
Case Is = "Show"
lblWhatsUp.Visible = True
lblSessionName.Visible = True
txtSessionName.Visible = True
lblBeginDate.Visible = True
txtBeginDate.Visible = True
lblEndDate.Visible = True
txtEndDate.Visible = True
btnDo.Visible = True
Case Is = "Clear"
lblWhatsUp.Text = ""
lblSessionID.Text = ""
txtSessionName.Text = ""
txtBeginDate.Text = ""
txtEndDate.Text = ""
btnDo.Text = ""
End Select
Catch Exc As System.OverflowException
Finally
End Try

End Sub

Private Sub LoadTextBoxes(ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs )

If e.Item.Cells(4).Text <> "&nbsp;" Then txtSessionName.Text =
e.Item.Cells(4).Text
If e.Item.Cells(5).Text <> "&nbsp;" Then txtBeginDate.Text =
e.Item.Cells(5).Text
If e.Item.Cells(6).Text <> "&nbsp;" Then txtEndDate.Text =
e.Item.Cells(6).Text

End Sub
End Class


Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #5
What does the source of the html page once its rendered look like? Something on it is telling your browser to go to another page on the site. Make sure your form is posting back to itself. Let me know what you find.

--Michael

"Steve Hoyer" <st********@hotmail.com> wrote in message news:%2****************@TK2MSFTNGP09.phx.gbl...
Unfortunatly, as is the way with these things, the code runs superbly
<grin> on my development machine. I am trying deploy it as my first
asp.net application and on the live server is the bombing.

I apologize for the length of this message, but if you ask for code, you
get code :)

Anyway, here is the HTML:

<%@ Page Language="vb" AutoEventWireup="false"
Codebehind="frmSessions.aspx.vb"
Inherits="LakeFrontParkAssisstant.frmSessions"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>frmSessions</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="Visual Basic .NET 7.1" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5"
name="vs_targetSchema">
</HEAD>
<body>
<A href="LFPAHome.htm">Go Home!</A>
<form id="Form1" method="post" runat="server">
<table cols="3" align="left">
<tr>
<td align="left" colSpan="3"><asp:label id="lblPageHeader"
runat="server" Font-Size="Large">Session
Maintenance</asp:label></THEAD></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:datagrid id="dgSessions"
runat="server" Font-Size="Small" AutoGenerateColumns="False"
AllowPaging="True"
PageSize="6" AllowSorting="True" BackColor="White"
Font-Names="Arial" HorizontalAlign="Left" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px" CellPadding="3"
GridLines="Vertical" ShowFooter="True">
<SelectedItemStyle Font-Size="Small" Font-Names="Arial"
Font-Bold="True" HorizontalAlign="Left" ForeColor="White"
BackColor="#008A8C"></SelectedItemStyle>
<EditItemStyle Font-Size="Small" Font-Names="Arial"
HorizontalAlign="Left" ForeColor="Black"
BackColor="Aquamarine"></EditItemStyle>
<AlternatingItemStyle Font-Size="Small" Font-Names="Arial"
HorizontalAlign="Left" BackColor="Gainsboro"></AlternatingItemStyle>
<ItemStyle Font-Size="Small" Font-Names="Arial"
HorizontalAlign="Left" ForeColor="Black"
BackColor="#EEEEEE"></ItemStyle>
<HeaderStyle Font-Size="Medium" Font-Names="Arial"
Font-Bold="True" HorizontalAlign="Left" ForeColor="White"
BackColor="#000084"></HeaderStyle>
<FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle>
<Columns>
<asp:ButtonColumn Text="Insert"
CommandName="Insert"></asp:ButtonColumn>
<asp:EditCommandColumn ButtonType="LinkButton"
UpdateText="Update" CancelText="Cancel"
EditText="Edit"></asp:EditCommandColumn>
<asp:ButtonColumn Text="Delete"
CommandName="Delete"></asp:ButtonColumn>
<asp:BoundColumn Visible="False" DataField="sessionid"
SortExpression="sessionid" HeaderText="Session ID"></asp:BoundColumn>
<asp:BoundColumn DataField="sessionname"
SortExpression="sessionname" HeaderText="Session
Name"></asp:BoundColumn>
<asp:BoundColumn DataField="begindate"
SortExpression="begindate" HeaderText="Begin Date"
DataFormatString="{0:MM-dd-yyyy}"></asp:BoundColumn>
<asp:BoundColumn DataField="enddate" SortExpression="enddate"
HeaderText="End Date"
DataFormatString="{0:MM-dd-yyyy}"></asp:BoundColumn>
</Columns>
<PagerStyle ForeColor="Black" BackColor="#999999"
Mode="NumericPages"></PagerStyle>
</asp:datagrid></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:label id="lblWhatsUp"
style="Z-INDEX: 101" runat="server" Font-Size="Medium"></asp:label></td>
</tr>
<tr>
<td align="left"><asp:label id="lblSessionName" style="Z-INDEX:
110" runat="server">Session Name:</asp:label></td>
<td align="left"><asp:label id="lblBeginDate" style="Z-INDEX: 111"
runat="server">Begin Date:</asp:label></td>
<td align="left"><asp:label id="lblEndDate" style="Z-INDEX: 113"
runat="server">End Date:</asp:label></td>
</tr>
<tr>
<td align="left"><asp:textbox id="txtSessionName" style="Z-INDEX:
102" runat="server"></asp:textbox></td>
<td align="left"><asp:textbox id="txtBeginDate" style="Z-INDEX:
103" runat="server"></asp:textbox></td>
<td align="left"><asp:textbox id="txtEndDate" style="Z-INDEX: 104"
runat="server"></asp:textbox></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:button id="btnDo"
runat="server"></asp:button></td>
</tr>
<tr>
<td align="left" colSpan="3"><asp:label id="lblSessionID"
style="Z-INDEX: 106" runat="server"
Visible="False"></asp:label><asp:label id="lblSQLWhere" style="Z-INDEX:
109" runat="server" Visible="False"></asp:label><asp:label
id="lblSQLSortCol" style="Z-INDEX: 107" runat="server"
Visible="False">sessionid</asp:label><asp:label id="lblSQLSortDir"
runat="server" Visible="False">ASC</asp:label></td>
</tr>
</table>
</form>
</body>
</HTML>


Followed by the code behind:

Public Class frmSessions
Inherits System.Web.UI.Page
Protected conString As New
SqlClient.SqlConnection("user=myuser;password=mypa ssword;server=myserver
;database=mydatabase")
Protected SQLStmt As String
Protected SQLSort As String
Protected SQLWhere As String

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub
InitializeComponent()

End Sub
Protected WithEvents dgSessions As
System.Web.UI.WebControls.DataGrid
Protected WithEvents txtEndDate As System.Web.UI.WebControls.TextBox
Protected WithEvents lblWhatsUp As System.Web.UI.WebControls.Label
Protected WithEvents lblSessionID As System.Web.UI.WebControls.Label
Protected WithEvents lblSQLSortCol As
System.Web.UI.WebControls.Label
Protected WithEvents lblSQLSortDir As
System.Web.UI.WebControls.Label
Protected WithEvents lblSQLWhere As System.Web.UI.WebControls.Label
Protected WithEvents lblSessionName As
System.Web.UI.WebControls.Label
Protected WithEvents lblBeginDate As System.Web.UI.WebControls.Label
Protected WithEvents lblEndDate As System.Web.UI.WebControls.Label
Protected WithEvents txtBeginDate As
System.Web.UI.WebControls.TextBox
Protected WithEvents txtSessionName As
System.Web.UI.WebControls.TextBox
Protected WithEvents btnDo As System.Web.UI.WebControls.Button
Protected WithEvents lblPageHeader As
System.Web.UI.WebControls.Label

'NOTE: The following placeholder declaration is required by the Web
Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub

#End Region

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

SQLStmt = "SELECT sessionid, sessionname, begindate, enddate
FROM lfp_sessions"
SQLSort = " ORDER BY " & lblSQLSortCol.Text & " " &
lblSQLSortDir.Text
SQLWhere = ""

If Not Page.IsPostBack Then
BindData()
End If

'setup gui
GUI("Hide")

End Sub

#Region " Data Grid Events "

Private Sub dgSessions_ItemCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles
dgSessions.ItemCommand
'e.Item is the row of the table where the button was clicked.

Try
'choose button type
Select Case e.CommandName
Case Is = "Sort"
Case Is = "Select"
Case Is = "Insert"
GUI("Clear")
lblWhatsUp.Text = "Adding Item: "
LoadTextBoxes(e)
btnDo.Text = "Insert Record"
GUI("Show")
Case Is = "Edit"
Case Is = "Delete"
Case Is = "Page"
End Select
Catch Exc As Exception
'Process exception and return.
'Dim log As System.Diagnostics.EventLog = New
System.Diagnostics.EventLog
'log.Source = "My Application"
'log.WriteEntry(Exc.ToString())
'Console.WriteLine("Exception of type {0} occurred.",
exc.GetType().ToString())
Finally
End Try
End Sub

Private Sub dgSessions_DeleteCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles
dgSessions.DeleteCommand
GUI("Clear")
lblWhatsUp.Text = "Deleting Item: "
lblSessionID.Text = e.Item.Cells(3).Text
LoadTextBoxes(e)
btnDo.Text = "Delete Record"
GUI("Show")
End Sub

Private Sub dgSessions_EditCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridCommandEventArgs ) Handles
dgSessions.EditCommand
GUI("Clear")
lblWhatsUp.Text = "Editing Item: "
lblSessionID.Text = e.Item.Cells(3).Text
LoadTextBoxes(e)
btnDo.Text = "Submit Changes"
GUI("Show")
End Sub

Private Sub dgSessions_PageIndexChanged(ByVal source As Object,
ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args)
Handles dgSessions.PageIndexChanged
GUI("Clear")
dgSessions.CurrentPageIndex = e.NewPageIndex
BindData()
End Sub

Private Sub dgSessions_SortCommand(ByVal source As Object, ByVal e
As System.Web.UI.WebControls.DataGridSortCommandEvent Args) Handles
dgSessions.SortCommand
If lblSQLSortCol.Text = e.SortExpression Then
Select Case lblSQLSortDir.Text
Case Is = "ASC"
lblSQLSortDir.Text = "DESC"
Case Is = "DESC"
lblSQLSortDir.Text = "ASC"
End Select
Else
lblSQLSortCol.Text = e.SortExpression
lblSQLSortDir.Text = "ASC"
End If
SQLSort = " ORDER BY " & lblSQLSortCol.Text & " " &
lblSQLSortDir.Text
BindData()
End Sub

#End Region

#Region " Data Handling "

Sub BindData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt &
SQLWhere & SQLSort, conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")
Dim dv As New DataView
dv = myDataSet.Tables("lfp_sessions").DefaultView
dgSessions.DataSource = dv
dgSessions.DataBind()
Catch Exc As System.OverflowException
Finally
End Try
End Sub

Sub DeleteData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt &
SQLWhere & SQLSort, conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")

myDataAdapter.DeleteCommand = New
SqlClient.SqlCommand("DELETE FROM lfp_sessions WHERE (sessionid =
@Original_sessionid)", conString)
myDataAdapter.DeleteCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@original_sess ionid",
System.Data.SqlDbType.Int, 4)).Value = lblSessionID.Text

myDataSet.Tables(0).AcceptChanges()
Dim myDataRow As DataRow = myDataSet.Tables(0).Rows(0)
myDataRow.Delete()
myDataAdapter.Update(myDataSet.Tables(0))

Catch Exc As System.OverflowException
Finally
End Try
End Sub

Sub EditData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt &
SQLWhere & SQLSort, conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")

myDataAdapter.UpdateCommand = New
SqlClient.SqlCommand("UPDATE lfp_sessions SET sessionname =
@sessionname, begindate = @begindate, enddate = @enddate WHERE
(sessionid = @Original_sessionid)", conString)
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@original_sess ionid",
System.Data.SqlDbType.Int, 4)).Value = lblSessionID.Text
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@sessionname",
System.Data.SqlDbType.VarChar, 50, "sessionname"))
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@begindate",
System.Data.SqlDbType.DateTime, 8, "begindate"))
myDataAdapter.UpdateCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@enddate",
System.Data.SqlDbType.DateTime, 8, "enddate"))

myDataSet.Tables(0).AcceptChanges()
Dim myDataRow As DataRow = myDataSet.Tables(0).Rows(0)
myDataRow = FillRow(myDataRow)
myDataAdapter.Update(myDataSet.Tables(0))

Catch Exc As System.OverflowException
Finally
End Try
End Sub

Sub InsertData()
Dim myDataAdapter As SqlClient.SqlDataAdapter
Dim myDataSet As New DataSet

Try
myDataAdapter = New SqlClient.SqlDataAdapter(SQLStmt,
conString)
myDataAdapter.Fill(myDataSet, "lfp_sessions")

myDataAdapter.InsertCommand = New
SqlClient.SqlCommand("INSERT INTO lfp_sessions(sessionname, begindate,
enddate) VALUES (@sessionname, @begindate, @enddate)")

myDataAdapter.InsertCommand.Connection = conString
myDataAdapter.InsertCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@sessionname",
System.Data.SqlDbType.VarChar, 50, "sessionname"))
myDataAdapter.InsertCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@begindate",
System.Data.SqlDbType.DateTime, 8, "begindate"))
myDataAdapter.InsertCommand.Parameters.Add(New
System.Data.SqlClient.SqlParameter("@enddate",
System.Data.SqlDbType.DateTime, 8, "enddate"))

Dim myDataRow As DataRow = myDataSet.Tables(0).NewRow()
myDataRow = FillRow(myDataRow)
myDataSet.Tables(0).Rows.Add(myDataRow)
myDataAdapter.Update(myDataSet.Tables(0))

Catch Exc As System.OverflowException
Finally
End Try
End Sub

Function FillRow(ByVal dr As DataRow)
dr("sessionname") = txtSessionName.Text
dr("begindate") = txtBeginDate.Text
dr("enddate") = txtEndDate.Text
Return dr
End Function

#End Region

Private Sub btnDo_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles btnDo.Click

Try
Dim SQLTemp As String = SQLWhere
Select Case btnDo.Text
Case Is = "Insert Record"
SQLWhere = " WHERE sessionid = '" &
lblSessionID.Text & "'"
InsertData()
SQLWhere = SQLTemp
BindData()
Case Is = "Submit Changes"
SQLWhere = " WHERE sessionid = '" &
lblSessionID.Text & "'"
EditData()
SQLWhere = SQLTemp
BindData()
Case Is = "Delete Record"
SQLWhere = " WHERE sessionid = '" &
lblSessionID.Text & "'"
DeleteData()
SQLWhere = SQLTemp
If dgSessions.CurrentPageIndex >=
(dgSessions.PageCount - 1) Then
dgSessions.CurrentPageIndex = 0
BindData()
dgSessions.CurrentPageIndex =
(dgSessions.PageCount - 1)
End If
BindData()
End Select
Catch Exc As System.OverflowException

Finally
'handle GUI
GUI("Hide")
GUI("Clear")
End Try
End Sub

Private Sub GUI(ByVal strAction As String)
Try
Select Case strAction
Case Is = "Hide"
lblWhatsUp.Visible = False
lblSessionName.Visible = False
txtSessionName.Visible = False
txtBeginDate.Visible = False
lblBeginDate.Visible = False
txtEndDate.Visible = False
lblEndDate.Visible = False
btnDo.Visible = False
Case Is = "Show"
lblWhatsUp.Visible = True
lblSessionName.Visible = True
txtSessionName.Visible = True
lblBeginDate.Visible = True
txtBeginDate.Visible = True
lblEndDate.Visible = True
txtEndDate.Visible = True
btnDo.Visible = True
Case Is = "Clear"
lblWhatsUp.Text = ""
lblSessionID.Text = ""
txtSessionName.Text = ""
txtBeginDate.Text = ""
txtEndDate.Text = ""
btnDo.Text = ""
End Select
Catch Exc As System.OverflowException
Finally
End Try

End Sub

Private Sub LoadTextBoxes(ByVal e As
System.Web.UI.WebControls.DataGridCommandEventArgs )

If e.Item.Cells(4).Text <> "&nbsp;" Then txtSessionName.Text =
e.Item.Cells(4).Text
If e.Item.Cells(5).Text <> "&nbsp;" Then txtBeginDate.Text =
e.Item.Cells(5).Text
If e.Item.Cells(6).Text <> "&nbsp;" Then txtEndDate.Text =
e.Item.Cells(6).Text

End Sub
End Class




Steve Hoyer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #6
Would it have anything to do with have the SmartNavigation enabled on
the form?

Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #7
Could very well be, turn it off and see for yourself. I do hear smartnavigation can be buggy though, and only works on IE.

"Steve Hoyer" <st********@hotmail.com> wrote in message news:us**************@TK2MSFTNGP11.phx.gbl...
Would it have anything to do with have the SmartNavigation enabled on
the form?

Steve Hoyer


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #8
Likely caused by the ~ character. AFAIK this is a server side notation that
is not handled by IIS itself...

Note also that you have also some other elements that are not found...

Patrice

"Steve Hoyer" <st********@hotmail.com> a écrit dans le message de
news:OF****************@TK2MSFTNGP12.phx.gbl...
Here seems to be the pertinent section of the log file. Note the
<Rejected-By-UrlScan> at the bottom.

192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/LFPSHome.htm - 404
192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/LFPSHome.html - 404
192.168.1.211 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.htm - 404
192.168.1.211 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.js - 404
192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/LFPAHome.htm - 200
192.168.1.102 - 192.168.1.211 80 GET /LFPAssisstant/frmRegister.aspx -
200
192.168.1.102 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.htm - 404
192.168.1.102 - 192.168.1.211 80 GET
/aspnet_client/system_web/1_1_4322/SmartNav.js - 404
192.168.1.102 - 192.168.1.211 80 GET /<Rejected-By-UrlScan>
~/LFPAssisstant/frmRegister.aspx 404
Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #9
I apologize - smart navigation is not enabled on this particular form
(though it is on others, and as this is a purely internal application -
other browsers are not a problem - but good to keep in mind)

The ~ character does not show up in my code anywhere - only in the log.
As for the other 404's, I just did another test to see what my log had
to say if I made sure of my routine. So no 404's this time, but same
problem.

It said:

2004-05-26 14:08:01 192.168.1.211 - 192.168.1.211 80 GET
/LFPAssisstant/LFPAHome.htm - 304
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CL R+1.0.3705;+.N
ET+CLR+1.1.4322)

2004-05-26 14:08:09 192.168.1.211 - 192.168.1.211 80 GET
/LFPAssisstant/frmSessions.aspx - 200
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CL R+1.0.3705;+.N
ET+CLR+1.1.4322)

2004-05-26 14:08:15 192.168.1.211 - 192.168.1.211 80 GET
/<Rejected-By-UrlScan> ~/LFPAssisstant/frmSessions.aspx 404
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CL R+1.0.3705;+.N
ET+CLR+1.1.4322)

btw - Patrice, what does AFAIK stand for?

Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #10
AFAIK is for "As Far As I Know".

Ok, it looks like anyway that UrlSCan comes in play to reject this request.
I would try then (assuming this is not too risky) to disable UrlScan to see
what happens.

If it works, it's very likely some UrlScan setting that doesn't like this
request (POST verb unintentionaly disabled ? but probably something less
obvious)

Patrice
"Steve Hoyer" <st********@hotmail.com> a écrit dans le message de
news:uG**************@TK2MSFTNGP12.phx.gbl...
I apologize - smart navigation is not enabled on this particular form
(though it is on others, and as this is a purely internal application -
other browsers are not a problem - but good to keep in mind)

The ~ character does not show up in my code anywhere - only in the log.
As for the other 404's, I just did another test to see what my log had
to say if I made sure of my routine. So no 404's this time, but same
problem.

It said:

2004-05-26 14:08:01 192.168.1.211 - 192.168.1.211 80 GET
/LFPAssisstant/LFPAHome.htm - 304
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CL R+1.0.3705;+.N
ET+CLR+1.1.4322)

2004-05-26 14:08:09 192.168.1.211 - 192.168.1.211 80 GET
/LFPAssisstant/frmSessions.aspx - 200
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CL R+1.0.3705;+.N
ET+CLR+1.1.4322)

2004-05-26 14:08:15 192.168.1.211 - 192.168.1.211 80 GET
/<Rejected-By-UrlScan> ~/LFPAssisstant/frmSessions.aspx 404
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0;+.NET+CL R+1.0.3705;+.N
ET+CLR+1.1.4322)

btw - Patrice, what does AFAIK stand for?

Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #11
I tried uninstalling and reinstalling the IIS Lockdown tool, making sure
I had asp selected as my template. This didn't work, but did produce a
different error of:

Invalid PInvoke metadata format

After trying other things that didn't work (removing and rereferencing
system.data, etc), I found that I did have the .net framework installed
twice on my live webserver (versions 1.0 and 1.1). I uninstalled both,
and reinstalled 1.1, and voila, problem solved.

Now, onto getting crystal reports working :(

Thanks for all the responses. They were greatly appreciated.

Steve Hoyer
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Help Needed | last post by:
There is an ASP page in my site which sometimes gives file not found error. This page which is suppossedly missing exists on the server and available most of the time. But sometimes out of the...
5
by: David Webb | last post by:
The problem started when the Working Folder for a project was somehow set to the folder of another project. I set the correct working folder in VSS and deleted the .vbproj files that had been...
0
by: karunakar | last post by:
Hi All I am not able to read the class name I want read the particular class name string path = System.Configuration.ConfigurationSettings.AppSettings; string className = path + ".User";...
3
by: Michael Bøcker-Larsen | last post by:
Hi I'v been stuck on this problem for ages now. I have found that I'm not the only one with this problem, by looking through the different newsgroups. Hope you can help me! I know there is a...
6
by: Paul | last post by:
Hi there, When adding a "File Field" HTML control to an aspx page to facilitate file uploading, the following occurs: 1. You select a file that is larger than the allowed size limit. 2. Once...
15
by: Nathan | last post by:
I have an aspx page with a data grid, some textboxes, and an update button. This page also has one html input element with type=file (not inside the data grid and runat=server). The update...
5
by: Neil Rossi | last post by:
I have an issue with a particular ASP page on two web servers. Let's call these servers Dev1 and Beta1. Both Servers are running IIS 5, Windows 2000 SP4 with "almost" all of the latest patches. ...
4
by: UJ | last post by:
I'm trying to limit the size of a file the user can upload. I want it so that if the file is larger than 100MB, I tell them it needs to be smaller. I put code in when they 'upload' the file to...
13
by: DH | last post by:
Hi, I'm trying to strip the html and other useless junk from a html page.. Id like to create something like an automated text editor, where it takes the keywords from a txt file and removes them...
2
by: John Bailey | last post by:
I have checked around and could not find anything here that exactly matches my issue, which is odd since I have found numerous posts on this in other news groups. I have a ASP .Net 2.0 site that...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.