Search:

Dynamically load the instances of controls ass needed...

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

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

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

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

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

Use:

rs.Sort "Field1"

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

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

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

You can then see which objects are not being destroyed..

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

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

\\PC_Name\ShareName\MyDatabase.mdb

If your using SQL server then the connection string has the server name, db etc in 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...

Just generate a script file from SQL server then run it against the new server...

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

Any other ideas?

Hi all,

Does anyone know a way to detect if a DataCombo is currently dropped?

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

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

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

The easiest way is to install MDAC_TYP.Exe

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

Oh, ok, MTS DLL's are not designed for this.. they are suppoed to be stateless...

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

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!

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

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

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

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.

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


? rs.Fields("CustomerAddressID").value

and see what you get

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

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

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

With NEARLY ALL RDBMS (Access + SQL Server included) you can only delete from ONE and ONLY ONE table at a time, EVER...

You shouldnt need a form, (You can dump them straight on a web page if u like)...

This



Dim cn As ADODB.Connection
Dim strCn As String

strCn = "Provider=SQLOLEDB.1;" & _
"Data Source=<SequelServerHere>;" & _
"Initial Catalog=<DatabaseHere>;" & _

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

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

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

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

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