ViRiPuFF

Hi I've written this code (that works) to inserts registration details into an Access 2010 DB from an aspx registration page. How do I check for duplicates Email before inserting a new record into the DB Dim strConn As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\InetPub\WWWRoot\BushHouseGibraltar\Bush.accdb;Persist Security Info=False;" Dim MySQL As String = …

Hi Can someone please direct me to a tutorial relating to downloading files from an aspx Page. Thanks ViRiPuFF

Hi I need to insert some data from Text boxes in an aspx page into an Access DB but I keep getting a Data type mismatch in criteria expression error. The problem is the Double which I think I have converted correctly. All the other fields are OK as strings …

Hi I need to send an Email from an aspx page I've set up my SMTP server to accept sending Email from this machine granting connection and relay to my machines IP address In this code I'm trying to send to myself I get no errors but it does not …

I am using the following code to retrieve the last entered value from a table and insert it into a textbox called rf. The code below works but the DB remains open until I restart my computer. [code] Sub Page_Load() If Request.QueryString("VesselName") Is Nothing Then VesselName.Text = "Blank Name" 'some …

Hi I have just uploaded an Access DB and an .aspx page that writes to the DB. It works fine locally ie IIS. The problem is that when on the host the db does not get written to. I think its to do with the Source to the DB on …

Hi I have a site with 2 pages. The first page consists of a set of input fields where the data input by the users will end up in a db when the user clicks the submitt button, creating a new record. As well as this on click the users …

Hi I'm using MS Visual Basic 2005 Express Edition and need to open an Excel File. I'm using the following code [code] Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim xlTemp As Excel.Application xlTemp = New Excel.Application xlTemp.Workbooks.Open("C:\Documents and Settings\TAP\Desktop\Post\Test.xls") End Sub …

Hi I am trying to run the code below and get Exception From Hresult 0x800A0046 (CTL_E_PermissionDenied) error only on Button 2. Button 1 does what it is supposed to ie remove all files found in the folders that are older than today. Button 2 should remove all files regardless but …

Hi I am using Visual Basic Developer 2005 I have this simple code that will delete all files created before today in the specified folders. The code works fine but I get an exception problem when the fso object deletes the files ie at fso.DeleteFile(file) inside the second For loop. …

Hi I have the following code which generates an error 'Data Type mismatch in criteria expression' The purpose of the code is to write a value to a database at a specific row. [CODE] Dim IntSid As String Dim Sid As String Dim I As Integer IntSid = Me.TTIn.Text Sid …

Hi I am from Gibraltar and I hold a BSc in Computer Science. I have experience in Java and some C++. I want to start training myself with VB .NET and hence my joining this community. ViRiPuff