Search results for query: *

Hello all, I have a bound datagridview where I hide a sequence column when I am loading the grid. Works great. I also have a sort method that re-sorts the grid when the user has entered a new row (sorted by date). In that method, I issue the dgvRegister.Columns("Seq").Visible = False command...

My Application display's a login screen that takes a user's Oracle ID and password. It validates that the database can be opened with that ID, then proceeds into the app. When the password has expired, I trap the Oracle 28001 error message and prompt the user for a new password, but I can't...

Thanks for the "head thump", never even thought about that one. Remind's me of the old saying - couldn't see the forest for the tree's.

Question about the delete functions in a dataview. I am looping through a dataview to validate parent/child relationships. When the parent is not found, I copy the row to a new error table, then delete the row from the dataview. For Each drv As DataRowView In dvLocMstr If … "invalid" then...

LKBrwnDBA, Thanks for the reply. Using a load utility is my fallback option but the Oracle External file is a really nice feature. I can simply move the new file to the server (taking all the time I need) and then just point the table to new file. The swap is instant so there is no user outage...

I have to move a large amount of data (6.8 million records) from an Oracle (Unix server) database to a DB2 (Unix server) database. The current process utilizes a DB2 Connect PL\SQL routine to select from\insert into loop to load the records, but it takes days. We have some performance tuning we...

You need to tell the Connection that it has headers by using the HDR-YES text. Also notice the IMEX at the end - That forces Excel to treat everything as text. Since Excel only scans the first 8 rows to determine the column format, if you have numbers in the first 8 rows, then text later on, it...

Reading Excel cell by cell is extremly slow. have you thought about reading the spreadsheets into datatables, then comparing with the results into a different datatable that you can then write to a spreadsheet? I am currently working on a project reading in multiple spreadsheets at a time and...

Thanks for the reply, It opens every one of the debug windows available. If you actually start debuging a program, than go to the editor and open the Debug\Windows tab, there are a lot more window options available than when you are in edit mode. I get evry one of those windows open...

Well this is a new one to me... I've been working on my desktop application for 2 months now and all of a sudden, when I run debug, I get all kinds of pop-up windows. I have no idea what I did to make this happen. I was playing around with SPY++ to see what it did and I must have changed some...

That’s the direction I was leaning toward but wanted to make sure before I started changing the classes. Thanks for the input.

I have a conceptual question about a generic ProgressBar form. I have a "Load" form that calls several class modules to load various Word/Excel files into dataset datatables, then process the datatables according to the business logic nedded for each table. Since the class modules are not forms...

I found my answer in the VB help - You have to explicitly add the folder and file listboxes to the “toolbox”. Search in help under FileListBox Control for info. Chris

Got a general question - Is there and way to get the FolderBrowserDialog and OpenFileDialog to show up inside a single form. The way it appears to work, I need 2 buttons on my form to display the 2 dialogs as seperate windows. I would like to have a simple form with 2 "listboxs" side-by-side to...

This is the response I received from Hitachi: Thank you for contacting Hitachi Global Storage Technologies. Typically Apple drives will have different firmware however normally the change is not sufficient to cause the drive to not work in an IBM PC system. If the drive is not working in...

Tried that, but I'm going to try something different tonight. One laptop freezes when it tries to identify the hard drive and the other (more stable) says no boot drive. Both PC's had CD-Rom as the primary boot drive but it can't get past the drive initialization. I think the drive is dead, but...

No jumpers so it's the master. I've been building PC's for 15 years and this is the first time I've seen a HD with Apple Firmware. I suspect that the EBAY seller has a large shipment and is selling them without even knowing he has a mixed bag. I checked his history and everything was ok - but in...

I think I have a simple question. I bought a 40 gig Hitachi Travelstar on Ebay - popped it into my Windows XP laptop and the system freezes when it tries to boot. In looking over the label, I noticed it has an Apple logo and Apple HDD firmware 2003 on it. Does that mean this I bought a HDD that...

The Word document contains text as well as 500+ tables. some of the tables have the same format (columns types) but most look a little different. Want I need to do is export the tables into a format that I can put into an Access database or put them directly into Access (prefered). All of the...

I have a document with 500+ tables. I want to export the tables into an Access database. Can this be done using XML as a transport. I don't want to have to define each table in the VBA code as that would take to long. Any ideas on the easiest way to copy lots o word tables to Access? Thanks,