Search:
Type: Posts; User: Leather
Search:
Search took 0.47 seconds.
-
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....
-
-
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..
|
Click Here to Expand Forum to Full Width
|