dcsimg

Search:

Type: Posts; User: Leather

Page 1 of 13 1 2 3 4

Search: Search took 0.34 seconds.

  1. Dynamically load the instances of controls ass...

    Dynamically load the instances of controls ass needed...
  2. Replies
    7
    Views
    424

    Change the variable to a property on an object.....

    Change the variable to a property on an object.. then in the property let/set run your code... Objects! its the way to go..
  3. Replies
    13
    Views
    384

    You need to change the instancing property of the...

    You need to change the instancing property of the class to a public type....

    When a project has a public class module, it can (even though you are not) be referenced from an external project. This...
  4. Replies
    13
    Views
    384

    If you define a method in a class in an ActiveX...

    If you define a method in a class in an ActiveX DLL or Exe that takes UDts as parameters then the UDT must be defined as PUBLIC in a Class Module, otherwise the UDT is invisible outside of the...
  5. Replies
    24
    Views
    538

    Using your method, if a pc goes down before...

    Using your method, if a pc goes down before renaming the file back to its original name, it will never be available again....
  6. Replies
    24
    Views
    538

    You should be opening the file EXCLUSIVELY......

    You should be opening the file EXCLUSIVELY... Then the other apps will get a trappable error when they try and open it. That what file locks are for....
  7. Replies
    2
    Views
    288

    Use: rs.Sort "Field1"

    Use:

    rs.Sort "Field1"
  8. Thread: deleting

    by Leather
    Replies
    2
    Views
    271

    Loop trhough the file and remove the record, then...

    Loop trhough the file and remove the record, then rewrite the file...
  9. Thread: Union

    by Leather
    Replies
    1
    Views
    230

    The same way you do on SQL server... SELECT *...

    The same way you do on SQL server...

    SELECT * FROM TAB1

    UNION

    SELECT * FROM TAB2

    The results from the 2 statements must have the same number and type of columns..
  10. Thread: memory leakage

    by Leather
    Replies
    2
    Views
    223

    Add debug statements to every class...

    Add debug statements to every class initialise/terminate event, and form initialise/terminate event...

    You can then see which objects are not being destroyed..
  11. Replies
    4
    Views
    402

    Create an ODBC connection to the server, then...

    Create an ODBC connection to the server, then create a con sting to connect to the odbc..

    OR

    Create a connection string to connect directly to the server...
    (You may need to do some...
  12. Replies
    5
    Views
    408

    If your using an access DB then just use a UNC...

    If your using an access DB then just use a UNC path, like this:

    \\PC_Name\ShareName\MyDatabase.mdb
  13. Replies
    5
    Views
    408

    If your using SQL server then the connection...

    If your using SQL server then the connection string has the server name, db etc in it...
  14. Replies
    3
    Views
    469

    Use the GetPrivateProfileSection API call, it...

    Use the GetPrivateProfileSection API call, it will return all entries in an ini file under a particular section:

    Private Declare Function GetPrivateProfileSection Lib "kernel32" Alias...
  15. Replies
    6
    Views
    291

    Just generate a script file from SQL server then...

    Just generate a script file from SQL server then run it against the new server...
  16. Thanks Shawn N, but i'm afraid this doesn't work...

    Thanks Shawn N, but i'm afraid this doesn't work with the data combo...

    Any other ideas?
  17. Detect if a Combo box is currently dropped?

    Hi all,

    Does anyone know a way to detect if a DataCombo is currently dropped?
  18. Replies
    5
    Views
    351

    Thanks "1 is a prime" but i don't want to loop...

    Thanks "1 is a prime" but i don't want to loop through, that is why I mentioned the SendMessage API..

    Not to worry, I think I am getting there slowly...

    I am going to have to use post message,...
  19. Replies
    5
    Views
    351

    Finding Match in DATA combo?

    Hi All,

    I need to find the closest match in a DataCombo control..

    I normally use the SendMessage API for standard combo's, but this doesn't seem to work with data bound combo controls..

    Any...
  20. Yes you can, but you will need the OLEDB provider...

    Yes you can, but you will need the OLEDB provider installed...

    The easiest way is to install MDAC_TYP.Exe
  21. Replies
    3
    Views
    238

    Just call it... Form1_Load However it may...

    Just call it...

    Form1_Load


    However it may make more sense to put this load routine into another sub that can be called from the form load, and when you go back to form 1 from form2

    eg:
    ...
  22. Oh, ok, MTS DLL's are not designed for this.....

    Oh, ok, MTS DLL's are not designed for this.. they are suppoed to be stateless...
  23. Replies
    1
    Views
    285

    Use absolute positioning... EG, say the user...

    Use absolute positioning...

    EG, say the user is viewing record 9, and they click > then submit 9 and move next..

    In your ASP source open the recordset, and move the required number of records.....
  24. Replies
    17
    Views
    673

    Ok, so what are you saying? that ODBC is more...

    Ok, so what are you saying? that ODBC is more secure than OLEDB???

    With regard to SQL server this is simply not true... also a machine DSN can be used by ANYONE who can get to the machine!
  25. MTS handle transactions for you... (Enlisting the...

    MTS handle transactions for you... (Enlisting the help of MTC) so there is no need for Begin / Commit blocks... just SetComplete... SetAbort...

    If you are running DLL's on another server then you...
  26. Replies
    17
    Views
    673

    OLEDB providers for both access and SQL server...

    OLEDB providers for both access and SQL server offer better performace than connecting to them via ODBC...

    Why go to all the hassle of setting up a DSN when you can just use OLEDB - which is...
  27. Thread: Dsn??

    by Leather
    Replies
    3
    Views
    374

    There are sopme API calls to create a DSN... ...

    There are sopme API calls to create a DSN...



    '--- API Declarations.


    Private Const ODBC_ADD_DSN = 1 ' Add data source
    Private Const ODBC_CONFIG_DSN = 2 ' Configure (edit) data...
  28. Just to clarify: You are using an access db? ...

    Just to clarify: You are using an access db?

    Some people refer to Identity columns in SQL server as "AutoNumber" fields.. And these can be updated.
  29. When teh error occurs choose to debug and try the...

    When teh error occurs choose to debug and try the following in the immediate window:


    ? rs.Fields("CustomerAddressID").value

    and see what you get
  30. Thread: need help!

    by Leather
    Replies
    8
    Views
    273

    You need to get hold of Fusion (Allows all vb...

    You need to get hold of Fusion (Allows all vb runtimes to be compacted into the exe!) or use a .Local file to get vb to pick up local copies of all the dlls needed....
  31. Thread: VB6 and VB.Net

    by Leather
    Replies
    2
    Views
    276

    Yes, I have done this at home, and both .NET and...

    Yes, I have done this at home, and both .NET and vb6 both continue to work correctly without any probs..
  32. Replies
    4
    Views
    373

    Use your own binary file format then.. that way...

    Use your own binary file format then.. that way you won't haveto ship it with any additional DLL/ocx's...
  33. Replies
    8
    Views
    364

    With NEARLY ALL RDBMS (Access + SQL Server...

    With NEARLY ALL RDBMS (Access + SQL Server included) you can only delete from ONE and ONLY ONE table at a time, EVER...
  34. You shouldnt need a form, (You can dump them...

    You shouldnt need a form, (You can dump them straight on a web page if u like)...
  35. Replies
    15
    Views
    449

    This Dim cn As ADODB.Connection Dim strCn...

    This



    Dim cn As ADODB.Connection
    Dim strCn As String

    strCn = "Provider=SQLOLEDB.1;" & _
    "Data Source=<SequelServerHere>;" & _
    "Initial Catalog=<DatabaseHere>;" & _
  36. Thread: Vb/db

    by Leather
    Replies
    10
    Views
    353

    You just loop through each collection (IE:...

    You just loop through each collection (IE: Tables, Views etc, and copy them over)..
  37. Thread: TABCTL32.ocx

    by Leather
    Replies
    12
    Views
    1,449

    They are both the same in terms of compatibility!...

    They are both the same in terms of compatibility! An activeX ocx in reality is just a COM Dll....

    ANYWAY, where did I say DLL?? I said control...
  38. If you can't find a way round it, and you don;t...

    If you can't find a way round it, and you don;t want to use a timer, use the Sleep API.
  39. Thread: TABCTL32.ocx

    by Leather
    Replies
    12
    Views
    1,449

    No - When you release a new version of a...

    No - When you release a new version of a component you can decide whether or not you want to BREAK COMPATIBILITY...

    Just because you release a new version of an activeX control does not...
  40. Thread: TABCTL32.ocx

    by Leather
    Replies
    12
    Views
    1,449

    Exactly what it says.. If you have 2 versions of...

    Exactly what it says.. If you have 2 versions of a control, and one is not Binary Compatible with the other then they have different component and class GUIDs..
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width