Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. NatHunter

    VB.NET 2010 Windows 7 and Access Pauses

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

    TabControl and dynamically adding tabpages

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

    TabControl and dynamically adding tabpages

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

    TabControl and dynamically adding tabpages

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

    TableAdapters and DataAdapters

    Hi Folks. I have some questions regarding tableadapters an dataadapters. Up until now, I have been using oleDbDataAdapters as shown below. This is before tableadapters were available. I have tried to repeat the code using a tableadapter - created by using the 'add datasource' option in...
  6. NatHunter

    Outlook & Exchange: 0x80004005 Error on outlook Client

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

    Outlook & Exchange: 0x80004005 Error on outlook Client

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

    Changes to row and AcceptChanges...

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

    Cannot Open any more databases

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

    Cannot Open any more databases

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

    Add a child datarow to an existing datarow array

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

    Inserting a DataTable with 'schema' based on an existing Access table

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

    WildCard using Dataset Selection

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

    Crystal Reports Viewer and ReportDocument component

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

    Crystal Reports Viewer and ReportDocument component

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

    Garbage Collection

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

    "Too Many Open Tables" using ADO in VB.NET

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

    "Too Many Open Tables" using ADO in VB.NET

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

    Listview and mouse click events

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

    Listview and mouse click events

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

Part and Inventory Search

Back
Top