Search results for query: *

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...

thanks for your reply, a point of clarification we finished up importing all the forms into the ADP front end due to it hanging on convert proces after tables and queries had come across. I can see the master child link fields and they are set up correctly however on this particular form it...

Access forms using the Wizards is heaps easier than VB, however the ADP environment has a big impact on access form construction because of the SQL based procedures. I am documenting conversion issues on a separate thread. Large application 400 forms , 200 reports , 1600 queries, all developed...

Another difference to be overcome b/t Access & ADP. We use extensive sub forms ( hundreds) all linked by indexed fields on the parent/child options on the sub form. It appears this doesnt work in ADP and you have to specify you data on the sub form input parameters. I am happy to be corrected????/

Another good site to explain the correct syntax for DateDiff etc in SQL note that the Access XP on line help is incorrect eg you need to use "hour" not "h" http://www.databasejournal.com/features/mssql/article.php/10894_2216011_2

BTW the best most useful tip I've found and should be added to Hall of Fame is When the stored procedure is used as the record source of a Form the parameters can be added in the Parameter property under the data tab. Use the format like so...