Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dzidze

    VB-Oracle - MoveFirst does not work

    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")...
  2. Dzidze

    Newbie Problem pleeeez help Error occurs

    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...''
  3. Dzidze

    Is OLN worth it?

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

    Problem with Browse Button Control

    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 =...
  5. Dzidze

    Is OLN worth it?

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

    Who are good host

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

    Very easy technical question

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

    Can a Database Be Larger Then 1GB?

    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...''
  9. Dzidze

    querying a recordset

    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...''
  10. Dzidze

    Access with SQL

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

    Very easy technical question

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

    Report Writer

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

    Very easy technical question

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

    Access with SQL

    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 =...
  15. Dzidze

    vb 6 sql variable problem

    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...''
  16. Dzidze

    How to play an mp3 file

    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...''
  17. Dzidze

    How to play an mp3 file

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

    Data Environment - Passing Arguments at runtime for a command

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

    VBA CODE - HELP

    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 &...
  20. Dzidze

    Need some basic help on VB6 to access

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

Part and Inventory Search

Back
Top