Search results for query: *

Hi Folks. I recently got a new laptop running windows 7 64 bit. I ported over my VB apps, which use OLEDB to connect to an access database. Originally this was a 2003 db and used Jet4, but I have upgraded it to 2007 and now use the ACE 12 driver. I have modified the project to use x86 CPU...

Great stuff - works a treat. Not quite got it straight in my mind as to why this works, but probably due to the fact that I'm trying to add the same control to more than one tabpage. Thanks again for your time and effort in solving this! Paul

Thanks for taking the time to look at this. Interesting - yes, the text from the database is being assigned to the txttab textbox - I've used 'Debug.Print(txtTab.Text)' to verify this. My declarations in the sub are: Dim rowDets As DataRow Dim tpDetails As New TabPage...

Hi Folks, I am looking at using a TabControl to display records from a database. The basic gist is that I pull a selection of records out of a database and add a tabpage to the tabcontrol for each one (code shown below). One field is used for the tabpage.text and the other is to be displayed in...

...WithEvents comUpdDetails As New OleDbCommand() Public WithEvents comDelDetails As New OleDbCommand() comSelDetails.CommandText = "Select * from tblDetails" comSelDetails.Connection = cnDetails daDetails.UpdateCommand = comUpdDetails daDetails.DeleteCommand = comDelDetails...

Thanks for the reply. I've just got a standard installation of Outlook 2003 at the moment,which was newly configured - it's on a new lappy - when I set up exchange. Do you know if there are particular patches that I should apply?

Hi Folks, I've just set up outlook 2003 to use an exchange server - when I run send/Receive I am getting an 0x80004005 'The Operation Failed' error. My email is updating correctly - does anyone have any ideas as to why I am getting this error? Thanks in advance Paul

I have a question regarding changes and AcceptChanges in ADO.NET. The following code snippet does a select on a table - if the record is present the record is updated - if it is not present a new one is added. The code does work, but I'd like to tidy it up so that I don't have to, in effect...

Thanks for the reply. I am not setting the connection to nothing, as I want to reuse it for further calls to retrieve data. I have a single function which gets gets data from the database (commands and connections are set up beforehand and passed as parameters): Function...

I am converting a Vb.net program to use ADO.NET instead of ADO - part of the program iterates through a number of customer and customer order type database records and populates the same dataset with the appropriate records. It processes them and then clears out the orders (but leaves the...

Hi Folks, I want to add a child datarow to an existing datarow array - is this possible? Basically I am looping through one datarow, using getchildrows to get each child and I want to return a datarow array of all the children. It is the line 'rowChildren(shChildCnt) = rowChild' that I am...

Hi Folks, I would like to add a datatable to my dataset which has the same 'schema' as an Access table without having to select any records - is this possible? I am using ADO.NET.... Thanks Paul

Hi folks. I've been attempting to pass a wildcard in a dataset selection string and I get an error saying that "the string pattern Smith%s Bar is invalid". I've seen examples where the % is at the beginning and end but not in the middle. Please could someone advise - it must be a typical...

Thanks for the reply. I can use load to load a report from a seperate file into the crystal report object and that works fine. I can't work out how to use a strongly-bound crystal report in vb.net. I can add it to the project but am not sure how to make reference to it. Paul

I am migrating VB6 apps to .NET. I want to add a new (strongly typed) crystal report to my project - I obtained a copy of Brian Bischoff's Excerpts for crystal and .NET, but have run into a problem before getting past page 9 which is about viewing your first noddy report! I have added a crystal...

I am new to .NET and have a problem with VB.NET garbage collection. I have declared a form in a module as public, and call it from the main program form. However, once I close it (.close), it is 'garbaged collected' and seems to lose its declaration, and therefore my app errors when I try to...

I am using ADO and MS Access. Curiously enough, the problem has appeared to gone away. Perhaps rebooting has cured something. All seems a bit strange to me..

I am migrating an application from VB6 to VB.NET. I am using ADO initially - I'd like to get the program running under ADO before upgrading to ADO.NET. I'm nearly there - the finalish problem is that I get a "Too Many Open Tables" message when the application is running, where I didn't in VB6...

The problem is that VB.NET uses double_Click and the VB6 listviews use dbl_click. Just had to cut and paste code from the old dbl_click to the new double-click event.

I am upgrading a project from VB6 to vb.NET - I am replacing the old VB6 listviews with .NET equivalents. All is going according to plan so far apart from the fact that the click and double click (_Click and _DblClick) events of my listview do not seem to be firing - I've added a breakpoint to...