Search:

Well, what do you considder a project manager?

In my opinion, it really doesn't matter as it is not the function/role of the project manager to be dealing with the technical details. The program...

You can also use the Microsoft.Office.Interop namespace to interact with Excel directly, which will give you a much greater control on how you can transfer the data. You will need to add a reference...

You can use the SHGetFolderPath API to get the desktop folder.



Private Const CSIDL_DESKTOPDIRECTORY As Long = &H10
Private Declare Function SHGetFolderPath Lib "shfolder" _
Alias...

Perfect, works like a charm :)

Thanks!

A ParamArray is used to define a unknown amount of parameters, not to pass a parameter.

The declaration of the function should be this:


Public Function max(a() as Integer) As Integer

I'm trying to call a C++ API function, which takes two parameters. The function will fill these 2 parameters. The first parameter will be a list of a specific structure, the second will be a number...

Ok, that clears up a lot.
I found an example on PSC to call cdecl dll's from VB, but it keeps complaining about a wrong parameter type i'm passing (the WRAPI_NDIS_DEVICE).
I'll play with it some...

You are returning an object, zso you will need to assign the return value using the Set command


public Function Executequery(sql As String) As Object
dim Rs As New Adodb.recordset
Set...

Dir() returns wrapi.dll

As for the special characters when copy/pasting, since I only had the c++ header file to go on, I had to type the declaration myself, so that rules out any invalid...

Tried that, same result.
It would be rather strange if it did, since that way I would have to make sure the dll had to be in that exact location if installed on another machine.

Dim ie(2) As Object 'whatever datatype
Dim i As Integer

For i = 0 To UBound(ie)
Set ie(i) = CreateObject("InternetExplorer.Application")
ie(i).navigate address2
ie(i).Visible =...

I'm trying to use WRAPI in VB, but I can't manage to get it working.
I downloaded the dll and lib from http://sysnet.ucsd.edu/pawn/wrapi/download.html

The source files contain a header file,...

Maybe you can use an application like BGInfo

http://www.sysinternals.com/ntw2k/freeware/bginfo.shtml

Well, if you need to be able to take a screenshot, you will have to have a program running on that computer (preferable one that you can connect to through winsock or so). In that case, you could...

Another option is to have your program start hidden, and have it check to see if the other program is running. Once you find the program running, you unhide your program and start regular execution...

That is indeed the way to do that in VB.
In order to be able to sort on a date correctly, you will need to store it in the form YYYYMMDD.

AFAIK that isn't possible. SQL Server does know a datatype table, which can be used to pass in memory tables from 1 proc to another, but there's no way you can pass them from VB to SQL Server in 1...

vbNullString is slightly faster than "", since vbNullString is not actually a string, but a constant set to 0 bytes, whereas "" is a string (consuming at least 4-6 bytes for just existing).

You can't make a portion of the form transparent, so you will have to change the shape of the form to fit the shape of the image. This can be done throught hte use of some API functions.

This...

If your dates are stored in 1 field (which I presume will be the case), you can use the DATEPART function.


SELECT Sum(Amount)
FROM TableName
WHERE DATEPART(Year, DateField) = 2004
AND...

Make sure the files are writable. VSS will save the files readonly.

The Kill function in VB is used to delete a file, not to terminate a process.
To terminate a process, you will need to make use of API functions. Here's an example:


Private Declare Function...

Indeed, basically if you don't need to pass them ByRef, then pass them ByVal.
Unlike one would think, ByVal is actually faster than ByRef because it does not need to pass back the data in the...

I think the problem lies in the declaration of the SetControls function you wrote.
Make sure you explicitly declare the parameter that accepts the frame to either Frame or Object. Not declaring the...

First of, the First If statement will always be True, You cannot pass more than 1 value to an =, so the second sckConnecting will be evaluated by itself, and since it's not 0, this will always be...