Search results for query: *

Hi to all. Here are the facts: I have 3 variables declared as Global Objects in a module: OraSession OraDatabase OraRecordset Here is the code: Private Sub LoadGrid() Dim sSQL As String Dim sData As String Set OraSession = CreateObject("OracleInProcServer.XOraSession")...

You might need to redo your package and specify the dependencies of some files. As for the line, I think it is there by default. ''Life is like a box of chocolate...''

Hi Bob. Thanks for the tips. Actually, I'm not too fond of the format, but like you said, I'm new to Oracle. I know there is a lot to know about it, so I guess I should get my hands on everything that comes my way. What is good though, from what you said, is the fact that they tell you a lot...

To do that, you will need: a) a DriveListBox (Drive1) b) a DirListBox (Dir1) c) a FileListBox (File1) d) a TextBox (txtChoice) Then: Private Sub Drive1_Change() On Error Resume Next Dir1.Path = Drive1.Drive End Sub Private Sub Dir1_Change() Dim sFile As String File1.Path =...

Hi to all. I'm just wondering if the information contained in the OLN (Oracle Learning Network) is worth. I checked a free video, but it lasted only 5 minutes. I'll be working with Oracle 8i in 2 weeks, and in the last 3 months, I purchased 6 books on Orale (DBA, PL/SQL, Tuning, Recovery...

vr9.com is also a free web hosting to consider. They are growing very fast and keep on trying to improve an already pretty neat package. ''Life is like a box of chocolate...''

Hi Terry. There is absolutly nothing to fear. Oracle will take it no problem. ''Life is like a box of chocolate...''

If your database is in access, then compacting it will buy you some time. But if it is really growing fast, then you should really consider switching to Oracle or SQLServer. ''Life is like a box of chocolate...''

Why don't you just make your querry on the city? (with some Inner Joints) then, x = rst1.RecordCount ''Life is like a box of chocolate...''

No problem... Just hope it helped you get through ''Life is like a box of chocolate...''

Got my answer ''Life is like a box of chocolate...''

The best one would probably be Seagate's Crystal Report. ''Life is like a box of chocolate...''

Hi to all. We are in the process of having Oracle 8i at work. It has been approved, but only with 10 users(connections). I know that within 3 months we'll need more than 20. Since Oracle requires at least 20 users to reside on a two processor server, here's my question. Does Oracle need any...

Hi elecrta, use the following code: Private Sub LoadGrid() Dim wk As Workspace Dim db As Database Dim rs As Recordset Dim sSQL As String Dim sData As String Set gWk = CreateWorkspace("Data", "admin", "",dbUseJet) Set gDb =...

Hi to all Sheffield's code is good. But when you close a recordset, you should always use this code right after: Set rs = Nothing ''Life is like a box of chocolate...''

Sure Ablecken. There is always 1000's of ways to do something, but I'd like to see your solution. ''Life is like a box of chocolate...''

Actually you can. You have to use the Multimedia control for that (which comes with VB). I did create one a long time ago using codes I found on the internet(it was on another forum). I think you can find some help for that on the microsoft site. Although the help file I found was specific to...

Hi tganeshven. Have you tried if all then....elseif 1 then....elseif 2 etc... If that doesn't work, show us the coding. There is a lot of people here who could easily find an answer for you. Cheers

I found a mistake in my example: Here is the right code for the function: Function OpenRecordset() As Boolean Dim sSQL As String On Error GoTo err_openrecordset sSQL = "SELECT tblX.x_id, tblx.x_name, " sSQL = sSQL & "tblx.date_arrived " sSQL = sSQL &...

Hi pe. A good way to do this, although some users don't like this, is to create a form where they will enter new client names in a text box that will populate a grid. That way, they will need to enter the name only once (this will prevent users from entering the same name differently: Mike...