Search:

You can use Shell to call winzip and pass commandline parameters
Have a look at http://www.winzip.com/xcmdline.htm
Also have a look at the FindExecutable API to find the winzip exe on a system

Download the API guide from http://www.allapi.net/agnet/appdown.shtml
It has good examples of most of APi functions (If not all of them) including GetAsyncKeyState.
It's a handy tool to have anyway

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q86688

http://groups.google.com/groups?q=list+sql+servers+vb&hl=en&selm=OYT4HmrEAHA.218%40cppssbbsa02.microsoft.com&rnum=1

Go to http://hem.spray.se/mattias.sjogren/samples_en/index.html

And look at the VBBubble Sample (3rd one down)

You could do something like this

Dim Mystr as string
for i = 0 to List1.ListCount - 1
Mystr = Mystr & List1.List(i) & vbCrLf
next
Clipboard.Clear
Clipboard.SetText Mystr

Set the pattern property of the filelistbox to *.xls

Only if the UNIX box has a windows emulator on it
have a look at http://www.winehq.com/

Sorry mate but I don't have Win2K here and it works fine for me on NT4

Go to http://www.vbbox.com/codebox.htm
and download the Owner Drawn Banner Menu Sample.
It should get you started, the only thing is that you may have to add the app.res resource file in manually...

I'm sure that there are hyperlink controls out there but you can mimic them with labels

private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (byval hwnd as Long, byval...

There is a sleep API
Add this to a module

public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (byval dwMilliseconds as Long)



Then you can just say

Sleep 100

Its probably because you're using a server side cursor.
Put
DB.CursorLocation = adUseClient
in your code and see if that works

If you set the KeyPreview property of the form to True then you can use this code

private Sub Form_KeyDown(KeyCode as Integer, Shift as Integer)
If KeyCode = vbKeyF5 then
'Put your code here...

MsgBox date 'Gives date
MsgBox time 'Gives time
MsgBox Now 'Gives date and time

Dim Ctl as Control
for each Ctl In me.Controls
If Typeof ctl is textbox then
ctl.locked=false
end if
next

private Type POINTAPI
X as Long
Y as Long
End Type

private Declare Function SetCursorPos Lib "user32" (byval X as Long, byval Y as Long) as Long
private Declare Function GetCursorPos...

http://www.vbaccelerator.com/codelib/inireg/registry.htm

You could download the CRegistry class from http://www.vbaccelerator.com

and then use this code to get the values for the uninstallstring

Dim c as new cRegistry
Dim sKeys() as string,...

You can use Microsoft help work workshop to create a .hlp file or HTML Help Workshop to create a .chm file.
Have a look at http://www.mvps.org/htmlhelpcenter For help on HTML Help

You have probably got your view set to "Procedure View".In the bottom left of the code window beside the horizontal scrollbar there are two buttons. One for procedure view and one for full module...

Yep your right I just tested it and even when I use the GetLastError API it tells me it completed successfully. Strange...
Sorry I have no othere suggestions

Isn't it the other way round. If it fails it returns 0 and non-zero if it succeeds.
Also by the way you should declare nResult as a Long because that is what the function returns

I presume you're talking about a pass through Query, so you should put the connection parameters in to the "ODBC Connect Str" property of the query.

As far as I know you can't because attachments are not part of the mailto protocol.
Have a look at http://www.cis.ohio-state.edu/cgi-bin/rfc/rfc2368.html