Recent content by modfather

johnherman, Thanks for your reply. I kind of assumed that, but procedures have to be called, right? In other words, if I have many procedures/functions in my package, and they do certain functionality, that isn't performed until the procedure/function is called, right? If that's the case...

I hope this isn't posted to the wrong area - my apologies if so. My question is very basic: In PL/SQL, what determines where the program "begins"? I understand that there is three sections: declaritive, executable, and exception. From the VERY brief reading I've done (yes, I'm brand new to...

By the way, I should have mentioned that we have edited existing reports with Oracle Reports 6i. If there's anything else I can provide to get suggestions, I'd be happy to do so. Thanks. Steve

Ok, I'm a real newbie here, so please be gentle. :) We're in the middle of an implementation of Oracle 9i and Oracle Application 11i. There are a few reports such as Invoices, Purchase Orders, AP Checks, etc. that we'd like to do a bit of customization to. We have made small changes using...

Thanks so much! I almost am there. The only problem is: There's two "Suppress" boxes. I assume I click one. One is labeled "Suppress (No Drill-Down)" and one is "Suppress Blank Section". I assume it's the first, but when I click the "x+2" button for my formula, I'm not sure what to put in...

Hi. I'm sure this question's been asked before, but have no idea how to look for it. I'm using Crystal v8 and am a bit of a newbie. I have a fairly simple report that works great, however in the detail area, I want to show certain fields when a certain condition is true. I figured out how to...

Riverguy, You're 100% right. I apologize. I plan to be a bit more focused later today. :) As far as the PrintReport sub, it's just a sub that was used with an older version of Crystal Reports to actually just print the results... Anyway, sorry for the bad post. I was going to be out...

Rob, Thanks for the tips. I guess my main concern is: I want to do this right, and using DAO is now dead. I have other another module I did that uses DataTables and works great, but that's a form. This is primarily just computing a few things to populate a database table. The real problem I...

I'm hoping someone can help me out. I'm trying to convert the code below from VB6 to VB.NET. I'm not sure of the best way to go. This is basically a simple application to do scoring for a competition. I'm using an Access database and all of this code happens "behind the scenes&quot...

I'm hoping there's someone generous enough to help me out with about 15 minutes of their time. I'm re-writing an application I originally designed in VB6 in VB.NET w/Access 2003. I'm doing it for free for a dance company my daughter is a member of. My problem is: I seem to be falling back...

Brian, Thanks a bunch! Unfortunately, I'm not using a DataGrid, but I got this working yesterday: Private Sub txtCompetitor_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtCompetitor.Leave txtName.Text = dr.GetString(0) & ", " & dr.GetString(1) Dim...

Sorry for my ignorance, but I can't find anywhere in my books or elsewhere how to do that. Any pointers on where I could look?

Thanks for your reply! Both fair questions - :) To explain better: I'm dealing with 10 text boxes. However, this is NOT a datagrid, just a traditional application form. I don't have any need for navigation between records because the first two textboxes are for a competition number and a...

You can't go wrong with: Micorosft ADO.NET Core Reference by David Sceppa ISBN: 0735614237 Seems to be the favorite of most, and I use it constantly.

I'm looking for opinions/suggestions. Please help! :) I'm a newbie, so please be gentle. I have a simple windows application that has ten text boxes. They are: txtCompetition, txtCompetitor, and eight scores: txtScore1...txtScore8, etc. There's also a save button. The first two text boxes...