Recent content by Silvertri

Hello@All I am using ASP.NET Web matrix I linking to an SQL database. On my page I have a Mxdatagrid and a dropdwonlist. Once the Item in the drop dwon box is selected I want the mxdatagrid to filter the records by the selected item from the drop down box. 1. The SQLDataSourceControl is...

Hello@All I am using ASP.NET Web matrix I am linking to an SQL database. On my page I have a Mxdatagrid and a dropdwonlist. Once the Item in the drop dwon box is selected I want the mxdatagrid to filter the records by the selected item from the drop down box. 1. The SQLDataSourceControl is...

I looked at the artical and think that Response.Redirect seems to be the solution? User frindenly is our main cosiderations. Sub FillForm(xcurr As Integer) If(xcurr>0)Then Dim icurrent As Integer Dim zstrSQL As String icurrent=xcurr-1...

I am happy to give you the two forms involved with access.mdb backend if thats easiest, I presume the problem is there regardless of backend type This is the current state of play..... in summary Our access application is extensively based on forms that are linked from the main form by a key...

When the tool converts the Access form it creates .aspx file no .vb class. We view and edit the code using web matrix. Your posted code ------------------------------------------------------------ Sub BtnRequestAssistance_Click(sender As object,e As System.EventArgs)...

Yes we have form of this name and it opens directly without problem. Also another form frmParametersMenu which opens from our main form OK with the following code but without the IncidentName link (not required for this area of application) Sub BntParameters_Click(sender As object,e As...

In a word no it simply comes with page cannot be displayed invaild syntax

When viewed in web matrix the vb code appears thru the code tab and ditto for the html code there is no separate vb file created. For clarification we have two fields incidentnamealpha (text) and incidentname (integer) when we converted to a SQL backend we implemented incidentname for...

The code compilies correctly but does bot excute Sub Button1_Click(sender As Object, e As EventArgs) Response.Redirect("frmOperationsOfficer.aspx?IncidentNameAlpha="& "IName") End Sub Private Sub Page_Load(sender As object, e As System.EventArgs) Dim...

Yes we are converting to ASP.Net using VB.Net However we are using a tool from www.microtools.us which basically does the form conversion , we are then left with the reconnection between forms and subsequently things like after update queries that need to be reinstated once they are converted...

We are converting an Access based App to .Net with little or no VB knowledge . The following is an access connection string we use extensively to link to forms based on a field value on main form. Can anybody kindly provide the equivalent. I presume you use response.redirect but am unsure of...

G'day James, Thanks again, 110 down 300 approx to go!!! Unfortunately you'll probably be seeing more posts from me over the next fortnight or so...Regards Ken BTW if you want to have a look at what we have done in Access our Web Site is www.traveltech.ws we are just a small family business...

G'day James, thanks for the assistance, I would never have got the syntax right on this one!!!

same situation as previous post, this one is an update query, I have done all the obvious changes however getting syntax error no experience with real SQL queries only Access TIA Silvertri UPDATE (tblMainDetails INNER JOIN tblParamsMembers ON tblMainDetails.IncidentNameAlpha =...

We've used upsize to get our back end up in SQL including queries (adp project option) (front end going to .Net via Microtools Access.Net convertor) however many didnt come across and now working through issues via copy paste fix Problem with this code any suggestions gives incorrect syntax...