Search:

Type: Posts; User: Glenn

Page 1 of 5 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    3
    Views
    551

    I agree with Cander. Just because Microsoft...

    I agree with Cander. Just because Microsoft created the Migration tool that doesn't mean you have to use it. This is a great time to take the opportunity to reengineer your applications to take...
  2. Thread: Common Controls

    by Glenn
    Replies
    5
    Views
    385

    When you open the add components box the version...

    When you open the add components box the version and service pack number is usually list on the same line as the component.
  3. Replies
    1
    Views
    355

    Are you attempting to get the recodset to point...

    Are you attempting to get the recodset to point to the new last row ? (the one that you just added). If that's what you are trying to do try:


    adodc1.movelast

    This will move the recordset to...
  4. Thread: vb5 and nt3.51

    by Glenn
    Replies
    2
    Views
    809

    What data access technology are you using RDO,...

    What data access technology are you using RDO, ADO, DAO ? My guess is that whatever technology you are using the appropriate DLL's are not on the machine that you are trying to run it.
  5. Thread: Parameters

    by Glenn
    Replies
    2
    Views
    601

    If I read what your trying fo correctly you need...

    If I read what your trying fo correctly you need to swap these two lines of code:

    For Each item In ListView1.ListItems
    If item.Selected Then
    cmdAccount.Parameters("MemberID") =...
  6. Thread: OLEDB vs. ODBC

    by Glenn
    Replies
    5
    Views
    842

    I tend to use ODBC when I don't want to put the...

    I tend to use ODBC when I don't want to put the location of the database or server in my program or in the registry or ini file.

    By using ODBC I can usually talk a user through the control panel...
  7. Thread: Crystal Reports

    by Glenn
    Replies
    2
    Views
    502

    Crystal reports is a 3rd party for generating...

    Crystal reports is a 3rd party for generating reports from many different database types. The reports can be integrated into vb by using an activex control or activex dll. A slim downed version used...
  8. Replies
    4
    Views
    664

    Are you trying to do preserve and expand the 2-D...

    Are you trying to do preserve and expand the 2-D array ? As you have found out thats not possible.

    I never tried it, but maybe you can replace you 2-D array with a one dimensional array of a...
  9. No reason to get snippy , Joacim is just trying...

    No reason to get snippy , Joacim is just trying to help you. By telling people what part isn't working allows them to help you.

    Why don't you post the code your using for the Savesetting and...
  10. Replies
    7
    Views
    470

    I'm running out of ideas. One last thought is to...

    I'm running out of ideas. One last thought is to make sure that when you install mdac and possible your app that you install under account that has local administrator privleges. If you don't you...
  11. Replies
    7
    Views
    470

    You will also need the msado15.dll file in the...

    You will also need the msado15.dll file in the distribution. This file is not part of MDAC.
  12. Replies
    7
    Views
    470

    Regarding Item 2, there is no problem installing...

    Regarding Item 2, there is no problem installing MDAC on NT 4.0 or any other O/S for that matter. What version of MDAC do you try to install. I have had enormous success with version 2.5

    :) :)
  13. Replies
    2
    Views
    489

    Are you planning on using ODBC, or SQL OLEDB ?...

    Are you planning on using ODBC, or SQL OLEDB ? Either way make sure you have the correct SQL drivers loaded.

    :) :) :)
  14. Replies
    3
    Views
    655

    Is your datagrid bound to a database using dao or...

    Is your datagrid bound to a database using dao or ado ?

    If it is, you will have to include the apropriate data access files as part of your installation. Install shield should have an option for...
  15. Replies
    4
    Views
    532

    I agree with everything that has been said. In...

    I agree with everything that has been said. In addition:

    ADO is more universal you don't have to learn multiple methods for accessing differrenent database types. For instance RDO for SQL-Server...
  16. Replies
    2
    Views
    528

    The follwing code will compact a access database:...

    The follwing code will compact a access database:


    Set JRO = New JRO.JetEngine

    lssourcedb = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" &...
  17. Replies
    0
    Views
    362

    Please post your code for we can take a look at...

    Please post your code for we can take a look at it.

    One thought is, if you are using a stored procedure to perform the insert you can return the new record id by using the @@IDENTITY variable in...
  18. Replies
    3
    Views
    498

    What database access menthod are you using RDO or...

    What database access menthod are you using RDO or ADO ?

    The format depends on the method.
  19. Thread: A SQL Question

    by Glenn
    Replies
    1
    Views
    361

    If issue a query to a server, the server has to...

    If issue a query to a server, the server has to compile that query before it can execute it.

    Stored procedures are precompiled on the server which makes them run faster.

    They also allow...
  20. Thread: Parameters

    by Glenn
    Replies
    2
    Views
    558

    From access online help: Print the criteria...

    From access online help:

    Print the criteria for a report in the report header

    1 Create the criteria parameters in the report's underlying query.

    How?

    2 Open the report in Design view....
  21. Replies
    2
    Views
    661

    Check you version of your JET OLE DB provider....

    Check you version of your JET OLE DB provider. I've been able to do it successfully using the same logic with version 4.0 of the same provider.
  22. Replies
    6
    Views
    2,088

    What database are you using MS Sql Server or ? ...

    What database are you using MS Sql Server or ?

    If you are using MS SQL Server then what version 6.5, 7.0 ?

    I've been able to read large text fields using the getchunk methods. It's kinda of...
  23. Replies
    4
    Views
    901

    I think you need to set the datasource property...

    I think you need to set the datasource property equal to the recordset RSMAIN

    Set FlexMain.DataSource = RSMain
  24. I think this is what you want: [Code] For x...

    I think this is what you want:

    [Code]

    For x = 1 To 4
    If firstofsequence(1) = secondofSequence(x) Then
    Picture1.Print firstofsequence(1) & ",";
    End If
    Next
  25. Replies
    12
    Views
    1,494

    Classes allow you to share code easily among...

    Classes allow you to share code easily among multiple projects (assuming their compiled into COM objects).

    If you encapsulate your business logic into the classes it then easy to update the...
  26. Thread: NT Service

    by Glenn
    Replies
    6
    Views
    1,029

    There is also a application on the included with...

    There is also a application on the included with the Windows NT resource kit that will run any EXE as a service.

    :) :) :)
  27. Replies
    1
    Views
    380

    All the DSNs are stored in the registry under: ...

    All the DSNs are stored in the registry under:

    HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC Data Sources

    Each DSN is listed as a value under this key. If you need more information on each...
  28. Thread: Time

    by Glenn
    Replies
    15
    Views
    649

    Unless you require a clock with seconds you don't...

    Unless you require a clock with seconds you don't need to use a timer with the status bar. Just set the style property of the panel to sbrTime.

    :):)
  29. Replies
    3
    Views
    593

    You can concatenate fields by using something...

    You can concatenate fields by using something like the following:

    SELECT FirstName + LastName AS FullName FROM table

    This will return a single column named FullName

    This works for SQL...
  30. Replies
    3
    Views
    799

    The problem with the date/time picker is that it...

    The problem with the date/time picker is that it doesn't allow blank dates without the use of that nasty checkbox.

    I use that date/time picker when I have a default date that I can load into the...
  31. Replies
    5
    Views
    1,256

    If your class modules are included as part of...

    If your class modules are included as part of your EXE (not in a DLL) you do NOT have to register them. The fact that your app loads, typically means that the OCX's are register correctly. The...
  32. Thread: Time

    by Glenn
    Replies
    15
    Views
    649

    If you just want a clock. Add a status bar...

    If you just want a clock. Add a status bar control and set one the panel to be a clock.

    :):)
  33. You could use an ini file and then use VB's...

    You could use an ini file and then use VB's functions to Read and write to the file.

    You should probably think twice about using a file for security. Unless the file is encrypted it would'nt take...
  34. Replies
    3
    Views
    593

    Unfortunately MS in it's infinite wisdom has seen...

    Unfortunately MS in it's infinite wisdom has seen not to provide the same combo box to VB as it does for Access. Combox boxes in VB only support 1 field. The only way to get multiple fields into a VB...
  35. Replies
    34
    Views
    2,250

    I started out writing Fortran in college. 2 years...

    I started out writing Fortran in college. 2 years

    At my first job, I wrote Fortran, C, Pascal and VB 3.
    13 years

    Current Job VB 5 - VB 6 3+ years

    Total: 18+ years
    I guess I've been...
  36. Replies
    2
    Views
    408

    In the compile tab you want to set the OCX to...

    In the compile tab you want to set the OCX to binary compatibility. When this is set, VB checks your OCX with a previous version of the OCX for compatbility. As long as you haven't removed any...
  37. Replies
    5
    Views
    756

    One way to do it is to declare a flag that you...

    One way to do it is to declare a flag that you set before you "click the button in code". Then in the click_event of the button, check for the flag and don't do anything if it's set. Reset the flag...
  38. Replies
    1
    Views
    347

    Heres how to do it. I did'nt write this code but...

    Heres how to do it. I did'nt write this code but it should work.

    Compact and repair databases via ADO's JRO

    In a previous tip (Compact and repair Jet databases with DAO), we showed
    you how to...
  39. Replies
    7
    Views
    675

    JHausmann you are correct (give that man a cigar...

    JHausmann you are correct (give that man a cigar :)). Undeclared variables are treated as variants. They tend to be slower because VB has to figure out the storage at runtime, instead of compile...
  40. Replies
    2
    Views
    508

    I was able to do it by writing 2 queries in...

    I was able to do it by writing 2 queries in Access. The first queries determines which price is higher. The second query references the first one and simply counts the records. Here's the SQL for the...
Results 1 to 40 of 167
Page 1 of 5 1 2 3 4



Click Here to Expand Forum to Full Width