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

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

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

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

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

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

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

I am a reasonable VB6 programmer - I'm upgrading a VB6 project to .NET. The project uses ADO. When running the migration utility, the resulting project includes a reference to ADODB.DLL, but I'm sure I've seen somewhere (in my dreams, perhaps) a reference to a .NET ADO namespace for 'old' ADO...

Hi Folks, I've developed a VB app which I'm attempting to distribute using the Package and Deployment Wizard. The app uses the calendar control and ADO for data access to an access Db. When running the setup wizard, I get a message along the lines of 'MSDART.DLL file not found'. If I click...

I currently have several Access 97 Dbs and am about to be upgraded to Access 2002. Does Access 2002 use the Jet 4 engine and can I use the same ADO connection routines to connect to it as I currently use for Access 2000? If not, how would I connect to an Access 2002 Db using ADO through VB6...

Folks, I want to select a cell and then select down and then right from this cell. I've got the down bit using xldown, but can't get the xlright bit working: Range(ActiveCell, Selection.Cells.End(xlDown)).Select Range(ActiveCell, Selection.Cells.xlRight).Select Thanks

Is it possible to use the excel undo functionality from VBA code? If so, how is it done?

Hello Folks, This seems to be a common problem, but I can't find a thread which provides an answer for my situation. I have a program which uses a single procedure to open a recordset: rs.Open sSql, cnDb, adOpenStatic, adLockOptimistic (sSQL is a sql variable). The database may be a Jet...

Folks, I have a simple DOS batch file with a DTSRUN command and the appropriate switches. The DTSRUN command works. I have another command following DTSRUN, but it never runs - it's as if the DTSRUN command never returns to the calling batch process. Am I missing something? Cheers for any...