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

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

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

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

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

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

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

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,

Is it possible for Oracle 10g running on a Unix platform to connect to a Microsoft Access database. I will be receiving 500+ tables from my user in an Access database and I need an easy way to load the data. The Access database will start out on a windows desktop but needs to be moved to a...

What is the better approach. I am starting a new project where my team gets to create a Data Warehouse database that will be called by various server applications to retrieve data. The database will end up being a 100+ tables due to the DBA's normalizing the structures and I don't want the...

I'm at the end of a long development cycle, starting to develop the user reports, and I finally noticed that the reporting capabilities in .net standard leaves a lot to be desired. I'm looking into either upgrading to PRO or buying a 3rd party reporting tool to help build my reports. If I use...

Does anyone know if I can specify a 2 line header in a datagrid. I have a column in a dataset that is a sequence number. I set up my columnstyles and everything works ok, however, the sequence number is only 6 digits long and I waste a lot of width displaying "Sequence Number" as the header. I...

I have a Windows Form app with no user interface that spins through Outlook checking for specific emails. It processes attached text files into an Oracle database abd put's log entries into a text file as appropriate. I have a System.Threading.Thread.Sleep(SleepSeconds * 1000) statement to put...

I understand the need for the annoying message box that appears when you attempt to access certain fields when you programmatically send an email so I changed my application to build a new Mail Item and open it in Outlook. The user then sends it the normal way by clicking Send. Annoying, but it...

Simple Question - How to you change the status of an unread email in outlook once you have finished processing it? I seem the be processing the same unread mail item over and over. Must be too late and I'm having a brain fart. Thanks for the help.

Hello all, I have found several references to creating a service, however, I am still confused as to exactly how, and if I can even create a Service process using VB .Net Standard edition. Since I am not able to create a Service Project on the Create/New/Projects, I am not certain what I need...

I have a stored procedure passing in the variables I want inserted. The key is a generated Sequence number that I want returned if the insert was successful. Normal INSERT INTO... Values (@..., @,,,); . Then I issue a Set @newRec = Select @@Identity. The @newRec is defined as a passed variable...

Simple question but I must not be doing something right. In Form1: Dim F2 as new Form2 f2.MdiParent = Me f2.Show In Form2: Me.Close() If I then loop through the MdiChilden of Form1, f2 is still referenced and if I do a .Show() it will show back up. How do I destroy f2 in the Form1 class?

I have tried every solution I can think of, but I would like the know the "correct" way to handle a simple multiple form / command button processing application. The application displays a "main Menu" that the user selects functions (add record, generate reports, system maintenance, etc..), then...